Forum Academy Marketplace Showcase Pricing Features

DB Design for Radar Chart

Hi All,
I need help designing the data structure to paint the results of a test on a Radar Chart.
Each user will take the test every 3-4 months and I need to store the values of each month so they can see how results evolved.

The flow is:

  • Users take the test (now on a google form)
  • Results are generated based on a formula (on google sheets)
  • Results need to be painted on a Radar Chart.

For the moment I am not looking to integrate the result calculation or integration between google sheets, just need to store the results values on the bubble DB and paint them on a Radar Chart.

Example:

I tried creating a Data Type that has 3 fields: Date, User and List of Results, but it is not working…
Thanks for the help!!

1 Like