Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a horizontal bar chart that shows project duration, starting with today as zero.
The issue is that the x-axis is not consistent. (see attached photo)
What I would prefer is to have it in a consistent format, preferably by months. I can't seem to find a way to format it. The range is currently set to min/max
Mix is Today()
Max is set to =Max(Date(COMPLETION_DATE))
The scale is set to Narrow.
Any ideas would be appreciated
Hey 👋 Thank you for posting in our community! If I got your request right you could set 2 dimensions in the bar chart instead of just the "Date" field. The first dimension functioning as a Group could be "Month(Date)" and the second dimension the actual Date filed. This way you should obtain the dates grouped and labeled by month on the X-axis 😊
Hey 👋 Thank you for posting in our community! If I got your request right you could set 2 dimensions in the bar chart instead of just the "Date" field. The first dimension functioning as a Group could be "Month(Date)" and the second dimension the actual Date filed. This way you should obtain the dates grouped and labeled by month on the X-axis 😊