Average calculation for the specific month by month

Questions & Answers
, ,
1

Hi,

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)
+June 2022 FCII-13493 Item 15-06-2022 04:51 21-06-2022 07:47 6.122222222
FCII-13494 Item 16-06-2022 06:15 19-06-2022 03:15 2.875
FCII-13486 Item 17-06-2022 05:20 20-06-2022 04:58 2.984722222
FCII-13485 Item 17-06-2022 07:18 20-06-2022 02:50 2.813888889
FCII-13483 Item 19-06-2022 06:30 20-06-2022 06:05 0.982638889
FCII-13482Item 20-06-2022 05:28 23-06-2022 06:10 3.029166667
+July 2022 FCII-13481 Item 20-06-2022 04:51 24-06-2022 04:51 3.999999942
FCII-13480 Item 20-06-2022 04:51 25-06-2022 04:32 4.986805556
FCII-13479 Item 23-06-2022 04:51 26-06-2022 05:10 3.013194502
FCII-13494 Item 24-06-2022 04:51 27-06-2022 04:51 3

Kindly help with this that would be appreciated.

Many Thanks,

Smita Kalunge

2

Hi, @Smita_Kalunge

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
​

AVG(
Filter(
Descendants([Issue].CurrentMember, [Issue].[Issue]),
DateInPeriod(
[Issue].CurrentHierarchyMember.Get('Updated at'),
[Time].CurrentHierarchyMember)
),
CASE WHEN
-- filter currently resolved issues by any dimension, except transition status
[Measures].[Issues last updated] > 0
THEN
DateDiffDays(
[Issue].CurrentHierarchyMember.get('Created at'),
[Issue].CurrentHierarchyMember.get('Updated at')
)
END
)

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:
https://eazybi.com/accounts/1000/dashboards/7513-age-lead-and-cycle-time

Kindly,
Ilze
support@eazyBI.com

3

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. :slight_smile:

Thanks in advance !!

4

Hi, @Smita_Kalunge

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: support@eazybi.com

Kindly,

Ilze

5

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.

Thanks,

Smita

6

Hi, @Smita_Kalunge

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.

Kindly,
Ilze