Get percentage of issues in each status/total issues created for a specific Sprint and Project

Questions & Answers
#1

Good afternoon.

I am new in eazyBI and I am trying to create a formula, but I do not see how to do it.

Image_eazyBI
Image_eazyBI1726×564 29 KB

Issues created: 11
Project: Salesforce
Sprint: Tablero Sprint 1
Status: EN PROGRESO (2), HECHO (3), POR HACER (4), SUBIR A PRODUCCIÓN (1), VALIDACIÓN (1)

I’d like to do this:

  1. EN PROGRESO BAR 2/11 = 18,18%
  2. HECHO 3/11 = 27,27%
  3. POR HACER 4/11 = 36,36%
  4. SUBIR A PRODUCCIÓN 1/11 = 9,09%
  5. VALIDACION 1/11 = 9,09%

And show the bars for each status by the total issues created for a specific Sprint and Project. Anyone has an idea on how to do it?

Thank you!!!

#2

Hi @fprat

Welcome to the eazyBI community!

If you are creating a report for ongoing sprints, then use, in columns, measure “Issues created” together with the Status dimension in rows. Project and Sprint select in Pages for filtering report.

Use option Add calculated → % from total, and the column with “Issues created %” would be automatically created. After that, you can remove “Issues created.”. Read documentation: Add calculated

image
image1676×1016 96 KB

Then switch to the Bar chart, add data labels.

image
image1872×1334 145 KB

If you want to get information about closed sprints, use one of Sprint scope measures (Sprint issues committed, Sprint issues at closing) and Transition status dimension instead of “Issues created” and Status. Read in the documentation: Sprint scope measures

Best,
Ilze / support@eazybi.com