Hello,
I am trying to create a chart with two elements.
1. Total sales for selected day by client (I have this done)
2. Historical average of sales for that client on the selected day of the week. For example if I select 03/11/2022 (Friday), I want to have the chart reflect the total sales for the day by client (above #1) with the historical average of sales for that client on that day of the week. I am guessing the second expression must have a combination that includes set analysis.
Any help is greatly appreciated!
Thanks.