Forum Discussion
Month sort for multiple years data
Hi! i don't get very well what you want or whats the problem, im guessing it's the month sorting in the first chart?
if that the case i recomend you adding a colun with a secuential from 1 to 12, something like the last 2 digits from the [Month YYYYMM] column
You will end up with something like this:
after that in the canvas just select the column month and then in the modeling tab select SortBy and chose the id_month just created as reference
with this the months will be sorted by the ids or the number of the month instead of A-Z sort of the names
Hopes this helps
Hi! i don't get very well what you want or whats the problem, im guessing it's the month sorting in the first chart?
if that the case i recomend you adding a colun with a secuential from 1 to 12, something like the last 2 digits from the [Month YYYYMM] column
You will end up with something like this:
after that in the canvas just select the column month and then in the modeling tab select SortBy and chose the id_month just created as reference
with this the months will be sorted by the ids or the number of the month instead of A-Z sort of the names
Hopes this helps