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?