How to display several form entries in graph comp

[Martina_G]

Hey guys,

I want to display users´ asset allocation by the graph component. Something like this:

Our app will collect the data in ONE view, see screenshot. data is stored in user table. one column for each asset class.

How can I structure these data per row in order to enable the graph components? With relations, lookups…?

[ThinhDinh]

So you’re having the two pieces of data on the same row and want to use them to create a donut chart?

[Roldy]

check this:

A good explanation about this method from @Robert_Petitto here:

Transpose Columns to an Inline List: The Miracle Method

I’m often asked how to take columns of data (say form responses) and display them in an inline list. Here’s one way to do it—the MIRACLE METHOD. [Glide: Transpose Data Columns into an Inline List with the MIRACLE METHOD]

[Martina_G]

@Roldy You´re the best. Thank you so much for this video!
Implementation works very well now.

One last question:
How to handle empty data columns? I mentioned that the order for the chart only works if there is a 0 value in the empty field. But how can I add this by default?

Data with empty column for ETF

Data with empty column for ETF, 0 value added manually in backend

[Darren_Murphy]

Use an if-then-else column:

• If value is empty, then 0
• Else value

And then use that if-then-else column in place of the original column.

[Roldy]

Happy to help you.
The method for replacing an empty field with zero is what @Darren_Murphy told you. I’m sorry I wasn’t more specific before!

[Martina_G]

Thank you guys. I´m super happy with the result.