Forum Discussion

JesKene's avatar
JesKene
Qrew Member
29 days ago

Separate variables

For my project, I ideally would like to create a pie chart. With what I read online I can’t do that with the variables I have now, so I created a table with two columns. First column, called names, consists of a full name, while the second column, called changes, consists of multiple variables that are separated by a semicolon. For the changes column, I need to separate each variable into a row of its own but still have it associated with the name. What can I do to achieve this?

The end goal is it use this table to see what names are associated with the changes column a distinct number of times. Like Name McName is associated with "No Changes" 37 times. I also created summary report with the same variables but I'm not sure how to proceed with that either.

I'm open to suggestions! Thank you!

reports
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    29 days ago

    I probably have an answer, but before I respond, can you tell me if there is a finite and known set of possible choices for the Changes.  It sounds like you have a Multi Select field to identify all the changes,  and those are stored in Quickbase under the covers as a semi colon delimited list.