I have a question here, I set the Measure to show the last updated, then I have this result (13 Issues)
I tried to match it up with Jira data and I have 14 Issues:
So, I identify the Delta and I found this Issue: AIB-75.
Curious detail is that Updated date on that issue is 06/Jul/2020 11:23 PM on Jira. But EazyBI read it as July 7:
I checked on the Database server and the timezone is the same as in Jira, so why EazyBI is reading it as July 7th?
There can be two reasons why the dates in eazyBI appear differently than you see those in Jira.
- If your user profile in Jira has a Time zone setting different than the Jira Server time zone. Then all the dates in Jira appear converted from the Server timezone to what you have set in your profile. eazyBI by default imports the dates with the server timezone
- You can configure the time zone in the eazyBI data source if you wish to convert the time from the server time zone to some other:
You can add in your report the Issue updated date property (change the formatting to the date and time) to see the time shift in eazyBI. Once the date is close to the date end or start, it may result that measures with time shifts by a full day.