Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm using WeekYear as a dimension, but I am trying to calculate the count of records that have a DateInitiated prior to WeekYear dimension value. So for weekYear being 1-2017 I need the count of everything initiated prior to that date
here is what I am trying now, but nothing is coming up.
=count(distinct {<DateInitiated={'<WeekYear'}>} RecordID)
Thank you
Perhaps this?
=count(distinct {<DateInitiated={$('<' & =Max(WeekYear)-1)}>} RecordID)
OR
=count(distinct {<DateInitiated={"<$(=Max(WeekYear)-1)}>} RecordID)
The first gave me a zero value, and the second one just gave an error
Will you able to provide sample?