Hi everybody, I’m using a barchart from ApexCharts and I need to set dynamic series, that’s why I’m using the Json Array feature.
However, I’m having problem to set it correctly.
This is an example of my database:
| Set | Cast date | Age | Strength |
|---|---|---|---|
| 1 | 15-jun | 7 | 31 |
| 2 | 18-abr | 7 | 50,67 |
| 3 | 18-abr | 7 | 51 |
| 4 | 18-abr | 28 | 54,67 |
| 5 | 18-abr | 28 | 28,83 |
| 6 | 15-jun | 28 | 29,33 |
| 7 | 16-abr | 14 | 29,33 |
| 8 | 16-abr | 14 | 23 |
I need to display the information to get the following chart:
I’m attaching an excel file with an example of the database and the expected outcome.
I created a grouping first, so I can get a new table with Age, Date an the average strength.
Then I used it to fill the Series category in the chart
To create the series, I set the following Json. What I need to do is to group the grouping againt, this time only by Age, and then get the list of averages I already calculated in the original grouping:
But the problem is that I cannot filter a Grouping element, which I think could be the solution for this. In this case, If a get the original grouping and filter it by the second grouping age, I will get the list of averages. But Bubble only references to the last grouping, not the first one.
I also tried another approach, not referencing to a grouping but to a repeating group doing a Search For, but the problem was that it didn’t link the data with the dates. So, even though I could retrieve the correct data, it didn’t filled the chart by date, only by order of appearance. So empty places were filled with data from the next date.
I hope I’ve made myself clear enough. I tried different approaches but I always reached a dead end. Maybe the answer is simpler than I think…
Thanks a lot!