Classificação Dados Gráfico de Combinação

[DenisLuan]

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. 

[JordyWegman]

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

[DenisLuan]

sorry, should i include this expression exactly where? would it be in the "Sort by Expression" field in the chart properties?

[JordyWegman · Accepted solution]

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

[DenisLuan]

Thank you, solved my problem.

👍