Question
Which time zone does Zendesk Explore use?
Answer
In Explore, the time zone that applies is based on the User profile time zone.
The User profile time zone is used by dashboards, dashboard content, dashboard exports, the dashboard email delivery trigger time, query builder, query export, and drillthrough.
Dashboard content sent via dashboard deliveries uses the recipient's time zone.
For more information on dashboard deliveries, see Sharing Dashboards.
16 Comments
Hi James,
If I want to download a dashboard to share, is there a way to set the time zone manually? For instance, our leadership team is mainly ET based but my time zone is MT. How can I adjust the dashboard to export the queries in ET?
Cheers,
Candace
Hi Candace,
At this point there is not a way to specify the timezone for an individual dashboard within Explore. All of the dashboards will be based on your support user profile's time zone.
Please let us know if we can help with anything else!
Thanks for the confirmation, Austin.
If anyone else wants to see this feature added, please vote for this Product Feedback post:
https://explore.zendesk.com/hc/en-us/community/posts/360004395028-Allow-time-zone-to-be-set-on-the-dashboard-level
Hello,
I've run into the following problem.
I need to report by an hour (# of accepted calls between 8am and 5pm). Since the query is built in UTC, I select 4pm (16) and 11 pm (23) in the filter, as UTC is 8 hours ahead from PST. I would technically need to select an hour from the next day but I don't see how. So when I build the query, it looks more or less accurate. Then I add it to the dashboard, and the numbers are just completely ridiculously different from what it was in the query builder, and it indicates that time zone displayed is PST/Los Angeles (my actual time zone). I think the discrepancy comes from time zone confusion. Please advise how to build my report relying on a certain time zone.
Hello Stacy,
I'm so sorry to hear you're having trouble with that. Yes, I'm afraid that is expected since you have added the adjusted query report (your actual timezone) into your dashboard.
As quoted here: "Any query viewed in a dashboard is in your Support user profile time zone."
Instead of adjusting the time 4pm (16) and 11 pm (23) in the filter, as UTC is 8 hours ahead from PST, have you tried using the default 8am to 5pm since once you add that query into your dashboard it will adjust the time based on your user profile timezone (PST/Los Angeles).
Please let us know if we can help with anything else!
It's unclear which TZ is used for a date filter in Explore.
Let's say I am filtering to show all tickets created on date '2019-03-19' -> will the filter be applied differently for different users viewing the dashboard?
I understand that hours show differently when reporting by hour, but I am not sure about the cutoff of the filters. From my own QA, it seems inconsistent, so I am unsure what's the rule here...
Hi Gal!
Good day!
Sorry for the confusion, this depends on when account sync. For Lite account data is available for the previous day according to account time zone (all obtained before 00:00 of current day). For Pro data syncs hourly- so all before the current hour. For more information, please refer to this article: https://explore.zendesk.com/hc/en-us/articles/360002118227-How-frequently-does-my-Zendesk-data-sync-to-Explore-
I hope this helps!
Hi Shera,
That's useful detail - although I am not sure that is what I'm still confused about.
I am looking at dates that are a few days ago, with a filter for a single DAY (let's say a week ago). I want to see all the tickets that were opened on that one day. How is that filter applied? How does Explore determine the midnight to midnight timeframe of a single day in the past, based on the date? What timezone is being used for that?
Hi Gal,
So this depends on which specific data you are viewing if it's a dashboard, then it uses:
And yes, it represents midnight to midnight in your timezone.
Thank you Shera!
Hello!
I noticed an interesting thing.
Just for a note, my Zendesk account and my profile TZ are both (GMT -4) Eastern Time (US & Canada).
What happens is that when I create a query and add it to a dashboard- I see disparency in numbers. In my query, the agents have 90 calls, tho the same query in the dashboard shows 85 calls.
I did double check if I don't have any filters enabled in the dashboard and if the agent is also in the same TZ as me and the account- all seemed right.
Does anyone have an idea what could cause this? Or maybe noticed the same thing?
Thanks,
Mari-Liis
Hey Mari-Liis!
The Query builder uses UTC whereas the Dashboards will use your User profiles time zone of GMT -4. Since there is a 4 hour difference between UTC and GMT -4 that is why you are seeing this difference.
If you want to review your data based on your timezone it will be best to use the Queries once they have been added to your Dashboard.
Hi James,
Thanks for helping to understand it :) Makes sense now.
Hey James,
I see in the article you wrote and the comment you made above -- "The Query builder uses UTC whereas the Dashboards will use your User profiles time zone of GMT -4." is contradictory. As in the original article, it says that query builder uses user profile timezones
I also see the timezone shown at the bottom that corresponds to my profile timezone. So I am a little bit confused at the moment.
Any help clarifying this would be great!
Hi Eugene,
Just jumping in here to clarify James's comment. There has been an update to Explore recently where the query builders and dashboards should all show in your user profile time zone.
The only data in UTC time will be the content of the delivered dashboards.
Hey Jessica,
Thanks for the clarification! :)
Please sign in to leave a comment.