Hide Dataset Fields from Lens and Dashboard

By default, all dataset fields are available in the UI. But you can hide fields so that users can’t select them when building queries and dashboards.

Although hidden fields aren’t available in the interface, users can still manually add them in dashboard JSON and SAQL queries. Users can also access the fields with the CRM Analytics REST API.

Note

For example, the Opportunity.StageName field appears in the explorer.

When creating a grouping in explorer, you can see the Opportunity.StageName dataset field.

To hide the field, modify the XMD as shown in the following text.

1"dimensions": [{
2		"field": "Opportunity.StageName",
3		"showInExplorer": false
4	}],

To show the field, set showInExplorer to true.

Note

After applying the change, the field is no longer available for selection.

The Opportunity.StageName dataset field is no longer available.

See Also

Dimensions and Derived Dimensions in XMD
Measures and Derived Measures in XMD