Vizlib Home Try Vizlib
Welcome
Login

Vizlib Custom Report Properties - Grouping Dimensions and Measures

As of version 3.4.0 it is possible to group dimensions and measures by using master item tags. For larger data sets this provides a way of structuring the data and make it easier for the users to find what they are looking for. 

Important note: For performance reasons still consider dividing your data in multiple data-sets so that they are "safe" even when users select many dimensions and measures. You can find out more about performance in Vizlib Custom Report here.


TABLE OF CONTENTS


Setup


Make sure your data set uses master items for all dimensions and measures. All dimensions and measures you want to group have to look like this with the link icon active and dimension grayed out (Figure 1). 


Figure 1: Master Item


Any Dimensions and measures that are not master items will be listed as Uncategorized.


Add tags to the master items you want to group (Figure 2). 




Enable groups in your Custom Report Data Set(s) (Figure 3). 




Back to Contents


Changing the prefix


The default prefix is cr_group_ (Figure 4). Any prefix can be used but be sure to choose prefixes that don't clash with each other. (For example using both Group and Group2 is not a great idea since the tag Group2 will be interpreted as the group name 2 for the Group prefix.)



If the prefix is left blank the Custom Report will pick up all tags and use them as groups. This might come in handy for applications where no other tags are used on the Master Items.


Back to Contents


Uncategorized dimensions and measures


It is possible to select any Uncategorized dimensions and measures not to be shown in the Custom Report. This also allows developers to use the same data set in multiple Custom Report setups. 



Alternatively all dimensions and measures can be picked up and then any master items with tags NOT matching the prefix will be put in the group for Uncategorized. The label for this group can be changed using text or an expression.



Back to Contents


Sorting groups


All groups that have been added can be sorted in any order you like. Simply click the Sort Groups button to open the sorting page. Drag and drop values to sort them (Figure 5). 




Figure 5: Sort Groups

Back to Contents


Styling options


Settings for styling are available in the sub-sections Groups dimension menu and Groups measure menu. Settings include selections for text and background color as well as sizing options.


Figure 6: Groups Menu


Note that it is possible to indent the dimensions and measures (Figure 7). This setting is made in the dimension and measure menu settings respectively.


Figure 7: Indentation of Measures


Back to Contents


Hiding first group label


To allow the most important selections to be listed first, without at label, it is possible to hide the first label for both dimensions and measures. Simply click the appropriate check-box and the first group will be hidden regardless of which one it is (Figure 8). 


 Figure 8: Hiding Groups


Tip: Use this option for a maximum of dimensions or measures that are used more often than others. Do not use it for a large number of items since the groups will then typically be hidden further below in the list and will be hard to find. It can also be used to list all uncategorized items first (Figure 9).



Back to Contents


Selections for Groups


If you've selected a group item, you'll see an indicator next to it (Figure 10), which will make it easier for the user to find selections that have been made.


Figure 10: Selection Indicator


Back to Contents



M
Michael is the author of this solution article.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.