eazybi report: average of issues created per day

fbeck_br October 7, 2022

Hello !

I would like to create a bar-chart report (or a table):

One bar for each month.

The size of each bar (each month) should be the average of created issues per day.

 

Example:

July:  total of 300 issues     -> average per day (300 / 30) = 10 issues per day

August:  total of 210 issues -> average per day (210 / 30) = 7 issues per day

September: total of 150 issues -> average per day (150 / 30) = 5 issues per day

 

I tried to use the calculation (https://docs.eazybi.com/eazybi/analyze-and-visualize/create-reports#Createreports-Addstandardcalculationsbasedonaselectedmeasure) , but not sure if is it possible do do it.

 

2 answers

0 votes
Janis Plume _eazyBI_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
October 9, 2022

Hi,

Considering the Time dimension is used in the report rows, the following custom measure should do the average calculation:

[Measures].[Issues created]/30

We can create a more advanced formula to have the exact number of days in the month:

 

([Measures].[Issues created])
/
DateDiffdays(
[Time].CurrentHierarchyMember.StartDate,
[Time].CurrentHierarchyMember.NextStartDate)

 

Kindly,

Janis, eazyBI support 

0 votes
Kate Pawlak _Appsvio_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
October 7, 2022

Hi @fbeck_br ,

If you're using an app, I recommend you create a ticket on the eazyBI customer portal: https://eazybi.com/contact. Unfortunately, I see that you have to wait until Monday to receive an answer.

Best,

Kate

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events