Forum Discussion
JenniferJuhasz
4 years agoQrew Cadet
I posted an almost identical request for this help a month ago, but never received any replies. So, super grateful for this thread!
I ended up giving up on my goal of displaying my data in a pie chart all-together - the summary report options just didn't work for me and as I'd had no response from the community with suggestions on how to achieve that, I ended up opting for a different route; and additionally stopped using Multi-select text fields as an option in really any of my forms.
Instead, I broke apart my 'multi-select' field into 'check box' fields (depending on the role of the user, you have 4-10 options to select from). Then ran a pipeline to populate the answers based on what had been previously selected by our users in the multi-select tool.
Even after breaking it apart, I still couldn't run a pie chart because Quickbase (unlike something like Excel) can't run this type of report comparing column data. Instead, I now use a Horizontal Stacked Bar Chart, which gives me a visual representation/comparison of values based on our communities.
It IS nice in that I can hover over a value and see an immediate visual representation of it across our communities; but still a little disappointing because I can't get that lovely, singular pie chart that displays the individual values in a comparative way...
Hopeful that there's a better solution for not-super-advanced users like myself somewhere down the line - but in the meantime, I hope this maybe helps?
------------------------------
Jennifer Juhasz
------------------------------
I ended up giving up on my goal of displaying my data in a pie chart all-together - the summary report options just didn't work for me and as I'd had no response from the community with suggestions on how to achieve that, I ended up opting for a different route; and additionally stopped using Multi-select text fields as an option in really any of my forms.
Instead, I broke apart my 'multi-select' field into 'check box' fields (depending on the role of the user, you have 4-10 options to select from). Then ran a pipeline to populate the answers based on what had been previously selected by our users in the multi-select tool.
Even after breaking it apart, I still couldn't run a pie chart because Quickbase (unlike something like Excel) can't run this type of report comparing column data. Instead, I now use a Horizontal Stacked Bar Chart, which gives me a visual representation/comparison of values based on our communities.
It IS nice in that I can hover over a value and see an immediate visual representation of it across our communities; but still a little disappointing because I can't get that lovely, singular pie chart that displays the individual values in a comparative way...
Hopeful that there's a better solution for not-super-advanced users like myself somewhere down the line - but in the meantime, I hope this maybe helps?
------------------------------
Jennifer Juhasz
------------------------------
- VenkateshGandi4 years agoQrew TraineeHi @Jennifer Juhasz, I came to know about the solution , but can't able to implement it. The solution I'm thinking is based on the response in multiselect field, we need to create a child record for each value in the response. I think webhooks is the option for us. I was able to create/ mirroring the response. But I'm unable to do the looping through the each value in the response as mentioned by @Avi Sikenpore above. Hope for this some advanced XML skills is needed.
------------------------------
Venkatesh Gandi
------------------------------- MarkShnier__You4 years ago
Qrew Legend
@Venkatesh
This is the way that I make a pie chart from a multi select field.I create a child table representing each of the multi select choices which the user selected.
Then set up an automation that when the parent record is edited, to delete all the children and then to create a child record for every possible multi select choice, let's say there are 10 multi select choices so 10 children will be created, then the next step of the automation or pipeline will be to delete any of the children that were not actually selected.
Then set up an automation that when the parent record is edited, to delete all the children and then to create a child record for every possible multi select choice, let's say there are 10 multi select choices so 10 children will be created, then the next step of the automation or pipeline will be to delete any of the children that were not actually selected.
Because the children are children of the parent, they can have a look up field to know which selections were made in the parent and then a formula field can determine for each child that was created whether or not it deserves to remain or needs to be deleted. By having the very first step of the automation delete any children, it ensures that for any editing we are always starting with a clean slate.
Once you have the child table then it is very easy to make your pie charts off the child table
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------- VenkateshGandi4 years agoQrew TraineeHi @Mark Shnier (YQC), Thanks for the reply, This is a decent solution. How did you achieved this; using Webbooks or Pipelines? Just wanted to check this: Will this works if users will keep editing the records periodically?
Thanks
------------------------------
Venkatesh Gandi
------------------------------