Skip to main content

Hidden Data Items

  • 2 minutes to read

The HIDDEN DATA ITEMS area can be used to perform various data shaping and analysis operations by measures or dimensions that do not directly take part in the visual representation of data.

To create hidden data items, choose the required data field from the Data Source Browser and drop it onto the appropriate section in the HIDDEN DATA ITEMS area. To add and remove hidden data items in code, use the DataDashboardItem.HiddenDimensions and DataDashboardItem.HiddenMeasures properties.

You can perform the following operations using hidden data items.

Filtering

You can use hidden dimensions to apply filtering to the dashboard item. To do this, select the required hidden dimension in the Filter Editor dialog and specify the required condition.

HiddenDimension_Filtering

In the picture above the Grid is filtered by year: 2016 of the CurrentDate(Year) dimension.

Sorting

You can sort values of the specified dimension by the hidden measure. To do this, select the required measure from the dimension’s Sort By sub-menu.

HiddenMeasure_Sorting

For instance, categories displayed in the Grid on the image above are sorted by values of the hidden Quantity (Sum) measure.

Top N

You can use hidden measures in Top N conditions. To do this, select the required measure from the Measure combo box in the Top N Values dialog.

HiddenMeasure_TopN

For instance, the Grid on the image above displays top 5 categories for the Quantity (Sum) hidden measure.

Conditional Formatting

You can create format rules based on hidden measures to apply conditional formatting to elements corresponding to visible values. To do this, use the Add Format Rule menu of the hidden measure.

HiddenMeasure_ConditionalFormatting

For the Expression format condition, you can use the required hidden measure in the same manner as in the Filter Editor dialog.

See Also