Skip to main content

Filters and group by in Dashboards

  • Mar 31, 2023 5:14 PM UTC
  • Sep 22, 2024 7:45 AM UTC
  • 4 replies
  • 129 views
  • Translate All

Filters are sometimes very confusing and should be used with caution. Applying a filter to the entire KPI dashboard or to a specific KPI will remove all the data that doesn't fit the criteria of the filter from the calculation. 

Using a filter will reduce the amount of data that is taken into the calculation and will create a smaller "population" for the KPI to calculate, and the result might be different then manual calculations from other sections in the platform.

When possible, it is better to use a ‘group by’ then to use a filter.

4 replies

Group by also seems to have the same issue - are there any plans for a fix for this?

Translate

Netta Brodsky
Bobber

Hi ​@Charlie Ensor - Could you share what’s not working well with the 'Group by' feature?

Translate

​@Netta Brodsky for example, we would like to look at attrition rate in the first year of employment, grouped by department (as a quality of hire metric). 

However, because we’ve added a filter and then grouped the data, we get impossible numbers (e.g. Finance department has a 200% attrition rate). I have raised this with the support team previously and they said this is a known behaviour with the tool, however it really limits our ability to fully utilise the dashboards. The business will not trust our data if we present something with a 200% attrition rate as it’s simply not possible. 

Translate

Netta Brodsky
Bobber

Hi ​@Charlie Ensor , I totally get what you mean, and I see why this is frustrating. If you've already raised a ticket and support confirmed this behavior after a thorough check, then unfortunately, it’s a product limitation at this time.

I appreciate your feedback—it helps highlight areas for improvement! 🙏🏻

Translate