# Trying to crate an avg of issue

**URL:** <https://community.eazybi.com/t/trying-to-crate-an-avg-of-issue/9968>\
**Category:** Questions & Answers\
**Created:** [July 6, 2022, 2:26pm UTC](https://community.eazybi.com/t/trying-to-crate-an-avg-of-issue/9968 "2022-07-06T14:26:02Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![Hadar\_Pinko](https://community.eazybi.com/user_avatar/community.eazybi.com/hadar_pinko/32/4852_2.png) [@Hadar\_Pinko](https://community.eazybi.com/u/Hadar_Pinko)\
**Post date:** [July 6, 2022, 2:26pm UTC](https://community.eazybi.com/t/trying-to-crate-an-avg-of-issue/9968/1 "2022-07-06T14:26:02Z")

</div>

trying to crate an avg of issue

i have a type of measure that counts a filed cold Configuration issue created  
i like to crate an avg of this parameter per num of jira ticket of the same scope

sum of Configuration issue / num of jira in the same scope

how can i do that?

for ref in looks like this

scope Configuration issue created  
x 20  
y 30

each scope contains diffrent num of jira ticket

so if x contains 10 jira id like to get avg = 20/10 = 2

---

<div class="post-metadata">

**Author:** ![martins.vanags](https://community.eazybi.com/user_avatar/community.eazybi.com/martins.vanags/32/8905_2.png) [@martins.vanags](https://community.eazybi.com/u/martins.vanags)\
**Post date:** [July 14, 2022, 8:40am UTC](https://community.eazybi.com/t/trying-to-crate-an-avg-of-issue/9968/2 "2022-07-14T08:40:49Z")

</div>

@Hadar_Pinko

If “Configuration” is a numerical field in JIra, make sure you import this field as measures from the [import options](https://docs.eazybi.com/eazybi/data-import/data-from-jira#DatafromJira-JiraCustomFields) page.  
That would create new measures “Configuration created” which would return the sum of the Configuration field values for all issues created in the report context.

Then create a new [calculated measure](https://docs.eazybi.com/eazybi/analyze-and-visualize/calculated-measures-and-members/calculated-measures) using this formula:

`[Measures].[Configuration created] / [Measures].[Issues created]`

Martins / eazyBI

---

<div class="post-metadata">

**Author:** ![Hadar\_Pinko](https://community.eazybi.com/user_avatar/community.eazybi.com/hadar_pinko/32/4852_2.png) [@Hadar\_Pinko](https://community.eazybi.com/u/Hadar_Pinko)\
**Post date:** [July 14, 2022, 1:02pm UTC](https://community.eazybi.com/t/trying-to-crate-an-avg-of-issue/9968/3 "2022-07-14T13:02:08Z")

</div>

it doesn’t work for me for ex.  
i have configuration sum =1 who came from one jira so i should get 1 in the avg  
but i get 0.05 instead

the avg make no sense i use this in my average  
: [Measures].[Configuration issues created] / [Measures].[Issues created]

![image](https://community.eazybi.com/uploads/default/original/2X/4/4956aa4c5c3bfa4b1acc53dc0577db19229ab289.png)

---

<div class="post-metadata">

**Author:** ![martins.vanags](https://community.eazybi.com/user_avatar/community.eazybi.com/martins.vanags/32/8905_2.png) [@martins.vanags](https://community.eazybi.com/u/martins.vanags)\
**Post date:** [July 14, 2022, 1:55pm UTC](https://community.eazybi.com/t/trying-to-crate-an-avg-of-issue/9968/4 "2022-07-14T13:55:53Z")

</div>

What other dimensions do you use in your report layout (rows, columns, page filters)?

Martins

---

<div class="post-metadata">

**Author:** ![Hadar\_Pinko](https://community.eazybi.com/user_avatar/community.eazybi.com/hadar_pinko/32/4852_2.png) [@Hadar\_Pinko](https://community.eazybi.com/u/Hadar_Pinko)\
**Post date:** [July 17, 2022, 10:02am UTC](https://community.eazybi.com/t/trying-to-crate-an-avg-of-issue/9968/5 "2022-07-17T10:02:26Z")

</div>

![image](https://community.eazybi.com/uploads/default/original/2X/9/922b13b8738ff909abd07a49e93af3a52e1c8a61.png)

---

<div class="post-metadata">

**Author:** ![martins.vanags](https://community.eazybi.com/user_avatar/community.eazybi.com/martins.vanags/32/8905_2.png) [@martins.vanags](https://community.eazybi.com/u/martins.vanags)\
**Post date:** [July 18, 2022, 7:15am UTC](https://community.eazybi.com/t/trying-to-crate-an-avg-of-issue/9968/6 "2022-07-18T07:15:59Z")

</div>

Can you add the measure “Issues created” in columns (as 3rd measure) for your report and send me a screenshot with 3 measures in your report?  
Could it be that there are issues without Configuration issue value?

Martins / eazyBI

---

<div class="post-metadata">

**Author:** ![Hadar\_Pinko](https://community.eazybi.com/user_avatar/community.eazybi.com/hadar_pinko/32/4852_2.png) [@Hadar\_Pinko](https://community.eazybi.com/u/Hadar_Pinko)\
**Post date:** [July 18, 2022, 7:57am UTC](https://community.eazybi.com/t/trying-to-crate-an-avg-of-issue/9968/7 "2022-07-18T07:57:15Z")

</div>

![image](https://community.eazybi.com/uploads/default/original/2X/2/2b84b7b0b7beca6614f0d59a6c5b1200453a7854.png)

just to clarify not all issue created as the parameter configuration issue

---

<div class="post-metadata">

**Author:** ![martins.vanags](https://community.eazybi.com/user_avatar/community.eazybi.com/martins.vanags/32/8905_2.png) [@martins.vanags](https://community.eazybi.com/u/martins.vanags)\
**Post date:** [July 18, 2022, 8:39am UTC](https://community.eazybi.com/t/trying-to-crate-an-avg-of-issue/9968/8 "2022-07-18T08:39:54Z")

</div>

Thanks.  
That is the real reason why you don’t have expected average results.

Please use **advanced settings** to define “Configuration issues” as a separate dimension. Then select to import new dimension in the eazyBI cube.  
See how to import numerical field as dimension: [Sprint Point Wise categorization - #3 by lauma.cirule](https://community.eazybi.com/t/sprint-point-wise-categorization/350/3)

Finally, use this formula for final your calculated measure:

```auto
[Measures].[Configuration issues created] 
/ 
Aggregate( 
	Except( 
	[Configuration issues].[Configuration issues].Members, 
	{ 
		[Configuration issues].[(none)]
	}),
	[Measures].[Issues created]
)

```

Martins / eazyBI