Help with aggregating dates into months

MLO
New Member

I track all my expenses with a date column (yyyy-mm-dd).
How can I view a chart that sums all of my expenses per month?

For example:

my data looks like this

date amt
2022-01-01 15
2022-01-14 5

I need Looker to show a chart that interprets the data this way

year / month amt
2022 January 20
1 1 69
1 REPLY 1
Top Labels in this Space