How to calculate the total value attributes from asset objects in a Jira report, grouped by issue types

Questions & Answers
1

Hello,

I am trying to create a report in EasyBI based on issue types , using attributes from an asset object.
Issue have field Server, reference to asset object

I have an asset object with integer attributes:a Server object has attributes like CPU and RAM.

My goal is to create a report that shows, grouped by issue type, the sum of these attributes.

I have defined the attributes as dimensions and properties from issue field:

[jira.customfield_NNNNN]
assets_object_attributes = [
{name = “CPU”, data_type = “integer”},
{name = “RAM Gb”, data_type = “integer”}
]
I also added an additional hierarchy level based on these properties.

Currently, I can get the number of issues by CPU, but I need to calculate the total amount of CPU and RAM per issue type.

image
image678×363 11.1 KB

the total number based on CPU would be calculated as:
type1 = 0 * 1 + 4 * 1 + 3 * 16 ,
type2 = 32+44 + 161
type3 = 31 + 4*1
Could you please advise how to sum these attributes correctly across issues?

Thank you.

2

HI @Irina_V4

If you are using CPU dimension in the report columns, then you may want to create the following measure, which iterates through all CPU dimension members, converts their name (string) to intege,r and multiplies by the issues resolved, and then sums it up:

Sum(
  DescendantsSet([CPU].CurrentHierarchyMember,[CPU].[CPU]),
   CASE WHEN [CPU].CurrentMember.Name <> "(none)"
   THEN
     Cast([CPU].CurrentMember.Name as INTEGER)
     *
     [Measures].[Issues resolved]
   END
)

In the DescendantsSet and CAST functions reference to the dimension and level name where CPU is stored, if it is not CPU dimension.

Add this measure in the report columns instead or additionally to Issues resolved.

Best,

Ilze, support@eazybi.com