Eazy BI sum calculation

     	                                   SP         Sum
                                            closed

Project A Team A Sprint 1.1 A A+F
Project A Team A Sprint 1.2 B B+G
Project A Team A Sprint 1.3 C C+H
Project A Team A Sprint 1.4 D D+I
Project A Team A Sprint 1.5 E E+J
Project B Team B Sprint 1.1 F
Project B Team B Sprint 1.2 G
Project B Team B Sprint 1.3 H
Project B Team B Sprint 1.4 I
Project B Team B Sprint 1.5 J
Hi Team,

Greetings everyone ,I am new to eazy BI,looking for some help on a work for sum calculation.I have a report which is shown above ,basically it shows me a project with two teams (Team A and Team B) now each team delivers some story points at the end of every sprint.

My query is how to define the calculated measure for the summation of the story points closed by all teams summed up .

Would be grateful if someone guides me through the above procedure.

Thanks,
Tushnik

Hi,

Thank you for using eazyBI and posting in our community.

There could be several solutions for getting totals; I would suggest starting from the simplest by adding the Total row option to the report:

Kindly,
Janis, eazyBI support

Hi,
what’s the dimension of the second column (Agile team, promo team)?
I use dimension “Team” but it’s always empty.

Regards
Monica

Hi, Monica,

The second dimension in the rows is the Reporter dimension (could be also Assignee), where several users are aggregated as teams in custom calculated members. In my case I aggregate users from a specific Jira user group:

Kindly,
Janis, eazyBI support