Bubble Charts (how to :sum dates)?

Hello, I’m using Bubble Chart Plugin.
I have a “Payments” database.

Inside this database, there are some fields (Date, Price, etc.)
But the fields that I’m showing through Chart are Date and price.

Imgur

I would like to show only one day, and a: sum of the prices of that day.
But is showing all the dates (even if it’s the same day multiple times).

I have tried many filtering options but I can’t figure how to filter one-unique-day:

Imgur

Any idea?

1 Like

Use the :group by option. Add a grouping for date and an aggregation to sum your price. Set it up just like this

And you should get this:

image

2 Likes

This topic was automatically closed after 70 days. New replies are no longer allowed.