0

All,

I have a very large list (3000+ items). I need to show a view of this data. I need to show a count of every row (3 rows) of all the YES drop downs. The drop down rows may contain YES or NO. So I need a count of all the YES. I do not want to see the data in the view. I just want to see the count only. Any ideas ?

I just need a list or a view, that shows the three rows (A,B,C (which are YES/NO Columns). With each row showing the count of the YES's . but no data.. Hope this is clearer.

5
  • With or without code? May 18, 2016 at 14:44
  • You can get this done via JSLink. Attach a javascript file to your view and do the calculation. A similar question was asked before here sharepoint.stackexchange.com/questions/129727/… May 18, 2016 at 14:59
  • without code please. OOTB only May 18, 2016 at 15:25
  • Does this need to be in the view with the data, or can it be in a separate KPI list?
    – Jammin4CO
    May 18, 2016 at 15:36
  • Hi @Jammin4CO yes it can be an seperate list. I need the ammount of YES on three different rows and it needs to be displayed horizontally. The original list can be left as is. May 18, 2016 at 15:44

2 Answers 2

0

I need to show a count of every row (3 rows) of all the YES drop downs.

You mean 3 columns/fields in one item ??

Since a True/Yes value equals 1 and False 0

You can use the SUM() function (up to 30 parameters)

=SUM( [Field1] ,  [Field2] ,  [Field3]  ) 

Update #1

OP wants the sum of a column and not display the column in the view

That is not possible out-of-the-box, can only be done with code

3
  • yes each row has 3 YES/NO columns. I want to count the YES's on each column, but I dont want to see any results - i just want to see the COUNT. OOTB only if you have any ideas. May 18, 2016 at 15:27
  • If you don't want the "results" (by which I assume you mean the yes/no columns), simply don't include them in your view. May 18, 2016 at 15:33
  • if i dont incluse them in my view, i dont get the count. I need the count. In the view you can add the count - thats all i need to see. May 18, 2016 at 15:37
0

Here is the closest I can get for you.

  1. Make a view that has the columns you want to count.
  2. In that view, in the Totals section add count totals.
  3. In the Item Limit section, make batches of 1

This should get you in the right direction. You may have to have a separate view with filters for each column to get accurate totals. I also noticed in my testing that if you use the Yes/No column, the total only returns a count of "Yes".

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.