Forum Discussion
Sorting the axis
I have the following visual: The axis is in a really messy order whether i sort is ascending or descending.. is there a way to sort it such that it is in the order: <60 >60 >90 >120...
create another custom column and set values accordingly and sort by custom column
like this......
when value is custom column
<60 1
>60 2
>90 3
>120 4
>180 5
Anonymous
Hey I created a new column as follows:
Aging Sort = SWITCH(TRUE(), REQUISITION[Aging]="<60",1,REQUISITION[Aging]=">60",2, REQUISITION[Aging]=">90",3,REQUISITION[Aging]=">120",4,REQUISITION[Aging]=">180",5)
But when I try to sort Aging with this now it throws the following error:
When I try to Sort Aging by this column it shows this:
So there is no change
remove sorting on Aging column if there is any
Anonymous There was no other sorting in it. I calculated the exact same stuff in the back end and then tried the sort in the front end and it worked.
But no clue y it did not work in the front end directly.