I am creating a month on month analysis with a line graph but I want the month name in the x-axis to show as jan/feb in order to create a trend . I tried editing it but rather repeates the name of the month as shown belown.
Hello @Adjo !
Could you share how you created the current x-axis?
It would also be helpful to see a sample of your dataset, but one option could be using a conditional statement:
ifelse(
extract('MM, orderDate) = 01 OR
extract('MM', orderDate) = 02,
'Jan/Feb',
extract('MM', orderDate) = 03 OR
extract('MM', orderDate) = 04,
'Mar/April',
etc...,
Null)
Let me know if this help!
Please it did not work
Hello @Adjo !
Did the calculated field throw an error when you tried to save, or when you added it to your x-axis in the visual did it not work as expected?
Hey @Adjo !
Were you able to find a solution? If you are still working on this, could you share why the calculation didn’t work, whether it was an error or it returned incorrect values?
Hello @Adjo !
This topic has been archived because it has been some time since we have heard from you. If you were able to find a solution please feel free to share it here to help the community.
If you still need help with this question or have a new question you can post a new topic at the top of the community so that it is a priority for the community experts.