Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
35
Counting occurrences of a selected choice from a Sharepoint choice field in a ReportPlus Dashboard
posted

Hello,

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.

ID Category
1 A
2 B
3 A; C
4

A; C

5 A; B; C
6 C
7 A
8 A

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.

Thanks!

  • 245
    Suggested Answer
    Offline posted

    Hi Luke,

    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évere
    Senior Support Specialist
    Enterprise Mobility | Infragistics, Inc.