8 Replies Latest reply on May 26, 2017 2:14 AM by Zhouyi Zhang

    Remove Duplicates from Stacked Circle Chart

    Scott Cowie

      Hi,

       

      When I create an ordinary bar chart with COUNTD(Identifier) on rows it doesn't display duplicates of the Identifier column in the graph

       

      Bar Chart.png

       

      However, when I change it to a stacked circle chart with COUNTD(Identifier) on rows it does displays duplicates of the Identifier column in the graph

       

      Circle.png

       

      Is there a way to remove/hide duplicates when using a stacked circle chart?

      The reason I want a stacked circle chart is so people can hover over the circles and read the relevant info for each unique response.