So If it works, Green square will be 97, Red square will be 24.
please help this problem.
p.s) I want to see the issue of the change of state for today. So, I used 'transition to status ’ of Measure Dimension and Transition Dimension. is it wrong?
Transitions to status would show every time issue makes this transition, not only the last time. Could it maybe be that it transitioned to resolved both in 18Nov and 19Nov? It is best to check these kinds of situations by adding Issue dimension to the report and filter by that issue.
Another guess is that maybe there are some inconsistencies with Time zone settings in eazyBI or Jira.
For us to further assist with investigations, could you send follwoing information to support@eazybi.com:
The issue changelog in JSON format. You can get it with following URL (change to your JIRA_BASE_URL): JIRA_BASE_URL/rest/api/latest/issue/OKRPG6-3212?fields=changelog&expand=changelog
Screenshot of the above described report - the same report you have only adding Issue dimension to pages and selecting the OKRPG6-3212 issue.
Screenshot from eazyBI Import Advanced settings where we can see the Time dimension Time zone configuration as well as what is Jira Server time zone?
This is answer no.2
(Screenshot of the above described report - the same report you have only adding Issue dimension to pages and selecting the OKRPG6-3212 issue.)
I would appreciate it if you could send me more information.
I think It seems to have something to do with time zone settings or may be different time zones when judging from internal logic.
OK, I received this and will investigate further. I just want to let you know that I saved locally the Issue JSON result and removed it from this request to not have it available for other community users.
After some investigations, we have found that the problem could be because of older version of eazyBI. I see you are using 4.4.1. Please upgrade to latest eazyBI version and let me know if the problem still persists.