EazyBI - Calculated Text Field Historical data

Question

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.

Ilze Leite-Apine - eazyBI · Answer

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:

* first, unselect "Test priority" field from data import at all (to drop all existing database structures for this field),
* then select this field to be imported as a dimension with value changes and run the data import again.

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

unknown · Answer

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