Count Records as of a Date

[evansabres]

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

[dplr-rn · Accepted solution]

try somethign like below

count({< Date={"<=$(=today()-7)"}>}Measure)

does count for dates less than or equal to 7 days back from today

[Vegar]

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)