Hello,

I am trying to calculate a kpi that represents the number of average daily recallers (i.e., people who call more than once in the same day).

The information is all in the same table, and I calculated the users (ID_Telefono) who for each day (ROUND_DAY(starttime)) made more than one call (UniqueID). The calculation was done with a CASE WHEN.

To get the daily average, I divided the result by separate counts of the days available to me (ROUND_DAY(starttime)).

(SUM (CASE WHEN

PU_COUNT(DOMAIN_TABLE("xcally_clean"."ID_Telefono", ROUND_DAY("xcally_clean"."starttime")), "xcally_clean"."uniqueid" )>1

THEN 1

END

))

/

(COUNT(DISTINCT(ROUND_DAY("xcally_clean"."starttime"))))

The problem is that the result is wrong. If I calculate denominator and numerator separately and divide them, I get 61, while if I leave the formulas on celonis, I get 142.

There is no common table problem because all the information is on one table (xcally_clean).

I attach screenshot with the details.

Can you help me?

Thanks