Forum Discussion

Andrewutter12's avatar
Andrewutter12
Frequent Visitor
5 years ago
Solved

Resorting age group buckets

Hello all, I have a pie chart showing invoice amounts by by age group Current, 31-60, 61-90, 91-20 and over 120. Unfortunately, on my visualization, those buckets are out of order. Is there a way I ...
  • vpatel55's avatar
    vpatel55
    5 years ago

    The easiest way would be to add a "1", "2", etc, to the labels.

    But a neater way would would be to add a sort column. Here, you would add a new column next to each of the labels, such as Current being 1, and 31-60 being 2, etc. You can do that using SWITCH.

     

    So the calculated column would be:

     

    Sort column = SWITCH 'table name' [Age group], "Current","1",31-60","2", etc.

     

    Then click on "Age group" field, and then click on sort by column, and then click on your new sort column. That should do it.

     

     

vpatel55's avatar
vpatel55
Icon for Kudo Commander rankKudo Commander
5 years ago

The easiest way would be to add a "1", "2", etc, to the labels.

But a neater way would would be to add a sort column. Here, you would add a new column next to each of the labels, such as Current being 1, and 31-60 being 2, etc. You can do that using SWITCH.

 

So the calculated column would be:

 

Sort column = SWITCH 'table name' [Age group], "Current","1",31-60","2", etc.

 

Then click on "Age group" field, and then click on sort by column, and then click on your new sort column. That should do it.