Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
suvechha_b
Creator III
Creator III

Count claims for last 12 months ?

Hi All,

Please kindly assist me to get the count of distinct claims number for last 12 months-

I am not sure what to put in dimension field -

Currently it is looking like below-

clipboard_image_0.png

My req- 

clipboard_image_1.png

 

sample model attached.

1 Reply
lanlizgu
Creator III
Creator III

Count(Distinct {<CLAIMS_CAPTURED_MONTH_NAME={">$(=max(CLAIMS_CAPTURED_MONTH_NAME)-100)"}>} [Claims Captured Claim Number])

 

However, I would use dates as date format not number as you are doing...