on 08-11-2016 1:40 PM
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
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...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.