How do I create Bar Chart from Firebase with group/sum by date with date range filter?

I have Firebase collection named Expenses.

Here is list of field.

DateTime, Type=DateTime

Amount, Type=Double

Example data

13/9/2023 11:00 780.00

14/9/2023 8:00 200.00

14/9/2023 9:35 10.00

14/9/2023 17:00 3000.00

15/9/2023 7:30 150.00

Filter

Start date = 14/9/2023

End date = 15/9/2023

I want to create Bar chart with list of expenses those sum by date with filter.

X-axis = date (example, 14/9/2023)

y-axis = amount (should be flexible to cover min/max of data)

Please kindly advise.

1 reply