Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good day!
I have a bar chart that displays data by work week using the autocalendar.week function. As you can see, the x-axis labels are by week. I'd rather have the date of the first day of the week displayed instead of the week number. For example, instead of W32, W33 and W34, it would be 08/01/22, 08/08/22 and 08/15/22. I still need to group the data by week. We do not use week numbers in our organization so it can be confusing for some.
Thanks for any insight!
Chris
If you are not interested in the recurring view eg Week1 per year, you can create a calculated dimension in your Master Dimensions using the weekstart(Date) function on your date field.
If you are not interested in the recurring view eg Week1 per year, you can create a calculated dimension in your Master Dimensions using the weekstart(Date) function on your date field.
Yes, thank you! Even without creating the master dimension, it works as a dimension in the chart.