I am developing a CX dashboard for my ‘Group’ within the organisation, which is connected to three different data sources, with each source representing a ‘service area’. I want to get a CX score for the group by bringing together the three data sources. The issue I am having is that one source has a much larger number of responses (2,279) than the others (131 & 147), which is effectively skewing the results to be representative of the largest data set. Is it possible to weight the data sources equally, irrespective of the number of responses for that source?

Yes, it is possible to weight the data sources equally in order to balance the influence of each source on the overall CX score, regardless of the number of responses. Here's a general approach to achieve this:Normalize the CX scores: Start by normalizing the CX scores for each data source. This step ensures that the scores are on a consistent scale, enabling fair comparison and weighting.Assign weights: Assign equal weights to each data source. Since you want to treat all data sources equally, you can assign a weight of 1 to each source. These weights will be used to balance the influence of each source on the final CX score.Calculate weighted average: Calculate the weighted average of the normalized CX scores. Multiply each normalized CX score by the corresponding weight for the data source it belongs to, and then sum up these weighted scores. Finally, divide the sum by the total number of data sources to obtain the weighted average CX score.Interpret the result: The weighted average CX score you obtain represents the overall CX score for your group, with equal weighting given to each data source. This ensures that the larger data source doesn't disproportionately skew the results.

Can I weight Data Sources for my CX Dashboard?

Can I weight Data Sources for my CX Dashboard? | Experience Community

Sign up

Login to the Community

Scanning file for viruses.

This file cannot be downloaded