[Solved] Trends and Months / Dates?

Probably super basic, but it’s got me beat. I wanted to set a Trend card for my wife’s data showing monthly average sale price per item. I set the date of sale field as a date in the Models admin section, and now I get a trend for daily change, but can’t figure out how to get it to show monthly instead.

Any help is greatly appreciated.

Hi @bmcgonag
You need to change the granularity of the date field, so it’s grouped by Month.

So simple! You guys rock! Thank you so much.

hello @flamber, i have the same problem, and i have tried as you example, when i change group by year it works, but when i group by month or other it doesnt work

@rullisubekti If you're using SQLite, then you're seeing this issue:
https://github.com/metabase/metabase/issues/12388 - upvote by clicking :+1: on the first post

1 Like