topic Re: Set Analysis with FirstSortedValue in App Development

Set Analysis with FirstSortedValue

Lauri — Tue, 27 Jul 2021 03:11:48 GMT

I'd like to count the number of patients whose last blood pressure in the year was below 140. I am able to find the value of the last blood pressure like this in a chart:

=FirstSortedValue({<IsSameYear={1}, FactType={BP}>} [BP SYSTOLIC], -Date)

This correctly returns the value every time.

When I try to count patients for whom this is true, it does not work. My measure:

=Count(distinct {<PatientID={"=(FirstSortedValue({<IsSameYear={1}, FactType={BP}>} [BP SYSTOLIC], -Date)<140)"}>} PatientID)

Any clues why this does not work?

Re: Set Analysis with FirstSortedValue

MayilVahanan — Tue, 27 Jul 2021 03:54:05 GMT

Try like below

Sum(Aggr(If(FirstSortedValue({<IsSameYear={1}, FactType={BP}>} [BP SYSTOLIC], -Date) < 140, 1), PatientID))

Re: Set Analysis with FirstSortedValue

sasikanth — Tue, 27 Jul 2021 11:25:29 GMT

HI,

Try below expression

count({DISTINCT< PatientID={" =Aggr(FirstSortedValue({<IsSameYear={1}, FactType={BP}>} [BP SYSTOLIC], -Date),PatientID)<140"}>}PatientID)

Re: Set Analysis with FirstSortedValue

Lauri — Tue, 27 Jul 2021 14:26:27 GMT

Thank you both, Sasi and Mayil. You got me on the right track with Aggr, this way:

count(DISTINCT If(aggr({<IsSameYear={1}, AsOfYear>} FirstSortedValue({<IsSameYear={1}, FactType={BP}>} [BP SYSTOLIC], -Date), PatientID, AsOfYear)<140, PatientID))