Ignore some values in Average KPI calculator

[Javery]

Hello,

I've created a calculated field to see the time between two dates, which I then need to calculate the average time. I want to ignore some values depending on another field (category). Imagine I want to exclude everything from Category B from the average time between calculation.

See attached image.

Grateful for any help 🙂

Thanks

[BrunPierre]

I assume you want to exclude the "B" rows, if so, like below.

Avg({$<Category=E({1<Category={'B'}>})>}TimeBetween)

[Javery]

I don't think this is giving me the correct result unfortunately, I have a second chart which shows the categories (See attached) which when clicking on the categories doesn't seem to change.

[BrunPierre]

Can you please clarify your issue as I can assure you that the the expression disregards the "B" values.

[Javery]

Sure, F.Y.I this is probably my mistake as I'm very new to this.

We have multiple categories (as expressed A in the example, then category 'B' which is what I need to exclude).

I have a pie chart (as above) which shows all of the categories. Each category definitely has a different 'TimeBetween' average but when clicking to filter per category it's staying the same value regardless.

Does that make sense?

[BrunPierre · Accepted solution]

Perhaps as below

Avg({$<Category*={'A'}>}TimeBetween)

[Javery]

This works! Thanks a lot for your help 🙂