Hiding fields from analysis

You can hide data fields that you do not want available when building visualizations in sheet view or in insight advisor. You might, for example, have fields that are only used for calculating another field. You can hide these fields in Data manager so that they are not available in the assets panel of sheets or from insight advisor but remain available in Data manager and Data load editor.

When hiding a field, all existing relationships the field has, such as associations or use in calculations, will be maintained. If a field is currently in use, such as in a master item or in an existing chart, it will continue to be available there, but will not be available for use in new master items or visualizations.

Note:

You can view all your hidden fields in Data manager by going into Data load editor, and opening the auto-generated section. All hidden fields will be listed as TAG FIELD <field name> WITH '$hidden';.

Hiding a field from analysis

Do the following:

  1. Click on Ô above the field heading.

  2. Click Hide in Analysis.

The field is now hidden in sheet view and in insight advisor. Hidden fields have added above the field heading.

Showing a hidden field

Do the following:

  1. Click on Ô or above the field heading.
  2. Click Show in Analysis.

The field is now available in sheet view and in insight advisor.

Did this information help you?

Thanks for letting us know. Is there anything you'd like to tell us about this topic?

Can you tell us why it did not help you and how we can improve it?