Hi guys - I've attached a sample of the data I'm using to try and show, on a graph, the % of patient's seen within certain day parameters. I have built a slider to enable users to see graphically how well we are doing in seeing patient's. The problem I'm having is being able to show this as a % PER DATE of Report (see example). In my example attached, I've shown 0-7 days - the % per date is shown at the top of the spreadsheet and then reflected in the graph. The same calculation needs to be made if, for example, I changed the slider to show 0-14 days - the appropriate calculation is made and graph changes to reflect those patient's seen between 0-14 days wait.
How can this be written in set analysis to show % per date of report? Many thanks and kind regards.