How do I create a bar chart where individual bars represent sums or averages over a time range?

I have a table of expenses with the format (Date, Type, Amount)
I would like to have a bar chart that displays the sum of the expenses over a time period, such as a Month or a Year. How do I do this in Coda?

Dear @Jeffery_Zhang,

Welcome in the community.

I recommend to open a new doc and to use the prepared “expenses” one

Of course you can also play with the sample I share in this post:

In the view “Expenses by Category” I changed the chart type to “bar chart”.

In this section you can filter according your requirement:
image

Succes,
//JP