Interactive Tool Date Format

[Dennisklad1]

Hi,

is there a way to change the format of the date axis?

I would like to instead of Sep 2020 use a format like 09-20. If I change it into a string and do it manually then it does not work correctly with the sorting.

[pedrodrfaria]

Hi @Dennisklad1 

How is the data coming in?

I think the easiest way is to transform the data in the exact format you want, as a string value before the interactive chart. Either transform the data or create a new column to use as reference.

If the data is a date format, it should show you this under the Axes tab.

[pedrodrfaria]

@Dennisklad1 

If you need help converting this to the proper format, see below:

[Dennisklad1]

Thanks for the reply.

Wouldnt that lead to sorting problems?

For example:

    Sept-20  Oct-20  Nov-20 Dec-20 Jan-21

This in a string format would be sorted as:

    01-21  09-20  10-20 ... 

[pedrodrfaria · Accepted solution]

Hi @Dennisklad1 

If the data comes in the correct order, it will not cause problems. 

Order that comes in

Order that comes out