Calculate an average of an issue property in the project level

Hi Community,

Hope you can help me with this, most of it is explained in the image.
But let me know if you have any doubt or question

Thanks in advance


Hi @rodrigo.alvareztopa,

When calculating the average, it is essential to specify

  • items and level from which to calculate the average.
  • should it include or exclude zero values.

In some cases, the simple dividing works, like in your case for individual epics, the Compliance % is calculated correctly. But in some cases, it requires specifying the item and level for average calculation.

For example, to calculate the compliance rate at epic level only for epics that have a compliance rate (exclude zero), the expression might look like this:

  --set of epics for average calculation
    --iterate through issues at epic level
    --check if epic has any resolved Passed issues to exclude 0 from the average calculation
    ([Measures].[Issues resolved],[Status].[Passed]) > 0
  --for each epic, calculate the compliance %
  ([Measures].[Issues resolved],[Status].[Passed]) /
    ([Measures].[Issues resolved],[Status].[Passed]) + 
    ([Measures].[Issues resolved],[Status].[Failed])  

More details on aggregate functions are described in the documentation:

Zane /

Thanks zane.baranovska
It worked like a charm.

Greta day to you!!

1 Like