6 Replies Latest reply: Nov 1, 2017 7:19 AM by Shashank Vyas RSS

    Remainder Function in set analysis with aggregation

    Shashank Vyas

      Hello All,

       

      I have to implement one expression where only those EMP should be counted who have completed all their assigned trainings, which means CompletedTopics/TotalTopics = 1 or TotalTopics-CompletedTopics = 0.

      Now, i will tkae Count of EMP according to the condition put up in set analysis.

      Also i want to aggregate the values with EMP as different Employees have different assigned number of Topics.

      Here, my Dimension is Team.

      So, the final count will represent the number of employees in that team who have completed all their asigned topics.

       

      Thanks in advance.