I have a custom field called “Automation Status” which I am using to indicate if a test in JIRA-Xray is “Automated” , “Manual" or “Pending Automation”. I want to create a chart that displays the cumulative count of tests per month where the “Automation Status” field was changed to “Automated”. How do I go about doing that?
If this custom field is a single-select custom field, you can enable value change import, using advanced settings as described there: https://docs.eazybi.com/eazybijira/data-import/custom-fields/advanced-settings-for-custom-fields#Advancedsettingsforcustomfields-Importchangesofcustomfielddimensions
After changes are imported, you may create a custom measure (in Measures) to count issues having transitions to a specific field value. The calculation would contain hidden dimensions and measures for counting changes https://docs.eazybi.com/eazybijira/data-import/jira-issues-import/import-issue-change-history#Importissuechangehistory-Historicalmeasures:
[Measures].[Transitions to issues count],
[Transition field].[Automation Status],
Check dimension “Automation Status” and member “Automated” names!
Then, in the report, select Time dimension in rows and use needed level (days or months) and this newly created measure in columns. Then use option “Add calculates” --> “Cumulative sum” --> With empty or Without empty to get column with a cumulative value: https://docs.eazybi.com/eazybi/analyze-and-visualize/create-reports#Createreports-Addstandardcalculationsbasedonaselectedmeasure
Ilze / firstname.lastname@example.org