Solved: Pie chart showing duplicate reponses

MayaE

Hi,

I have a pie chart that is showing the same response type more than once instead of showing the unique count (or percentage) for each response type. I have Metric set to Count Distinct but nothing changes

Mehdi_Oudjida

@MayaE ,

You probably need to switch to count (CT) instead of count distinct for your metric. If you use the same field for the dimension and the metric, the count distinct will return 1 for any data set row.

On the other hand, check the field used for the sort section (at the bottom of the setup tab). It must be also set with the same field. Otherwise, it will create a unwished breakdown, provoking the repeated values.

I hope it helps.

Mehdi

View solution in original post

Mehdi_Oudjida

@MayaE ,

You probably need to switch to count (CT) instead of count distinct for your metric. If you use the same field for the dimension and the metric, the count distinct will return 1 for any data set row.

On the other hand, check the field used for the sort section (at the bottom of the setup tab). It must be also set with the same field. Otherwise, it will create a unwished breakdown, provoking the repeated values.

I hope it helps.

Mehdi

MayaE

@Mehdi_Oudjida Thank you! Setting the Sort section to the same as my Dimension section worked. Appreciate the help 🙂

Mehdi_Oudjida

@MayaE

Happy to know that it solved the problem 😊
You can now accept the answer as a solution to inform the community.