Skip to Content

Order date in lumira

Dec 08, 2016 at 10:45 AM


avatar image

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?


10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
D DURGA THRINAD 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.



Show 2 Share
10 |10000 characters needed characters left characters exceeded

Hi thrinad,

Justly, i dont wanna add year in the chart.


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.