Average and Mean Days in Transition Statuses

Questions & Answers
1

Hi all,

I am trying to create a report that will show average or mean value of the days that tickets spent in the statues that are related to my company (excluding client-related statuses)

I grouped the statuses that are company-related but I need a gauge report that will show only one final value.

Can you please explain how i can do this?

image

2

Hi @JelenaInk ,
You can create new calculated measures in Meausre dimension:

  1. Average:
Avg(
  ChildrenSet([Transition Status].[Ink Statuses]),
  [Measures].[Average days in transition status]
)
  1. Median:
Median(
  ChildrenSet([Transition Status].[Ink Statuses]), 
  [Measures].[Average days in transition status]
)

Use in Rows your aggregate “Ink Statuses” from the “Transition Status” dimension together with new measures:

eazyBI_Ink_Statuses
eazyBI_Ink_Statuses2238×554 112 KB

Best,
Gerda // support@eazybi.com