Filter rows bigger than average

Questions & Answers
1

Hello everyone,

I have a project where the issue type is marked with the field component and want to show only those issues that the time spent in all columns is bigger than the average of the component.

2020-12-15 17_00_15-WinDev2008Eval Corriendo - Oracle VM VirtualBox
2020-12-15 17_00_15-WinDev2008Eval Corriendo - Oracle VM VirtualBox974×464 21.6 KB

I found the way to show the issues by component and the time spent in all columns but I am not able to show only the issues over the average.

2

Hi,

Try creating a new calcualted measure using this formula

CASE WHEN
[Measures].[System Lead Time]>=
(
  [Measures].[System Lead Time],
  [Issue].CurrentHierarchy.DefaultMember
)/
(
[Measures].[Issues created],
[Issue].CurrentHierarchy.DefaultMember
)
THEN
1
END

Then select this measure in your report.
Next, filter the report by this column > click and choose filter using “bigger than” filter (and type > 0)
Finally, it is safe to remove the last measure from the report columns.

Martins / eazyBI support