topic Re: Data Analysis in Dev Space

topic Re: Data Analysis in Dev Space https://community.alteryx.com/t5/Dev-Space/Data-Analysis/m-p/895236#M1718 <P>thanks <a href="https://community.alteryx.com/t5/user/viewprofilepage/user-id/67366">@atcodedog05</a> </P> Wed, 26 Jan 2022 08:57:22 GMT AS 2022-01-26T08:57:22Z Data Analysis https://community.alteryx.com/t5/Dev-Space/Data-Analysis/m-p/895232#M1716 <P>Hi there,</P><P> </P><P>How we can check how many counties appearing on this list 5 times and more?</P><P> </P><TABLE border="1"><TBODY><TR><TD>Year</TD><TD>Alabama</TD><TD>Arizona</TD><TD>Arkansas</TD><TD>California</TD><TD>Colorado</TD></TR><TR><TD>1990</TD><TD> </TD><TD>Yuma County</TD><TD> </TD><TD>Imperial County</TD><TD>Conejos County</TD></TR><TR><TD>1991</TD><TD> </TD><TD>Yuma County</TD><TD> </TD><TD> </TD><TD>Costilla County</TD></TR><TR><TD>1992</TD><TD> </TD><TD>Apache County</TD><TD>Woodruff County</TD><TD>Colusa County</TD><TD>San Juan County</TD></TR><TR><TD>1993</TD><TD> </TD><TD>Yuma County</TD><TD>Prairie County</TD><TD>Colusa County</TD><TD>San Juan County</TD></TR><TR><TD>1994</TD><TD> </TD><TD>Yuma County</TD><TD>Mississippi County</TD><TD>Colusa County</TD><TD>San Juan County</TD></TR><TR><TD>1995</TD><TD> </TD><TD>Yuma County</TD><TD>Phillips County</TD><TD>Colusa County</TD><TD>San Juan County</TD></TR><TR><TD>1996</TD><TD>Wilcox County</TD><TD>Yuma County</TD><TD>Randolph County</TD><TD>Colusa County</TD><TD>San Juan County</TD></TR><TR><TD>1997</TD><TD>Greene County</TD><TD>Apache County</TD><TD> </TD><TD>Colusa County</TD><TD>Dolores County</TD></TR><TR><TD>1998</TD><TD>Greene County</TD><TD>Yuma County</TD><TD>Randolph County</TD><TD>Colusa County</TD><TD>San Juan County</TD></TR><TR><TD>1999</TD><TD> </TD><TD>Yuma County</TD><TD>Woodruff County</TD><TD>Colusa County</TD><TD>San Juan County</TD></TR><TR><TD>2000</TD><TD>Wilcox County</TD><TD>Yuma County</TD><TD>Jackson County</TD><TD>Colusa County</TD><TD>San Juan County</TD></TR><TR><TD>2001</TD><TD>Winston County</TD><TD>Yuma County</TD><TD> </TD><TD>Colusa County</TD><TD>San Juan County</TD></TR><TR><TD>2002</TD><TD>Wilcox County</TD><TD>Apache County</TD><TD>Mississippi County</TD><TD>Colusa County</TD><TD>San Juan County</TD></TR><TR><TD>2003</TD><TD>Franklin County</TD><TD>Apache County</TD><TD>Mississippi County</TD><TD>Colusa County</TD><TD>Costilla County</TD></TR><TR><TD>2004</TD><TD>Wilcox County</TD><TD>Apache County</TD><TD> </TD><TD>Colusa County</TD><TD>Costilla County</TD></TR><TR><TD>2005</TD><TD>Bullock County</TD><TD>Yuma County</TD><TD> </TD><TD>Colusa County</TD><TD>Costilla County</TD></TR><TR><TD>2006</TD><TD>Bullock County</TD><TD>Yuma County</TD><TD> </TD><TD>Colusa County</TD><TD>Costilla County</TD></TR></TBODY></TABLE> Wed, 26 Jan 2022 08:28:38 GMT https://community.alteryx.com/t5/Dev-Space/Data-Analysis/m-p/895232#M1716 AS 2022-01-26T08:28:38Z Re: Data Analysis https://community.alteryx.com/t5/Dev-Space/Data-Analysis/m-p/895234#M1717 <P>Hi <a href="https://community.alteryx.com/t5/user/viewprofilepage/user-id/256416">@AS</a> </P> <P> </P> <P>Here is how you can do it.<BR /><BR />Workflow:</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="atcodedog05_0-1643186418827.png" style="width: 717px;"><img src="https://community.alteryx.com/t5/image/serverpage/image-id/220212iC7AAEAFFAB091727/image-dimensions/717x550?v=v2" width="717" height="550" role="button" title="atcodedog05_0-1643186418827.png" alt="atcodedog05_0-1643186418827.png" /></span></P> <P> </P> <P>Hope this helps : )</P> <P> </P> Wed, 26 Jan 2022 08:40:30 GMT https://community.alteryx.com/t5/Dev-Space/Data-Analysis/m-p/895234#M1717 atcodedog05 2022-01-26T08:40:30Z Re: Data Analysis https://community.alteryx.com/t5/Dev-Space/Data-Analysis/m-p/895236#M1718 <P>thanks <a href="https://community.alteryx.com/t5/user/viewprofilepage/user-id/67366">@atcodedog05</a> </P> Wed, 26 Jan 2022 08:57:22 GMT https://community.alteryx.com/t5/Dev-Space/Data-Analysis/m-p/895236#M1718 AS 2022-01-26T08:57:22Z