see the attached
The % of sales formula is
The Friday formula is
You then create a dual axis chart
1 place the % of sales on rows
2 place the Friday sales on row
3 right click the Friday sales pill and select dual axis
set the default property on the % of sales and Friday Sales to Percent
Then set the Friday Sales to Show Marks
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
friday sales.twbx 1.2 MB
Thanks for your response. I am trying to work through it now, but I need it to be more generic than having to change it each day. So this report gets updated each day with the previous 29 days, so I need the data markers to show each day for the correct days without me having to put them in.
Does that make sense?
I have a datemax,
i tried to do the calculation of:
= DATEname('weekday',[DateMax]) then
which works if the metric I am using is just a sum, but for the metrics which are a calculation its saying that I can't mix aggregate and non aggregates in a calculation.
Are you able to help?