Visualize - Hidden Data Items

Cory Fifield -

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.

DataItemsHidden.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 Order Date field set to (Quarter).

 

HDIDimension.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.

 

Visualize-Training_Sort.gif

For instance, in the Grid element above, fields are sorted by the values of the hidden measure.

 

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.

 

Visualize-Training_TopN.gif

For instance, in the Grid element above, the top 2 categories for the Shipping Fee hidden measure are displayed.

Have more questions? Submit a request

Comments

Powered by Zendesk