% Per Date on Graph

jlampard40 — Sat, 16 Nov 2024 19:29:09 GMT

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.

Re: % Per Date on Graph

andoryuu — Tue, 10 Dec 2019 20:17:54 GMT

If you post your QVF it would make testing this a bit easier, but you'll want to do something along the lines of the following:

AGGR(SUM({<CP_DaysWaiting>0,CP_DaysWaiting<=7>}TheNameOfYourMeasure)/Sum(TheNameOfYourMeasure),CP_DateOfReport)

Set that up as the measure on your chart with the CP_DateOfReport as the series.

topic % Per Date on Graph in App Development

% Per Date on Graph

Re: % Per Date on Graph