Forum Discussion

liamcameron's avatar
liamcameron
Cloud Apps
09-26-2024

Filter out groupings with less than a certain value

Similar to a sports KPI... i want 3 point shooting percentage, but only for athletes that have taken a minimum 50 shots i have a kpi that is AVG([PersonId],[# of completionId]) where completionId ...
dashboards & reporting
harikm007's avatar
harikm007
Data Warehouse
09-27-2024

Hi liamcameron ,

One option is to use a CASE statement instead of '[# of completionId]'. So the formula will be:

avg([PersonId], case when[# of completionId] > 50 then[# of completionId] else null end)

 

-Hari