Need help on expression for backlog tickets

[#1]

Hi Friends,

I need to show the total tickets pending for day-1.

if I give below expression ill get overall tickets pending till now and I wont change when we select date,month.

=count(DISTINCT{$<[Service Module]={'INCIDENT MANAGEMENT'},CallStatus={'PENDING'},Call_Date={"<=$(=((vToday)))"},[Call_Day of Month]=,Call_Month=,Call_Year=>} Id)

I need help to get total pending tickets for today-1 day(till yesterday) and also it should change according to selection of date,month. please help.

Thanks in Advance

[arulsettu]

try this

=count(DISTINCT{$<[Service Module]={'INCIDENT MANAGEMENT'},CallStatus={'PENDING'},Call_Date={"<=$(=((vToday)-1))"},[Call_Day of Month]=,Call_Month=,Call_Year=>} Id)

[#3]

Hi Rao

What is your variable vToday holding, bekos we can use it to  date back one day, just like what Arul showed you.,  if this doesn't resolve your issue, please upload your data sample.

[#4]

Thanks Arul and Dlamini.. I will work on it and get back to you