Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello !
I have a Line Chart showing revenue for two SKUs. In the x axis I have the period in month and quarters using a circular dimension so I can jump to a quarterly or monthly view based on my needs.
The issue came on the x axis sorting, because i did not find the way to have both month and quarter well sorted.
Please help. I'm attaching a sample on what I have.
thks,dani
Hello,
As Marcus said, you need convert Month-Year field in numeric value, to do this, first use makedate() to get a correct Date, then just get Numeric Period (Year/Month) with MonthName() , finally just create your gruop and use Calendar Quarter sorted by A-> Z ASC and Period (Month/Year) sorted by Numeric Value ASC and thats all.
Best regards.
See attached file.
You need numeric values for this kind of sorting. I suggest you add a numeric month and quarter field to your datamodel or creates your period-fields with dual(string, number).
Alternatively you could use a sorting-expression (tab sort) with pick(match()) or makedate(year, month, day) or similar.
- Marcus
hope to understand, see attachment
I sorted the 2 dim of the cyclic dimension
Hello,
As Marcus said, you need convert Month-Year field in numeric value, to do this, first use makedate() to get a correct Date, then just get Numeric Period (Year/Month) with MonthName() , finally just create your gruop and use Calendar Quarter sorted by A-> Z ASC and Period (Month/Year) sorted by Numeric Value ASC and thats all.
Best regards.
See attached file.