Hidden Data Items

Cory Fifield -

Trouble viewing images? Click on images to enlarge.

 

The Hidden Data Items can be used to perform various data operations by measures or dimensions that do not directly take part in the visual representation of the data.

To create hidden data items, choose the required data field from the fields list and drop it onto the appropriate section in the Hidden Data Items area.

mceclip0.png

 

You can perform the following operations using hidden data items.

  • Filter
  • Sort
  • Top N

 

Filtering

To filter using the hidden data item dimension, you need to first drag the field you want to filter on into the Dimension value under Hidden Data Items. For this lesson, use the OrderDate field set to (Quarter).

 

mceclip2.png

 

You can use hidden dimensions to apply filtering to the dashboard element. To do this, select the hidden dimension in the Filter Editor (right click on the element to apply filter) and specify the condition.

 

HDIDimension3.png

For instance, the image above filters by the second quarter of the Order Date (Quarter) dimension.

 

Sort

You can sort your data using the hidden measure. To do this, drag the fields you would like to sort by into the measure value. Then click the drop down on the value you want to sort and select the new measure from the Sort By sub-menu.

 mceclip3.png

 

Top N

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

 

mceclip4.png

 

For instance, in the Grid element below, the top 3categories for the Freight hidden measure are displayed.

mceclip5.png

Have more questions? Submit a request

Comments