cancel
Showing results for 
Search instead for 
Did you mean: 

Custom Sort on Graphs

gleo_SRAM
Active Contributor
0 Kudos

Hi everyone,

There is a feature in Webi to add Custom Sorts to a dimension that we use extensively.  When we chart our year to date sales, we start with the month of April.

I can't see any option in Lumira to customise the sort sequence of our calendar month, any suggestions?


With thanks
Gill

Accepted Solutions (1)

Accepted Solutions (1)

TammyPowlas
Active Contributor
0 Kudos

Hi Gill,

There are some ideas on this "Under Review" at Idea Place:

Manual/Custom Sort sequence : View Idea

Custom Sort for Dimensions in Prepare Tab : View Idea

This one is under submitted status:

Custom sort for datasources : View Idea

I recommend you vote for them...

gleo_SRAM
Active Contributor
0 Kudos

Thanks for the quick response Tammy.

At least I am not going blind and not seeing how to do it currently. I will have to be patient!

0 Kudos

Hi Gill,

I see that in Lumira the month dimension is by default sorted. Attached is the screen shot.

gleo_SRAM
Active Contributor
0 Kudos

Thanks for your response, my question is about Custom Sorting which would allow you to chose your own sequence for sorting as opposed to the tradition sort ascending / descending order.

0 Kudos

oh ok. It is in the backlog with highest priority.

Answers (1)

Answers (1)

varunanand
Contributor
0 Kudos

Hi Gill,

As Tammy mentioned, the idea of custom sorting is under consideration. But a quick workaround for your issue would be as follows,

Fiscal Calendar (April-March)

Create the following custom dimensions,

Year : Level 1

if Month({Date}) < 4 then Year({Date}) - 1 else Year({Date})

Quarter : Level 2

if Month({Date}) > 3 and Month({Date}) <= 6 then 1 else if Month({Date}) >= 7 and Month({Date})<=9

then 2 else if Month({Date}) >=10 and Month({Date}) and Month({Date}) <= 12 then 3 else 4

Month : Level 3

if Month({Date}) < 4 then Month({Date}) + 9 else Month({Date}) – 3

Month Name : Level 4

if Month({Date}) = 1 then 'January' else

if Month({Date}) = 2 then 'February' else

if Month({Date}) = 3 then 'March' else

if Month({Date}) = 4 then 'April' else

if Month({Date}) = 5 then 'May' else

if Month({Date}) = 6 then 'June' else

if Month({Date}) = 7 then 'July' else

if Month({Date}) = 8 then 'August' else

if Month({Date}) = 9 then 'September' else

if Month({Date}) = 10 then 'October' else

if Month({Date}) = 11 then 'November' else

if Month({Date}) = 12 then 'December'

Create a custom hierarchy using these 4 levels and use them.

Thank you,

Varun Anand