Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have already managed to get the month bars to appear first and they are sorted by month. Then the days appear but for some reason it does not order them as I hope. Particularly Monday 11 (L-11) is placed at the beginning of all day values, which I don't understand why.
To do the ordering, I am using the "Periodo"dimension of the X axis but replacing its value by an expression using the formula "=Tipo&Orden" where "Tipo" is a value that is determined based on the type of value that I am going to represent A=Years, B=Months, C=Days and "Orden" is the number of the related item, if "Tipo=A" then "Orden" value is directly the year, 2020, 2021 ... If "Tipo=B" then "Orden" value is 01 for January, 02 for February and so .... and if "Tipo=C" then "Orden" value is the day of the month used directly 01, 02, 03 ...
You can see the data represented in the image of the attached table for better reference.
As you can see in the previous image, the data is ordered by the first column "Tipo&Orden" and the result is as expected, since it shows the months ordered at the beginning and then the days ordered at the end.
This is the formula I use to Sort
But in the graph it is not like that. The months appears at the beginning of the graph and the days at the end, but for some reason, the monday value (L-11) are showed at the beginning of the lines block.
This is the formula I use to order. (I replace the ordering by period to use an expression, which is the same as the one the table uses to sort by the first column)
Do you have any idea why this happens?
I thank you in advance for your support.Greetings!