Measures In EazyBi

Questions & Answers
1

Hi Community,
Have used Power Pivot in Excel in order to be able to produce data for L3 support. It works fine but the real thing is to be able to create the report in EazyBi. Below you can find the related measures that i ve been using in Power Pivot.

image
image1143Ă—140 6.54 KB

Based on these measures, relates Kpis are produced and reach trhe management. Do you think that these can be created in EazyBi? Thank you.

2

Hi Giorgos,

Sure thing!

Let’s go through this step by step.

  1. You need to import custom fields “Incident Escalated” and “Categorization” into eazyBI;
  2. Go to your account in eazyBI, in the Source Data tab, click Edit for your Jira source;
  3. Go to the “Custom fields” section, find these two fields in the list, select all the available checkboxes for them, and run the import;
  4. After the import finishes, go to the Analyze tab and create a new report;
  5. Choose any dimension, for example, Project, and drag it to the Rows section;
  6. Next, in the Measures dimension define 3 new measures:

new-measure
new-measure2802Ă—1492 313 KB

The formulas would be something along these lines:
Escalated Bugs:

(
  [Measures].[Issues created],
  [Incident Escalated].[YES],
  [Categorization].[Software Bug],
  [Resolution].[Done]
)

Non Escalated Resolved:
This formula will work correctly if the “Incident Escaleted” only has one possible value- “YES”. It subtracts issues with “YES” from all resolved issues to get the count.

(
  [Measures].[Issues created],
  [Resolution].[Done]
)
-
(
  [Measures].[Issues created],
  [Incident Escalated].[YES]
  [Resolution].[Done]
)

FCR Ratio:

CASE WHEN
[Measures].[Issues created] > 0
THEN
(
  [Measures].[Escalated Bugs]
  +
  [Measures].[Non Escalated Resolved]
)
/
[Measures].[Issues created]
ELSE
0
END

Set the formatting for this one to Numeric → Decimal or Percentage.

Let me know if this works as expected!
​Best regards,
​Nauris

3

Hello @nauris.malitis, it really works, made some changes based on needs and it is fine. Actually was quite simple. Really thank you.