You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
I am using ConfiForm Definition fields to create a form and then have a dashboard to display the data captured on the form. For some fields, I chose the Multi-Select Field Type as some users will require to select more than one option. In my dashboard, which reflects the entries from my form, I have a bar chart that uses this previously mentioned field as the Y-axis (labels column). Since users are able to select more than one option, the options are reflected on my bar chart as they were entered. For example, if a user used my form and they selected, apple and orange. My bar chart will display apple and orange as 1 instead of separating them.
Is there any way to separate them? I would like the label columns in the Bar Chart to recognize that the same entry on the form I created using ConfiForm Definition Fields, has a multi-select field. In other words, I don't want the label columns on my Bar Chart to be AppleOrange. I hope this makes sense. Thank you so much for your help
Are you using ConfiForms for cloud or server/data center?
There is a solution for Data center version to use the TableView Merger macro as a source for your chart macro and set it to "flatten entries"
ConfiForms TableView Merger macro allows you to "flatten entries" (parameter in the macro)
Which means you can transform your source to be flattened (multi-select fields are transformed to new records)
There is no TableView Merger macro in ConfiForms cloud, due to missing support by Atlassian for nesting bodied macros and therefore the "flattening" is not supported either