Expand my Community achievements bar.

Join us for the next Community Q&A Coffee Break on Tuesday April 23, 2024 with Eric Matisoff, Principal Evangelist, Analytics & Data Science, who will join us to discuss all the big news and announcements from Summit 2024!
SOLVED

Workspace - Freeform Table - how do you show more than the top five when breaking down a column by a dimension?

Avatar

Level 1

In a freeform table I want to breakdown the metric occurences by all the values of a given dimension, not just the top five. Is this possible? 

1 Accepted Solution

Avatar

Correct answer by
Level 5

If you click the right facing chevron on the dimension you can expose the values from the last 6 or 18 months.  Selecting the first value you can scroll to the bottom, select shift, and drag all of the values under the metric.

 

Having said that I wouldn't recommend doing that if you have have more than 8+ values as it becomes difficult to interpret.  At that point you might be better transposing the table to say have the dates in the columns.

 

 
 

View solution in original post

1 Reply

Avatar

Correct answer by
Level 5

If you click the right facing chevron on the dimension you can expose the values from the last 6 or 18 months.  Selecting the first value you can scroll to the bottom, select shift, and drag all of the values under the metric.

 

Having said that I wouldn't recommend doing that if you have have more than 8+ values as it becomes difficult to interpret.  At that point you might be better transposing the table to say have the dates in the columns.