Skip to Content
avatar image
Former Member

Order date in lumira

Hello guys,

i have quarter in this format: Q1-2014, Q2-2014, Q1-2015, Q2-2015

In lumira it's displayed like this: Q1-2014, Q1-2015, Q2-2014, Q2-2015

it's a wrong order. I want this: Q1-2014, Q2-2014, Q1-2015, Q2-2015

I don't find a way in lumira to order quarter in this format.

Do you know a way?


Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Jan 07, 2017 at 07:03 AM

    Hi Bob,

    one simple thing we can do is to add the year to the chart and sort on it to get the required format.



    Add comment
    10|10000 characters needed characters exceeded

    • Hi Bob,

      i am afraid that there is no way to get that in lumira , as the given column represents string and will sort basing on the string wise firstly.

      the other way you can achieve is to change the sequence of the column to 2014-Q1, 2014-Q2,2015-Q1,2015-Q2 to get the required sorting.

      Try to change at source or use prepare room to achieve this.