Count if status draft AND date occurred more than 3 days

[MonikaF]

I am trying to set up a count for events that has been in the status draft for more than 3 days. I have setup the following:

count ({<[Events: Incident Status]={'Draft'}>} isEvent and (Date(Now()))-([Events: Date occurred])>3)

but it only takes the first part in the counting (counts all events in draft) and not only the events in draft for more than 3 days.

Please help

[TauseefKhan · Accepted solution]

Hi @MonikaF,

Check this one:

count({<[Events: Incident Status]={'Draft'}, [Events: Date occurred]={"<$(=Date(Today()-3))"}>} isEvent)

** When applicable please mark the correct/appropriate replies as "solution". Please LIKE threads if the provided solution is helpful to. **