Data Table with split table ordering


(Tomás Law) #1

Hello,

After a couple split rows and split tables aggregations I get the following result:

The most important metric I get comes from the Total function in the visualization Options which is the Sum (circled in red). I want to order the splitted tables according to the sum value (left: highest sum- >right: lowest sum) but I don't know how to use this Sum value to order them.

image

How can I do it?

Thank you


Counting the last element of each aggregation
(Lukas Olson) #2

You'd have to do the split table aggregation first. I'm not sure if that would give you the results you want in your visualization though.


(Tomás Law) #3

Hey Lukas,

Thanks for replying on both of my posts :wink:

Yep, doing the split table aggregation first selects all the terms initially available but, as you said, I only want the terms after I did a couple split row aggregations...


(system) #4

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.