History across two custom fields (Date & Value) and create Graph from this values


#1

I have 2 custom fields, Audit date & Audit value. On a bi-weekly or monthly basis, users enter value in both the fields. For example:
Audit Date | Audit Value
1-Jan-2018 | 10
1-Feb-2018 | 20
1-Mar-2018 | 40
1-Apr-2018 | 60

Now I want to have this history of values across both fields, to display in similar table as shown above and also plot them graph, to show the trend of values across months. How do I achieve this? I tried to add Audit date as Dimension, but I kept getting an error. Any help would be helpful.


#2

The simplest solution could be using value changes of custom field Audit value. If you are updating the value there on the same date/period when an audit took place it would represent the audit date as well.

You would like to import value changes for this number field. eazyBI support value changes import for Jira standard number custom fields by default.

eazyBI should import several measures representing historical values of this custom field. The measure Audit value history should show Audit value over time. You can use Time dimension in a report on Month level and see audit value at end of any month.

If you are updating values in both custom fields at any other time and Audit value changes to import and default measures are not enough, you would like to use JavaScript calculated custom field. Where you can go through issue change history for those two fields and combine them as one string in this structure:

date1,value1
date2,value2

Use comma separator for audit date and value and new line separator for each entry. You would like to use multiple_dates parameter for the custom field definition.

Here is an example custom field definition:

[jira.customfield_audit]
name = "Audit"
data_type = "integer"
measure = true
multiple_dates = true
javascript_code = '''
...
'''

I do not have JavaScript code as an example, though.

You would like to import value changes for Audit date, Audit value, and select the new custom field Audit** for import as measure into eazyBI after defining it into eazyBI advanced settings.

Daina / support@eazybi.com