Forum Discussion

rains_23's avatar
rains_23
Icon for Helper I rankHelper I
1 year ago

Attendance or count based on 2 fields

Hi, I have a table, as below and I need to count the employee attendance for the whole month. I want the answer as ABC =3, PQR=4, CDF=3. If I use the count of (Login date) in a matrix it gives corre...
rains_23's avatar
rains_23
Icon for Helper I rankHelper I
1 year ago

The total does not come correct for me ,

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi rains_23 

     

    There is too little information to see from this screenshot, could you please create a matrix visual showing us the problem you are experiencing using the sample data from the initial post?

    And describe all the relevant fields in the matrix and the measures that might be used.

     

    Best Regards,
    Jarvis Tang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • rains_23's avatar
      rains_23
      Icon for Helper I rankHelper I
      1 year ago

      Sorry, I was going to post the data I used. All are simple columns. Month is a colum duplicated from Login date. with month format. What it is doing is it is taking the total as 21 in above example, that is number of employees in the month of jan. and not no. of occurence. So If an employee is in month of jan 3 times, it is counting as 1 and not 3

       

       

      • rains_23's avatar
        rains_23
        Icon for Helper I rankHelper I
        1 year ago

        Card details - is employee name