When I drill through on a pivot table with a summarized date by week, month, quarter, or year, the filter is set to the previous period and NOT the one that I’ve selected.
For example, if you drill through in February, you will get the wrong filter for Jan 1-31, and so incorrect data will be shown.
This only affects pivot tables….
More detailed example:
Go to a Dashboard with a pivot table with a summarized date by week, month, quarter, or year
-
Click on cell
-
Click on 'See these records'
-
Check the filter
-
See issue that the Date period is not the one of the selected cell
We are currently on version v0.60.2. Please help!
it is known bug, tracked as GitHub #71147, still open in 0.60.2. Same family as #70358 (partially fixed by PR #70680 for day binning), but week/month/quarter/year still produce that off-by-one filter.
Two things that usually help:
- If your JVM timezone differs from
report-timezone match them. Restart Metabase with JAVA_TIMEZONE=Europe/Berlin.
- If timezones already line up, skip the broken auto-drill: on the dashboard, set Click behavior - custom destination on the pivot card and pass the date column as a parameter to another question. You lose the native "See these records" button, but the filter is correct.
Cheers, Nick @ Valiotti Data
Can you provide a reproduction case for this issue? I’m not able to reproduce it locally using Sample Database data, and a fix was committed back in March. 0.60.2 should have it. I’m running 0.59.9 here at the moment.
Also, can you provide some details of your setup? Specifically, what database the malfunctioning pivot table is accessing, and the diagnostic info from Admin → Tools.