AnsweredAssumed Answered

Count total from column and Top 10

Question asked by brightlight on Nov 29, 2017
Latest reply on Dec 4, 2017 by brightlight

I have over 50 choice columns with Yes/No values. This list has over 15,000 items. I am trying to count the total numbers of "Yes" values from these choice columns and display top 10 columns that has Yes values. How can i do this? I am thinking query list with filter "Yes" for columns, but it will be 50 filters. Then use for each and collection operation to count and sort then display as html table in email?

Outcomes