Custom sorting in the table/chart

Question

Hi,
is it possible to use custom sorting in charts or tables?
For example, sort the values of a formatted date:

April-2021, February-2021, January-2021, March-2021, etc.

in

January-2021, February-2021, March-2021, April-2021, etc..

Thank you

Answer 1

Hi,

you can add a column to the dataset that contains the date, or the concatenation of YEAR+MONTH, and then order on this new column.
If you don't want this new column to be shown in the table, just hide it from the widget configurator.

Bye,
Marco