I have two equations; one for prior day activations and another one for daily activations. Both of them are giving me different answer for yesterday when they should be the same. Why is that? I filtered to make it only for this year so the MM didnt take it from other years.

Prior Day- countIf({approval_dt},{approval_dt}=addDateTime(-1,‘DD’, truncDate(‘DD’, now())))

Daily- countIf({approval_dt},extract(‘MM’,{approval_dt})=extract(‘MM’,now()))

Hi,

why dont you use the same calculation in your daily equation, just without the adddatetime?

Daily

countIf(

{approval_dt},

{approval_dt} = truncDate(‘DD’, now())

)

I tested your equation and it is coming up with the same result. I don’t understand why the daily equation and the prior date equation don’t produce the same result for yesterday.

Can you create a pivot table with only approval_dt in the row field well? this way you have a count column in the values.

the counts you get there for 12/6 are they equal to the calculation from daily or prior day?

1 Like