Proposal: Allow user to set desired Timezone
Nobody has claimed this yet.
- Dominant language
- Clojure
- Stars
- 49.3k
- Forks
- 6.8k
- Avg merge
- 1d 13h
- Merged PRs (30d)
- 653
Description
Our users of Metabase would like to query and view data in their local timezone (US/Eastern). I have tried using the Timezone setting in Admin but it does not produce desired results.
- MySQL timezone is UTC
- Data is stored in UTC
- Our staff is in US/Eastern
If I set timezone to UTC in Admin, it reports data correctly in UTC.
If I set timezone to Eastern, data is reported 5 hours earlier than Eastern time, and 10 hours earlier than UTC.
Ideally, as an admin I could set the Timezone to UTC and allow a user to set their own timezone, or alternatively just choose to show all data in Eastern time since all of ours users are in that timezone.
---
- Your browser and the version: Chrome 55.0
- Your operating system: MacOS 10.12.2
- Your databases: MySQL
- Metabase version: 0.22.2
- Metabase hosting environment: Elastic Beanstalk
- Metabase internal database: Postgres
:arrow_down: Please click the :+1: reaction instead of leaving a `+1` or `update?` comment
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
The issue names no files, tests, or entry points. Start by reproducing the timezone mismatch with MySQL data stored in UTC and Metabase's Admin timezone settings, comparing UTC and US/Eastern results. Done means the selected timezone behavior matches the requested admin or per-user workflow for querying and viewing data.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- clojure, mysql, postgresql
- Domain
- data-visualization, databases
- Issue type
- Feature
- Difficulty
- 5/5
- Estimated time
- Over a week
- Activity status
- Quiet
- Clarity
- Mostly clear
- Newbie friendliness
- 32/100