5 Replies Latest reply: Jun 16, 2016 5:20 AM by Onno van Knotsenburg RSS

    How to calculate the average?

    Saumya Ray

      On Day 1, I have 10 employees entering a facility with unique cards. On Day 2, another 16 employees enter the facility. I need to calculate the average presence in the facility in QlikSense. Even though they might swipe the cards more than 1 time, but my answer should be distinct. For this I have used the below expression.

       

      (Count(distinct [Card Number]))

       

      However, I am not able to find the average of the card numbers. In case I choose Day 1, I should get the answer as 10 and if i choose Day 1 & Day 2 in the chart, I should get the answer as (10+16)/2.

       

      Please help.