Weekly average and daily sales in same combo chart

Teppo_Ojala — Sat, 16 Nov 2024 19:51:58 GMT

Hi,

Is there a way to build an expression that would calculate for example WEEKLY AVG SALES into same chart that is showing DAILY SALES.

Below is an image about the chart I am trying to build. Blue bars are SALES PER DAY and it has been built by normal SUM(SALES) expression. The pink lines has been added to picture in powerpoint, the idea is to show the weekly average in the same chart. The chart would show the weekly progress and daily numbers in one view. I just cant write a formula that will give me these lines.

This graph has been build on top of dummy data-model that has one table, loaded by this inline script:

data:
load *, WeekDay & ' (Week: '&Week&')' as Weekday_Week;
load * Inline
[
Week, WeekDay, Sales
1, Mo, 100
1, Tu, 120
1, We, 130
1, Th, 120
1, Fr, 100
1, Sa, 120
1, Su, 130
2, Mo, 200
2, Tu, 220
2, We, 230
2, Th, 220
2, Fr, 200
2, Sa, 220
2, Su, 230
3, Mo, 300
3, Tu, 320
3, We, 330
3, Th, 320
3, Fr, 300
3, Sa, 320
3, Su, 330
];

Re: Weekly average and daily sales in same combo chart

sunny_talwar — Fri, 18 Oct 2019 11:15:57 GMT

Would something like this work?

Re: Weekly average and daily sales in same combo chart

Teppo_Ojala — Fri, 18 Oct 2019 11:20:15 GMT

Thanks for a quick reply. Yes, this is exactly what I wanted to see 🙂

topic Re: Weekly average and daily sales in same combo chart in App Development

Weekly average and daily sales in same combo chart

Re: Weekly average and daily sales in same combo chart

Re: Weekly average and daily sales in same combo chart