Discussions

Expand all | Collapse all

How do I create this summary based on a multi-select text field?

  • 1.  How do I create this summary based on a multi-select text field?

    Posted 03-09-2016 19:17

    I have a multi-select field and I'm trying to get a specific summary report and can't figure this out.

    For my FIELD I have the following text options:

    • Option 1
    • Option 2

    Let's say I have the following:

    FIELD1 | FIELD2 | FIELD3 | FIELD4

    Option1 | Option1 | Option2 | Option 2

    blank | Option2 | blank | blank

    The current summary is:

    • Option1 = 1
    • Option2 =2
    • Option1;Option2 = 1

    But what I want is:

    • Option1 = 2
    • Option2 = 3

    How can I get this summary?  Appreciate any help!



  • 2.  RE: How do I create this summary based on a multi-select text field?

    Posted 03-10-2016 02:14
    I think you would nee to have a formula numeric field per Choice.

    The field called [Option 1] would be like

    var text ChoicesInText = ToText([Field]);

    If(Contains($ChoicesInText, "Option 1"),1,0)

    Same for Option 2

    Then run your report to Total each of the [Option x] fields.


  • 3.  RE: How do I create this summary based on a multi-select text field?

    Posted 01-29-2019 18:54
    To run a report with these fields, do you have to run a separate report for each field? If not, how can you configure the report to summarize this?