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.