Question about Summarization

[thd-data-analyst]

Hello Good morning,

I have a question regarding a problem that I am trying to solve. My dataset is something like this:

Item	Category	Attribute	Value
10000	Cat1	Att1	Blue
10000	Cat1	Att1	Green
10000	Cat1	Att1	Yellow
10000	Cat1	Att1	Black
10000	Cat1	Att1	Blue
10000	Cat1	Att1	Blue
10001	Cat2	Att2	Pipe
10001	Cat2	Att2	Comma
10001	Cat2	Att2	Colon
10001	Cat2	Att2	Pipe
10001	Cat2	Att2	Comma
10001	Cat2	Att3	Monkey
10001	Cat2	Att3	Cat
10001	Cat2	Att3	Dog
10001	Cat2	Att3	Monkey
10001	Cat2	Att3	Monkey

I want to find all the cases where the Values are repeating. For example I would like to get an output like this one:

Item	Category	Attribute	Value	Count
10000	Cat1	Att1	Blue	3
10001	Cat2	Att2	Comma	2
10001	Cat2	Att3	Monkey	3

I am only interested in counting the repeating values. Can anyone suggest how I can go about this?

[thd-data-analyst]

I tried to do this but it did not help:

Summarize:

• Item - Group By
• Category - Group By
• Attribute - Group By
• Value - Count Distinct

[JosephSerpis · Accepted solution]

Hi @thd-data-analyst I mocked up a workflow that should produce the output you describe. Let me know what you think?

[AngelosPachis]

Hi there, 

 try doing this

[bpatel]

hi @thd-data-analyst ,

i used a combination of the summarize, sort and sample functions. hope this helps!

[thd-data-analyst]

Thank you @JosephSerpis. I was missing the Value -  Group By.

[thd-data-analyst]

Thank you @AngelosPachis .

[thd-data-analyst]

Thank you @bpatel .