Weekly average and daily sales in same combo chart

[Teppo_Ojala]

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
];

[sunny_talwar · Accepted solution]

Would something like this work?

[Teppo_Ojala]

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