Hey, I want to custom sort this graph by (2 levels of sorting):
Date BreakDown - Field and then % Metric.
By changing the sort metric on the X Axis/Y Axis, I can sort it only by 1 level.
How can I sort that by 2 levels as I explained above?
Hi @Eldad_Levi,
What are you envisioning the visual to look like with sorting by those 2 fields? Are you looking to sort how the color’s line up as well? You could try switching the ‘% Metric’ with the ‘SOURCE’ and see how that outcome looks?
But if looking to sort by both axes; once you sort by the x or y, it can’t sort by the other as well. For instance on the x-axis, there is only one column per date so sorting by the y-axis would not change any order.
1 Like
Thanks for responding.
I want first to sort by the X axis (Date) and then I want that the groups in the bars (Source) will be sorted by the %Metric.
Maybe with additional calculated field that will be responsible to sort that as I want?
I tried switching the ‘% Metric’ with the ‘SOURCE’ - It is doesn’t work for me.
Hi @Eldad_Levi,
You could try using a denseRank calculation, then using it in the ‘Group/Color’ section.
It may look something like:
denseRank([{Source} ASC], [{% Metric}], PRE_AGG)
1 Like
Hi @Eldad_Levi,
Following up here as it’s been awhile since we last heard from you. Did you have any remaining questions or were you able to find a work around for your solution?
If we do not hear back from you within the next 3 business days, I’ll go ahead and close out this topic.
Thank you!
Hi @Eldad_Levi,
Since we haven’t heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new topic in the community and link this discussion for any relevant information that may be needed.
Thank you!