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.
The solution is not a direct one. It would be possible if the data is structured differently, either having the product id to repeat itself one per category, or having one column per category which could work as a boolean to determine if a given product has a category.
Either way it would be possible to count the occurrences of a category individually.
Let me also take this opportunity to mention that we have recently launched Reveal, our newest data visualization tool. It can be accessed from mobile, web and desktop seamlessly.
Take a moment to check it out at Revealbi.io. With it, having a ReportPlus subscription you can sign right in and start working with it!