Hello,
I am trying to close 5 JIRA issues a week and track the progress in an eazyBI report. How would i set the target of 5 issues and how would i limit the data being input to the report to issues with the status of closed?
Is there a way to set a starting year of 2024 even if i have issues from prior to that?
Thank you in advance
Hi
Welcome to the eazyBI community!
You may want to define closing statuses and use “Issues closed” measure to count weekly closed issues: Issues closed measure
As for the threshold, create a report-specific measure, where, in formula, write in the number of this limit, see example:
This measure always returns the set value.
In the report, add Time dimension Weekly hierarchy, weeks in the report rows. Add the measure “Issues closed” and your threshold measures in columns. Switch to a timeline, bar, or line chart, display closed issues as columns, and set the threshold as a dashed line.
The final report might look like the following:
Read how to customise charts: Customize chart
Best
IlzeLA, support@eazybi.com