Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Help needed here. I am working with a single flat table in my data model containing three columns:
ServiceDateMonthName (dual, timestamp is 1st millisecond of month)
%PatientId
%EncounterId
In QS, I have a straight table that displays the distinct %PatientId count and distinct %EncounterId count by month. In the same table, I have the following aggregation expression:
Count(Aggr(Count(distinct %EncounterId),%PatientId))
(This is not what I am trying to calculate, but it demonstrates the problem simply.) In this expression, I would expect the aggr() array to have value for each distinct %PatientId. However, this does not match with distinct %PatientId count:
Note that there are no filters active. However, when I limit the data in the app to a single month, the values are magically in agreement:
I must be missing something obvious. Suggestions?
That means you wanted to add Year - month on your aggr calculation as well ...
That means you wanted to add Year - month on your aggr calculation as well ...
Brilliant! Now I understand.... Thanks for the quick response, it works!