The data is stored on Elasticsearch in EST timezone and whenever I try to plot a time-series data on a Graph panel (also in Bar chart panel), I find the following issue-
1. The Graph shows numbers for UTC timezone no matter even the dashboard is saved in EST
Metric has a group by Date Histogram interval as 1d. For example- If I set the dashboard to show the data for Yesterday,
it splits the visualization into two separate buckets- from 12am to 8pm (EST) and 8pm to 11:59pm (EST)
but the legend shows the number for the entire day in 12am to 11:59pm (EST)
I want to keep the dashboard in EST timezone, as this would give correct numbers for other panel in the dashboard without any mess.
Is there a work around to get the data in Graph panel in EST time?
Any help would be appreciated!