Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
This may be simpler than I think... I have a straight table that displays patient names and several measures about their blood pressure (latest date, number of readings, etc.). Users can filter the date range of when blood pressure readings were taken.
I need to display the total count of blood pressure readings each patient has ever had. So it needs to ignore user selection on the date so that it counts all-time readings, BUT I want the table to honor the user selection so that it displays only patients who had (at least) a reading in the date range.
Using this measure causes the table to ignore the user selection altogether of course:
Count({<BPdate= >} BProwID)
As a result, the table is confusing because the user has applied a filter that is not being honored.
How can I get each patient's lifetime count while limiting the table to patients with the user-selected BPdate?
Try this
Count({<BPdate, Patients = p(Patients)>} BProwID)
That works perfectly! Thank you for your instant response, Sunny!
Use GetSelectedCount on the date fields to identify if a selection has been made. if no selection has been made
Count( BProwID)
else something like
Count({<BPdate={"<=$(=YOURMAXDATE)>=$(=YOURMINDATE)"} >} BProwID)
if you can give specifics on the columns can help further