1 Reply Latest reply: Nov 6, 2017 9:30 AM by Marcus Sommer RSS

    count going wrong

    Pavan reddy

      Hi,

      i have data like this

       

       

      Capture11.PNG

       

      i am taking pie chart

      QualificationCatagery as Dimension

      and expression like this

      =count(If(Aggr(NODISTINCT  Max(QualToDate), EmployeeNo) = QualToDate, EmployeeNo))

      result is coming like this

       

      Capture1.PNG

      this values are correct ...

      when i select anything like one "Bachelor"

      count is coming like this

       

       

      Capt1ure.PNG

      please help me.

        • Re: count going wrong
          Marcus Sommer

          I think the reason for this behaviour is your max. calculation as condition which also reacts on your selection. Maybe an extention of it with a set analysis to ignore the selections may help, like:

           

          =count(If(Aggr(NODISTINCT  Max({< QualificationCategory = }> QualToDate), EmployeeNo) = QualToDate, EmployeeNo))

           

          - Marcus