Column Chart by Calendar Week

[frank99]

I can create a column chart rolled up by date or by month. I see the option to roll up by week number, but week number does not provide what I need given that the data spans across multiple years (I don't want to combine data from this year week 1 with data from next year week1). How can I create a column chart rolled up by calendar week?  

[Barbie]

Hi @frank99,

One solution that I can suggest is to use the month and year in the Date rollup. In this case, the data from different months and years will be separated. 

Please refer to this:

 

And here's an article for reference: https://howto.caspio.com/datapages/charts/

I hope this helps. 

- Barbie