topic Count Records as of a Date in App Development

Count Records as of a Date

evansabres — Tue, 21 Apr 2020 20:47:55 GMT

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 — Thu, 23 Apr 2020 17:39:56 GMT

try somethign like below

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

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

Vegar — Thu, 23 Apr 2020 19:30:06 GMT

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)