Values are Different with Filter Vs Measure

Q&A
,
1

Hi below is my data

image
image711×331 4.86 KB

  1. I am calculating " Average attendance over the last 30 days " using formula
    avg(
    coalesce( ifelse( Date >=
    addDateTime(-30,‘DD’,now()),
    Attendence,
    NULL),
    0)
    ) — getting value – 83%

    image
    image580×252 14.7 KB

    xech.png)

  2. Using Filter condition in the Visual itself – getting 97%

    image
    image505×531 25.6 KB

Is my calculation is wrong?

2

Hi @Venkat.Metadata, I think your first approach is calculating the average of all the aggregated records, even including the records older than 30 days as “zero”, thus making the result smaller compared to the second approach.

1 Like
3

@ytakahr , is 2nd approach is correct?.

What is the correct formula for the 1st approach?

4

@Venkat.Metadata Yes, your second approach looks correct, but please verify with your actual data as well.

You can use the following calculated field for your first approach.

avgIf(Attendence, Date >= addDateTime(-30, 'DD', now()))
1 Like