I am trying to get an average on a monthly basis.I have few issues from the month of June 2022 up to current month.
I have already calculated a number of days taken to complete the ticket. But now I’m looking for the month-by-month average.
(i.e. I need to sum off all no.of days taken to complete the ticket for all the issues that in June 2022. and then for July 2022,and furthermore…)
And after that, I need to get an average for a monthly basis.
so in short, I need to calculate – the sum of all the total_days_taken/no. of tickets in specific months to get an average.
But how to calculate it in Eazy Bi.
Below is the table for reference.
||Issue Created Date
||Issue Updated Date
||Total_Days_taken(updated date-created date)
Kindly help with this that would be appreciated.
Welcome to the eazyBI community.
Our default measures include Average calculations - like “Average resolution days” and “Average closing days,” and these measures use closing dates. Please read more about our default measures here: Jira Core measures and dimensions
If you want to calculate the duration between the creation date and the last updated date, that is not our default measure, but here is a formula example on how to calculate the Average over time for the duration between the issue creation date and the last updated date
-- filter currently resolved issues by any dimension, except transition status
[Measures].[Issues last updated] > 0
Also, we have a DEMO account with reports already prepared for different business cases. Please look into our Age, Lead, and Cycle time reports here:
Hi @ ilze.mezite
Thanks for the solution.
I tried out this solution but it’s giving me a blank column.
Also can we please calculate the month by month average.for June, July ,Aug, n more.
e.g. To calculate the average for June2022, we need to use the logic like (sum of the total_days_taken divide by total count of tickets or number of tickets) that happened in June month only. Like wise for one by one month I need to calculate the average day .
That would be a great help.
Thanks in advance !!
I’m sorry to hear that. This formula is fundamental - if there is an updated issue in the period, it should show in the report.
Did you perform the data import?
To help you more I need more information: report definition for example or print-screen of the report.
Please get in touch with support: email@example.com
Hi Ilze Mezite,
I didnt perform the data import.
And actually this is my office work, hence I am unable send the print screen because all this is I am asking from my personal laptop.
But the dashboard in eazyBi is looking same as I shared it above with few of the examples- and it’s till date.
so till now I have been reached up to total_number _days_taken, but now looking for an average as I mentioned in my above question.
We highly value sensitive customer data. We need information on how far you have come with the report so we can help you move on from that point.
Therefore, I suggest contacting eazyBI support and discussing this report further there. For that we will need a report definition, which typically does not contain sensitive information, but a technical report setup. A screenshot from eazyBI or Jira would also be desirable, but we can start with the definition of the report and then see what else is needed.
You can export the report definition and save it in the text format and send it to the eazyBI support.