Bubble Charts have X, Y and Size dimensions. But there's no way to provide Size, only static circle sizes accepted (via "Group Styles" --> "Size"). How do I do it?
Hi @pavelgur! Thanks for reaching out - let me see if I can help provide any guidance here.
Could you please describe a little more what it is you're trying to accomplish with the Bubble Charts sizes? We should be able to configure the Bubbles' size by passing in an array of size values. If you wanted to dynamically set these sizes, you can accomplish this by creating variables within your Retool app to store and control these values, and then read from them directly from the Sizes input.
Here's an example screenshot of what I'm describing above:
If you take a look on the left, I created a variable called variable1 and set its value to 120. Then on the right, I'm using that value directly within the Sizes array to set the last Bubble's size. These variables can be changed through queries and actions, which would allow for your Bubble size to dynamically change.
I hope this helps answer your question! Please let me know if there are any gaps in my understanding or if I can help in any other way.
1 Like
I understand. Static sizes do not really make sense to me though. I.e. with heatmap you can specify the third dimension, but with bubbles you suddenly can't.
Let's consider an example. I have a data source with three rows:
| X | Y | Value |
| 1 | 2 | 1 |
| 2 | 4 | 2 |
| 2 | 4 | 3 |
| 2 | 5 | 4 |
I expect to get the following bubbles:
| X | Y | Size |
| 1 | 2 | 1 |
| 2 | 4 | 5 |
| 2 | 5 | 4 |
because for each pair (x,y) I expect values to sum into the bubble size. Color of the bubble should be determined by Y value. What chart parameters should I choose?
Thank you.