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

Remove Duplicates from Stacked Circle Chart

Scott Cowie May 25, 2017 10:33 PM

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

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

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.

1. Re: Remove Duplicates from Stacked Circle Chart

Subrakant Pradhan May 25, 2017 11:41 PM (in response to Scott Cowie)

Hi Scott,

Can I have sample data or sample workbook.

Thanks
Like Show 0 Likes(0)

Actions
2. Re: Remove Duplicates from Stacked Circle Chart

Subrakant Pradhan May 25, 2017 11:41 PM (in response to Scott Cowie)

Please provide sample WB or data
Like Show 0 Likes(0)

Actions
3. Re: Remove Duplicates from Stacked Circle Chart

SANDIP SHARMA May 26, 2017 12:16 AM (in response to Scott Cowie)

Hi Scot,

Could you please share screen shot with below option for your circle chart as you have shared your screen shot with all marks.

There might be a possibility that there might be something got added in details due to this your records are getting duplicate.
Like Show 0 Likes(0)

Actions
4. Re: Remove Duplicates from Stacked Circle Chart

Zhouyi Zhang May 26, 2017 12:31 AM (in response to Scott Cowie)

Hi, Scott

Please see my comments below

ZZ
Like Show 0 Likes(0)

Actions
5. Re: Remove Duplicates from Stacked Circle Chart

Scott Cowie May 26, 2017 12:45 AM (in response to Zhouyi Zhang)
Here is a sample workbook and data. If I aggregate measures with the circles then it means they are no longer stacked.

DummyData.xlsx 10.5 KB
Like Show 0 Likes(0)

Actions
6. Re: Remove Duplicates from Stacked Circle Chart

Zhouyi Zhang May 26, 2017 12:54 AM (in response to Scott Cowie)
Hi, Scott

Thanks for your workbook, please see my solution below:

step 1 tick the Aggregate Measure

Drag Identifier to detail for both measure

and here is the result.

I attached the workbook for your reference.

Hope this could help and let me know if you have question.

ZZ

Data Example.twbx 43.4 KB
Like Show 0 Likes(0)

Actions
7. Re: Remove Duplicates from Stacked Circle Chart

Scott Cowie May 26, 2017 1:01 AM (in response to Zhouyi Zhang)

Thank you very much for your help.
Like Show 0 Likes(0)

Actions
8. Re: Remove Duplicates from Stacked Circle Chart

Zhouyi Zhang May 26, 2017 2:14 AM (in response to Scott Cowie)

Glad to help

ZZ
Like Show 0 Likes(0)

Actions