Chart showing week by week data
I would like to create a chart having the number of changes on y axis against each week on the x axis.
Ideally, I would like the week to start from Monday and display as: 11/10/2021, 18/10/2021
How can this be achieved?
I have set the starting week as Monday in Admin > Config > Time and Region settings, and also tried to plot a time series chart (continuous, fill in zero for null values) but faced the below issues:
- it displays the date of the starting week as being a Thursday
- Over a 1 yr time frame, it displays the dates fortnightly
Anything I am missing here?
Or any other way I can do this? I've tried using the week calculated field but that also doesn't work in that it only display the week number, and not the actual date.