The record number in histogram is incorrect!

[baylor2016]

Hi,

Happy holidays!!!

I am trying to create a histogram to show  distribution of patients' last A1C value last year. There are only 113 records (=count(distinct {<OrderDate={">=8/1/2016<=7/31/2017"}>}PAT_ID) ), but in histogram there are 116 records: In the dimension I used

=round(aggr(FirstSortedValue( {<OrderDate={">=8/1/2016<=7/31/2017"}>}A1C,-OrderDate),PAT_ID),1) . In the expression I used

=count({<OrderDate={">=8/1/2016<=7/31/2017"}>}PAT_ID) . Not sure what I did wrong. Please help.

Please refer to my project attached.

Thanks

Longmatch

[Frank_Hartmann · Accepted solution]

=count({<OrderDate={">=8/1/2016<=7/31/2017"}>}DISTINCT PAT_ID)

hope this helps

[baylor2016]

Good catch!!!