How do I count number of entries across multiple fields?

Please see screenshot - is there a way for me to sum up how many "Y" entries there are for each Machine Id? What I need is a "Total" column at the end which will be populated with the number of "Y" entries through the week:

Machine Id	Total
25	4
26	1
27	3
28	4

Thank you

Screenshot.png

Workflow

Tips and Tricks

Accepted answers

atcodedog05

Hi @benmillea,

I also wanted to throw my solution into the hat😁. I am using a shorter version of IF statement to write my logic.

Cheers and Happy Analyzing

atcodedog05

All comments

binu_acs

@benmillea Transpose your data (Machine id as the key column)- filter out only Y values, summarise tool group by Machine ID, count of value

Qiu

@benmillea
I can think of a few ways of doing it including the one from @binu_acs 😂

0609-benmillea.yxmd

atcodedog05

Hi @benmillea,

I also wanted to throw my solution into the hat😁. I am using a shorter version of IF statement to write my logic.

Cheers and Happy Analyzing

atcodedog05

benmillea

Many thanks, everyone. Much appreciated 😊

atcodedog05

Happy to help : ) @benmillea

Cheers and have a nice day!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15875

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703