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 |
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