Expression to Add Data as of Previous Day

[Anonymous]

I am working on creating an expression to compute total number of open tickets as from day  previous day. I hope you can help me on this.

[sunny_talwar]

Would you be able to elaborate or provide a sample with expected output?

[#3]

try something like that:

=count( {<date={'> $(startDate) < $(endDate)'}>} openticket)

where starDate and endDate are variables

[Anonymous]

Oh sorry, I wasn't able to express myself way. Anyway

This is the expression I am using to Count the ticket that is a work in progress:

=Count({$<Status={'Work in Progress'}>}Status )

so I was trying to replicate that visualization above on the project I am working with. I can't use max date for the raw data given to me extend till december. I want to show whether its + or - as of yesterday,So I want to use the previous day as reference instead. Hope I didn't made it more complicated.

Thanks

[maxgro]

=count({$ <Status={'Work in Progress'},Date={'$(=Today())'}>} Status )

and for previous day

Today()-1

[Anonymous]

Thanks

[Anonymous]

Hi,

I used the following expressions to get the values in red box. But I think there was something wrong. What I want to see is how many were added or deducted from the total number of Assigned,Work in Progress and Completed.If there was no changes in numbers it should be zero.

So my idea is to Subtract:

Total Number of Assigned (as of yesterday) from the Over All Total of Tickets (as of Today)

So I used the expressions below. Did I do it right?

=Num(Count({1<Status={'Assigned'}>}Status)-count({$ <Status={'Assigned'},Date={'$(vPrevDay)'}>}Status),'+#,##0;-#,##0')

=Num(Count({1<Status={'Work in Progress'}>}Status )-count({$ <Status={'Work in Progress'},Date={'$(vPrevDay)'}>} Status ),'+#,##0;-#,##0')

=Num(Count({1<Status={'Completed'}>}Status )-count({1<Status={'Completed'},Date={'$(Today()-4)'}>} Status ),'+#,##0;-#,##0')

What's the best thing I can do to show the accurate figures?