I’m new to metabase. I created a question and I do have date field on my data source. I sort my date field to ascending and it run successfully. However when I want to change from ascending to descending, I got an error saying that
There was a problem with your question
Most of the time this is caused by an invalid selection or bad input value. Double check your inputs and retry your query.
ERROR: column “posts.post_date” must appear in the GROUP BY clause or be used in an aggregate function Position: 613
I tried to change the sort type through three dots button and it run sucessfully. this is weird since there’s no problem with my data.
Any idea how to fix this issue?