Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm trying to figure out why this expression is creating an error:
Count({<monthid = max(monthid), initial_screening_completed -= {""}>} RIN)
specifically the monthid = max(monthid), I can set the monthid to a value, 201907
Count({<monthid = {201907}, initial_screening_completed -= {""}>} RIN)
Which returns the correctly result but would like to set it to the max value. max(monthid) by itself returns the correct value.
Can you give a try on the below:
Count({<monthid ={"=max(monthid)"}, initial_screening_completed -= {""}>} RIN)
I tried it and it didn't include the filter, it just aggregated the total count sans monthid filter
Can you please share sample data and the output that you are expecting ?
Count({<monthid = max(monthid), initial_screening_completed -= {""}>} RIN)
Expected Result = 2
Sample Data:
monthid | RIN | initial_screening_completed | counted |
201907 | 101 | 7/1/2019 | X |
201907 | 102 | 7/1/2019 | X |
201907 | 103 | ||
201906 | 101 | ||
201906 | 102 | ||
201906 | 104 | 6/1/2019 | |
201905 | 101 | 4/2/2019 | |
201905 | 102 | ||
201905 | 105 | 5/1/2019 |
Please use the below expression and you will get the result as 2:
=Count({<monthid ={"$(=Max(monthid))"}, initial_screening_completed -= {""}>} RIN)
Thanks! That worked perfectly
You are welcome... If you think you got the answer can you please close the thread by selecting as right answer, so that it will be useful for others also.