topic Re: How do I do a count formula in Discussions

How do I do a count formula

VR — Fri, 10 Jan 2020 17:59:52 GMT

I have a data set that had 19 million rows. Within that data set I want to count the number of instruments a customer has. I have the customer data in one column and the instruments in another column. My goal is to select customers that only have 1 instrument.

Thanks

Re: How do I do a count formula

txnelson — Fri, 10 Jan 2020 18:17:49 GMT

I suggest that you use

Tables==>Summary

grouping on (Customer, Instruments)

and then on the summary table repeat

Tables==>Summary

grouping on (Customer)

the table it produces will have the number of instruments,

You can then easily run

Tables==>Update

to join the counts back into the original table

Re: How do I do a count formula

VR — Sat, 11 Jan 2020 00:56:53 GMT

Thanks so much, This helps.