Prior Day and "daily" Equations Giving different answers for 12/6

Question & Answer
1

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()))

2

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())
)

3

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.

4

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