topic Modify Bar Chart Axis Labels Generated by autocalendar Function in App Development

Modify Bar Chart Axis Labels Generated by autocalendar Function

pdlnfool — Thu, 25 Aug 2022 00:27:18 GMT

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

Re: Modify Bar Chart Axis Labels Generated by autocalendar Function

Lisa_P — Thu, 25 Aug 2022 01:04:38 GMT

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.

Re: Modify Bar Chart Axis Labels Generated by autocalendar Function

pdlnfool — Thu, 25 Aug 2022 01:38:15 GMT

Yes, thank you! Even without creating the master dimension, it works as a dimension in the chart.