Different result set

Henrique · February 18, 2019, 5:19pm

Hi, in my query I receive a value, but, when I put in a graphic on metabase, it return different values.

flamber · February 18, 2019, 5:25pm

Hi @Henrique
What version of Metabase? What database type?
My first guess would be that this relates to timezone issue:
https://www.metabase.com/docs/latest/troubleshooting-guide/timezones.html

Henrique · February 18, 2019, 6:06pm

Hi, I using metabase version 0.31.2 with Postgresql.

flamber · February 18, 2019, 6:09pm

@Henrique
Have a look at the timezone guide and try doing a query without grouping, so you can see exactly which rows are included both places.

Henrique · February 18, 2019, 6:14pm

I go try!