Hi @engdonna ,
To create a table that includes your individual KPIs with different filters, you can use calculated fields with conditional logic to selectively apply filters for each KPI. You can create calculated fields using ifelse statements that evaluate your {stagename} conditions for each KPI.
For example, you could create a calculated field for your “Launched” KPI using logic like: ifelse({stagename} = ‘Launched’, {Unique ARR}, 0).
When building these calculated fields, make sure to aggregate by the dimensions you want to filter the KPI by.
This approach allows you to build filters directly into the calculated fields themselves using ifelse logic, so each field can have a different “filtered” condition.
For your table visual, you can then add these different calculated KPI fields as measures.
This method is particularly useful when you want to display multiple fields that are all filtered differently, as normal filters would get applied to all fields in the visual.
If you’re working with multiple KPIs that need different filtering conditions, you could also consider using parameters to make your solution more dynamic and flexible.
See related post -
Thanks,
Raj Kavuda
AWS Team