Help with aggregating dates into months

MLO
Observer

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 57
1 REPLY 1

Dawid
Participant V

Create a dimension_group with your date and use timeframe: month. Here is a doc:

https://cloud.google.com/looker/docs/reference/param-field-dimension-group

Top Labels in this Space
Top Solution Authors