A table chart is a powerful visualization when you want to focus on a segment and look at all its metrics side-by-side in a single row.
Sorting lets you decide how to order your data. It is a global control located in the chart under the ‘Sort’ menu.
Decision 1: Grouped View vs Ungrouped View
The Ungrouped View removes all hierarchy and makes the table flat. A flat table treats each data point as its own row.
The Grouped View preserves the hierarchy of the breakdowns applied to the report. It shows you segments within a breakdown as displayed below. This view is only applicable when you have 2 or more breakdowns.
Decision 2: Sorting Type
In the ungrouped view, you can choose one value to sort on. The two options are:
- Sort by a specific metric value OR
- Sort by a segment column (alphabetical)
In the grouped view, you can specify the sorting for each breakdown separately. For each breakdown, you can select to sort by a specific metric or alphabetically.
Sorting is applied within the grouping, respecting the breakdown hierarchy. As an example of breakdown hierarchy, the image above shows “Item Category” within “Country”. In the below image, “Item Category” was moved above “Country” in the ‘Breakdown’ section of the Side Query Panel. As such, the hierarchy is now “Country” within “Item Category”.
View "N" Segments
View “N” control lets you decide how many segments to display in your report. It is a control provided for every segment.
In the ungrouped view, choose the number of rows to display:
In the grouped view, for each and every breakdown, choose the number of segments you want to display:
Some useful tips to note -
- View N only controls ‘how many’ segments to display. ‘Which’ segments are displayed will depend on the “Sort Order”. For example, sorting by decreasing value (100 to 1) will show the top segments while sorting by increasing value (1 to 100) will show the bottom segments.
- View N literally refers to ‘upto’ N segments. For example, if you choose N = 10, but the breakdown has only 7 segments in it, you will only see the 7 segments despite choosing Top 10.
- When selecting “Show All”, the maximum number of segments displayed in the UI will be 3000 given cardinality limits. What this means is -
- If your breakdown has less than 3000 segments, you’ll see all the segments when choosing “show all’.
- If your breakdown has more than 3000 segments, you’ll only see the top 3000 segments in the UI when choosing “show all”.
Overall & Sub-Totals
Overall: This refers to the total value considering all the segments, independent of whether displayed or not based on your View N control. This means changes to View N will not affect Overall numbers.
Sub-Totals: In the grouped view, in addition to the Overall, segment sub-totals are also displayed. Segment sub-totals are the totals for that particular segment. Similar to “Overall”, these values are independent of the View N control.
Please sign in to leave a comment.