I want to create a chart based on information in a Multi-select Text field. However it is showing each permutaion and I want it to show each choice

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

So I have a field called Features.  It is a Multi-select Text with choices such as: Bookmarking, Playback, Location, Sleep Timer, etc.  So what I have done is tracked requests for these features for each customer I have.  So one customer could say: Oh I want bookmarking and a Sleep Timer.  So I put that down as a choice for them.  Next customer says Sleep Time and Location.  So that is put in as their choice.

Now what I want to do is give me a chart to say: show me how many people requested each feature?  What I am getting is it divided by the whole group and not the individual choices.  So I am getting a bar chart that says: 1 person wanted Bookmarking and a sleeptimer.  And one customer wanted a Sleep Timer and Location.  What I want it to say is that 2 people requested Sleep Timer and one person requested bookmarking and one person requested location.  How do I do this?

Photo of Cecelia

Cecelia

  • 180 Points 100 badge 2x thumb

Posted 3 years ago

  • 0
  • 1
I don't believe that this can be done in a chart form.  

My suggestion is to have a field for each choice like this

If(Contains(ToText([Multiple choice]),"pear"),1,0)


and then say there were 10 choices so 10 fields like this.

Then have a simple table report to list the records with those 10 fields on the report. Those fields will have totals.
Photo of Cecelia

Cecelia

  • 180 Points 100 badge 2x thumb
Thanks!  I will give that a shot