In Alteryx how we calculate if the value appear times or more.
Eg 50times or more.
Solved! Go to Solution.
@rohit782192
I am having diffculty to understand your intention here.
Can you give us a sample input and output?
Year | Amravati | Aurangabad |
1990 | Akola Country | Jalna Country |
1991 | Buldana Country | |
1992 | Nanded Country | |
1993 | Washim Country | |
1994 | Jalna Country | |
1995 | ||
1996 | ||
1997 | Amravati Country | Jalna Country |
1998 | Yavatmal Country | Jalna Country |
1999 | ||
2000 | Akola Country | Jalna Country |
2001 | Akola Country | Jalna Country |
2002 | Akola Country | |
2003 | Parbhani Country | |
2004 | Parbhani Country | |
2005 | Parbhani Country | |
2006 | Parbhani Country | |
2007 | Parbhani Country | |
2008 | ||
2009 | Hingoli Country |
How many County appear on the list 5 times or More
Happy to help : ) @rohit782192
Cheers and have a nice day!