I am trying to create a report that shows the changes of a calculated text field over time. For example, when a JIRA issue is created in March, this custom field is "Not calculated". Then, this field is changed to a value of "Low" in April. I need my report to show that the value of this field at the end of a monthly time period, so March would displays this issue as "Not Calculated", and it April it would show it as "Low". I have attached screenshots of custom field and what our report currently looks like. Any help will be appreciated.
Hi,
Katherine is absolutely right: you can import the change history of this "Test Priority" field using Advanced settings. Then your report with "Issues history" measure would give the number of issues with historical test priority at the end of the selected time period.
The only precondition: "Test priority" should be a single-value field.
To achieve that, you may want to do the following:
1) Modify advanced settings for this field: remove measures=true (as this ir not a numerical nor date field), and add separate_table=true and changes=true
[jira.customfield_10601]
data_type = "string"
dimension = true
separate_table = true
changes = true
2) Perform data import twice:
3) After double import, changes should be imported for the field and your report with "Issues history" and selected Time should retrieve issues by their historical Test priority values.
Ilze, eazyBI Customer Support Consultant
support@eazybi.com
This is not verified, but you'll need to check the change history option and add a line to the Advanced Settings. This line should have that information.
https://docs.eazybi.com/eazybijira/data-import/jira-issues-import/import-issue-change-history
Hopefully this will point you in the right direction. If nothing else, this can definitely help you indicate if a change has happened, the original value, and the new value.
Good luck!!
-Kat
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.