Hello, community.
Would You advise me how to plot the line chart with value (Y-axis) aggregated on a weekly basis?
In my case the source data structure is almost as in "Demo GreenCar roadshow - web traffic" data feed:
- Date (date in format DD.MM.YYYY)
- Value (number).
This data is updated weekly. That is why we can not use neither monthly aggregation (too rough) nor daily (too detailed).
Aggregation by week number is not possible in the line chart diagram. And seems there's no possibility to extract week number from date with MashZone tools for data feed definition.
If I use Excel for week data calculation (adding column to source data) then I face the sorting issue: 10th week follows after 1st week on line chart instead of 9th.
Hope I succeeded explaining the situation.