How can I change the order of columns in chart?

jakebutterfield
jakebutterfield Member
in Charting

Hi guys, I have been trying to reorder my chart chronologically backwards. I have 3 columns that I want from left to right, Current Year, 3 years ago, 5 years ago.

column sorting.PNG

The table is transposed. Every column header on the left (transposed) is a beast mode. I have tried clicking the arrows next to 'Year of Tour' and it never gets it in the right order. I have also tried dragging the column into the sorting section in analyzer and have tried every aggregation/ascending/descending combination.

Is there something in the 'Year of Tour' beast mode I need to add to get it in the right order? Is there a function in beast mode that can sort chronologically?

Tagged:

Best Answer

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    Create a new beast mode to return an integer based on the order and then use that in the sort of the card:

    CASE WHEN `Year of Tour` = '5 Years Ago' THEN 3
WHEN `Year of Tour` = '3 Years Ago' THEN 2
WHEN `Year of Tour` = 'Current' THEN 1
END

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**

Answers

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    Create a new beast mode to return an integer based on the order and then use that in the sort of the card:

    CASE WHEN `Year of Tour` = '5 Years Ago' THEN 3
WHEN `Year of Tour` = '3 Years Ago' THEN 2
WHEN `Year of Tour` = 'Current' THEN 1
END

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • jakebutterfield
    jakebutterfield Member

    Yes, that's it. Not sure why I didn't think of that. Thanks Grant.

Categories