Course Discussion: Create intermediate groupings | Community
Skip to main content
C
Adobe Employee
ChuckMi3Adobe Employee
Adobe Employee
November 3, 2022

Course Discussion: Create intermediate groupings

  • November 3, 2022
  • 1 reply
  • 10461 views

Use this thread to ask any questions related to the Intermediate reporting playlist in Experience League. Experts are monitoring this thread to ensure your questions are answered.

1 reply

S
SteveOw1
November 9, 2022

I'd like to group the projects in a portfolio by a custom field in a form. I don't see this field in the grouping options, though I do see other fields from the same form.  Q: This field is type = multiselect, which certainly might complicate grouping.  Is this why the field is unavailable for grouping in tables (and reports)?

    C
    Adobe Employee
    ChuckMi3Adobe EmployeeAuthor
    Adobe Employee
    November 9, 2022

    Yes, multiselect fields are not allowed to be grouped in the reporting system. As you suggested, it would complicate the results. If you had portfolio options of A, B, C, D, E you could end up with groupings of any of the 5 options individually plus additional groupings for any combination of options, such as A-B, B-C, A-B-C, etc. Is this is what you want? If so, there may be a way to do it using a calculated custom field. 

    S
    SteveOw1
    November 9, 2022

    After further research I have found that the selections in a multiselect field are not always stored the same way, even if the same selections are made. So if A, B and C are selected for multiple entries they may be stored in one as A-B-C and another as B-A-C, etc, so they wouldn't end up grouped together anyway. 


    thx for the explanation. I suppose this complicates the calculation needed for the calculated field approach. Unfortunately it's about 7 or 8 possible selections... I'll see if I can do a calculated column to parse out the selections individually, and create a chart where all projects with an <A> selected are in a section. Those with <B> selected are in a bar. and if there's an <A-B> or a <B-A> that project would appear in both?  Seems like it would still fail, as I doubt WF allows projects to appear more than once in a table or Chart. Well - maybe multiple charts would work... 

    Terms & ConditionsAccessibility statement

    Loading footer...