topic Re: Please kindly clarify - need help in App Development

Please kindly clarify - need help

ashmitp869 — Thu, 07 Apr 2022 23:53:37 GMT

Hi All,

I have created an App - linkagekey with "Reporting Facility ID" and date field .

The result is correct when selecting "Reporting Facility ID" and date , but we have data of individual level i.e MRN

so we showing the MRN level or individual level - the report showing the total with each individual.

Is there any way that I can show i.e 1 every individual

Re: Please kindly clarify - need help

anthonyj — Fri, 08 Apr 2022 06:41:40 GMT

Hi @ashmitp869,

From your table it looks like you have differing grains in your tables. That is, [# OOS] is aggregated at the reporting facility level and not the MRN level. I'm not sure what the [# OOS] consists of but if it's count([Facility ID]) then the MRN will cause duplication of the same number, as demonstrated in your table. If there's more than one of the same MRN per facility ID then your count would need to be count(MRN).

It is difficult to say from the limited information available but if you can supply further information around what your data model looks like or provide some example pseudo-data we can assist further.

Thanks

Anthony

Re: Please kindly clarify - need help

ashmitp869 — Fri, 08 Apr 2022 07:11:39 GMT

es Anthony , you are right the DM [# OOS] is on Reporting Facility and Date level but nor MRN.

Here is the DM snapshot-

Here linkagekey - Reporting Facility id + Date and MRN is a field in the OOS table .

Thanks

Re: Please kindly clarify - need help

anthonyj — Sun, 10 Apr 2022 23:53:12 GMT

Hi @ashmitp869,

Aggregation has to be done at the most granular level. If you have multiple MRN per OOS then your aggregation needs to be a count(MRN). If you were using count(OOS) before you should still have 6,020 as a total however the rows will have the breakdown at the MRN level.

Regards

Anthony