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.
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:
name = "Audit"
data_type = "integer"
measure = true
multiple_dates = true
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 / email@example.com