Count today()-date=1

[khallodah]

hey 

I wanna know how many pending requests that passed 1 day. So this is my expression but dosent work, pls need

your input.  thnx:

count({<{today()-[Date added to list]}={'1'}, [status]={'Pending'}>} [Date added to list])

another one:

count({<{today()-[Date added to list]}={'1'}, [status]={'Pending'}>} [Date added to list])

Thank you, you are the best

[Rajashekar]

HI @khallodah ,

calculate this part( today()-[Date added to list] ) in back end as a new column like ticket age. and convert it to number and use it in set analysis.

Hope this helps..

Rajashekar