Skip to Content
0

Order date in lumira

Dec 08, 2016 at 10:45 AM

68

avatar image
Former Member

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?

Thanks

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
1

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.

Regards,

thrinad

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

Hi thrinad,

Justly, i dont wanna add year in the chart.

0

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.

Regards,

Thrinad.

1