We've been using Metabase for several months now and we are pretty happy with it so far.
Now I think I found a bug:
Lately I started trying out the pivot table feature and found it quite useful until I realized the Totals were not adding up correctly, neither on rows nor columns. This was driving me crazy, so I searched here and on github and apparently nobody has ran into this problem, so maybe I'm doing something wrong:
I'm pivoting a very simple table with a couple of dimensions and a measure:
It's very easy to see that the totals don't match. But why? If I download the results in a csv and pivot the table in LibreOffice, the totals do match:
Hi @ralcm
Interesting. Since the totals are nearly correct (and on 2021-06-06 they match), my brain is instantly thinking about timezones.
Post "Diagnostic Info" from Admin > Troubleshooting.
Pivot Table queries are quite difficult to debug, since it's a big collection of queries that generate the final result. It would probably require that you looked at the database query log to see exactly what's going on.
Are you able to post the plain (non-pivoted) table of the result, so I can try to see if I can reproduce?
@ralcm Okay, you need to check your query log, so we can understand what is happening.
I would need the raw database table (including schema) to understand what's going on.
I'm still quite sure it's a timezone problem. Could it be that your "created_at" column is without timezone?