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.
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!!