I have a SharePoint list that I am making a dashboard from. In this list, every entry can belong to one or more categories. For example, lets say these categories are A, B, and C. I am trying to count how many times A, B and C were selected and show it in a graph. However the column of can look like this.
When I load this into ReportPlus, it makes a graph that would count the entries like this.
I would like it to just count how many of A, B, and C there is individually but I cannot seem to find a way to do that. Tried making many different calculated fields with no luck. Wondering if anyone would happen to know.
Let me help you out. I will try these and get back to you, as the first and most logical suggestion is as you commented, to use the calculated fields to resolve how mane occurrences are there for the given categories.
Kind regards,Adrián PévereSenior Support SpecialistEnterprise Mobility | Infragistics, Inc.
Wondering if you were able to make any progress with this.
My apologies for the delay. I'm still finding the way around this one. The problem is with the fact that the categories coexist but with no field to link them to (each category individually) so as to count them separately while keeping track in a local variable (another field). I will have the final answer by tomorrow.