Threshold of 5 responses filter in CX Dashboard

Question

Hi,We have a B2B scenario. We have an annual survey whose reporting requirement is such that for any combination of filter applied, if the number of respones are > 5, only then the widgets can display data. The page level filter of Threshold does that exactly. But the challenge is in stacked bar chart widgets. Say there is a widget with Year in Y axis and a Sub group in stacked axis. And below is the data:2025 :Sub group 1 - count of records is 4 (67%)Sub group 2 - count of records is 2  (33%)And say filter selected is year 2025 and in total it has 6 records.All the above mentioned 6 records qualify but in stacked chart this filter still looks for count of 5 for every stack. And because of this it hides sub group 2 and only shows Sub Group 1 as 67%. Is there any way possible that I can ensure that filter is only applied at page level and then the seggregation is still showed in stacked bar chart ?Because of this problem, we are doing lot of manual activities and are not able to add dynamic filtering of dimensions enabled. For every combination we are manually marking in embedded fields and then using only 1 dimension to filter. this is a very crude solution which we want to avoid. Regards,Neha Tank

Neha Tank · Accepted Answer

I finally was able to resolve this issue.For all stack charts, I created a measure group. For example, If there was a chart that was showing year wise seggregation of a Product Sub Group, I created a measure group and added this measure thrice in datasource (as we show data from 3 years). In each measure I mapped to the corresponding year survey source (As we have separate surveys for each year). Then I used this measure group in chart and in metrics I created a metric for each seggregation for example A,B,C and filter for corresponding value. So apparently, every stack appears even if there is no value for it. And I applied a page filter of 5 count.So system applies a filter of 5 first and then shows every stack with the values even if it is less than Thanks all for the support. closing the thread.

jbk · Answer

Hi,We have a B2B scenario. We have an annual survey whose reporting requirement is such that for any combination of filter applied, if the number of respones are > 5, only then the widgets can display data. The page level filter of Threshold does that exactly. But the challenge is in stacked bar chart widgets.Say there is a widget with Year in Y axis and a Sub group in stacked axis. And below is the data:2025 :Sub group 1 - count of records is 4 (67%)Sub group 2 - count of records is 2 (33%)And say filter selected is year 2025 and in total it has 6 records.All the above mentioned 6 records qualify but in stacked chart this filter still looks for count of 5 for every stack. And because of this it hides sub group 2 and only shows Sub Group 1 as 67%. Is there any way possible that I can ensure that filter is only applied at page level and then the seggregation is still showed in stacked bar chart ?Because of this problem, we are doing lot of manual activities and are not able to add dynamic filtering of dimensions enabled. For every combination we are manually marking in embedded fields and then using only 1 dimension to filter. this is a very crude solution which we want to avoid.Regards,Neha TankTip: If you add the same threshold filter in the widget level @2 or 3, now your widget level filter will display the results irrespective of page level filter.

Sign up

Login to the Community

Scanning file for viruses.

This file cannot be downloaded