Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Bom dia, sou novo por aqui. Estou com dificuldade de fazer meu gráfico respeitar a ordem de "Data" (Dimensão).
Aparentemente ele fica classificando por valores e a data fica fora de ordem.
Yes that is correct, that should solve your problem. You can also try to use the formula Floor([YourDateField]) in that 'Sort by expression'.
Jordy
Climber
Hi Denis,
Do you have access to the script editor? Put this in your script:
Dual([YourDateField],Floor([YourDateField])) as Date
The put the sort, on the Date field. The Floor() function will create a numeric value that will sort properly.
PS: Ask the questions in English, this easier for everybody.
Jordy
Climber
sorry, should i include this expression exactly where? would it be in the "Sort by Expression" field in the chart properties?
Yes that is correct, that should solve your problem. You can also try to use the formula Floor([YourDateField]) in that 'Sort by expression'.
Jordy
Climber
Thank you, solved my problem.
👍