Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Need help in the below scenario.
Manual Invoices | Total Invoices | Avg of B/C | |
Week 52 | 10 | 20 | 0.5 |
Week 51 | 20 | 30 | 0.666666667 |
Week 50 | 30 | 40 | 0.75 |
Week 49 | 40 | 50 | 0.8 |
Week 48 | 50 | 60 | 0.833333333 |
Total | 150 | 200 | 0.75 |
Average of Week 52 to Week 48 is 0.75 will be one bar in my bar chart.
I need to put it in graph chart.
So 4 weeks of avg data i am showing in the above.
The second bar should be from Week 49, Week 50, Week 51, Week 52 and week 1.
I have mentioned Week 1 because this is january 2019 and we are in 1st week.
please help.
Hi,
If you want to show a rolling average and its constituent parts in a bar chart (which might be what you are getting at …), if there are not many bars you can just use different expressions for each piece, similar to the below (I've stopped at the 3 bars as just an example);
There are things that can be done to improve the display (e.g. change bar colours, get text on the axis). The set analysis used to get the dates should also be dynamic, but getting into that really depends on your data model & if this is even what you are trying to do.
Cheers,
Chris.