Present multi-select value field better on Radar card
I love the multi-select field. However, one of the challenges that came up to me is parsing multi-vale fields in order to better present the data on the dashboard.
Specifically, I want to use the Radar chart (see attached snapshot) to present the company's capability. I created a multi-select dropdown menu Generation with such option as Gen Operations, Gen Planning, Hydro, Solar, etc. However, as you can see, on the chart, if the user chose multiple selections, then Insightly will only return to the database as a string of delimited values separated by a ";" (e.g: Hydro; Gen Planning)
I tried Calculated Field but so far could not find a solution for this issue. This reduces the accuracy of our data representation.
Thank you for looking into this. Hope to hear from you guys soon. :)