Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to count the number of records as of a certain date. Field I am trying to Count is 'ContactID' and the date field is 'CreatedDate'.
What would the structure of an expression be to count as of Today minus 7 days for example
try somethign like below
count({< Date={"<=$(=today()-7)"}>}Measure)
does count for dates less than or equal to 7 days back from today
try somethign like below
count({< Date={"<=$(=today()-7)"}>}Measure)
does count for dates less than or equal to 7 days back from today
Try to create a expression like this. It wil count the ContactID associated with CreateDate in the 7 days interval ( today and 6 days before)
=Count({<CreateDate = {">$(=today()-7) <=$(=today())"}>}ContactID)