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.
Redirecting…
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 on the first post
1 Like