Hey guys, I’m really hoping someone can help me here… I’m completely stuck and It’s upsetting!
Essentially, my app is a solar energy load calculator and what I want to achieve is something like this:
This is a breakdown of power usage in 3 hour chunks and it is a graph I made in minutes using basic javascript on my non-bubble version of this web app. However In bubble, it seems extremely difficult to perform basic operations on arrays/lists of numbers…
In my program (bubble) I have 4 different numbers representing power used at morning, mid day, afternoon and night… I’d love to be able to insert the information from these lists into one array (24 numbers long) by portioning the power usage into each hour chunk (averaged) so I can graph power usage over a 24 hour timeframe.
How can I firstly, create an array of size 24 (numbers) and then get the data from my bubble table (power data) and insert it into this array?
Once I have an array of 24 numbers, how can I then graph it with the X axis labels being 0:100, 0:200, 0:300… etc. (representing 24hr time).
Any help would be greatly appreciated.
Thanks so much everyone.