Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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-
My req-
sample model attached.
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...