Duplicate category axis

[markus_reichardt]

Hello,

I am facing an issue related with the duplication of a dimension in the category axis. When adding 2 dimensions in the same chart (one for month and the other for week) I obtain the following result:

This result is completely correct and logical, but my goal is to only display the dimension for the months, only display one value of the 2020-02 and hide the dimension for the days. When I check the hide box for the day dimension I get the following result:

I get the same information in the axis repeated all along. How can I display only one (2020-02)?

Many thanks in advanced. 🙂

[former_member199945]

Hi,

try to create variables for the date column as below

V1= Formatdate([date Object];"yyyy-mm")

and use this object in chart.

Thanks