Skip to Content
avatar image
Former Member

Calculate count of zero (key figures)

Hi Friends,

The output of the query is as follows:



Sub group


No. of incidents

Processing time

Characteristics are placed in row and keyfigures in column. There is an additional characteristice "team" which is not displayed in the report.

Now i wish to count the number of incidents for which the processing time is zero and also with the restriction of team A and team B.

I am able to count the number incidents with processing time zero. But able to restrict this to particular team.



Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Jul 10, 2009 at 08:53 AM

    Have you set the exception aggregation for Team?

    - Danny

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      What I meant to ask is, time is recorded by name level right?

      If one team can have 5 different names and out of those 5 names, 3 of them have time as ZERO and 2 of them dont have time ZERO. When you set the exceptiona aggregation, you will get 3 because calcualtion is done at name level, but you can not perform the exception aggregation at team level because that will be performed on the summation of all the times from all 5 persons of that team, which will not be ZERO.

      My same question was, if you have 3 teams under sub group, how do you want to see the number in the report.

      Row1 Row2 Row3 Col1 Col2

      Grp Sub Grp Team1 x x

      ____________Team2 x x

      This is not possible without having team in the report. Either you sum them up, but the team level calcualtion it self is wrong, so it really doesnt matter if you add them up at sub group level or not.

      - Danny