Forum Discussion

Noredlac86's avatar
Noredlac86
Helper I
3 years ago
Solved

Count repeated values with a condition

Hi Everyone.
I waswondering if someone one can help me with this doubt.

 

I have a table with the name of the employees, and the column, Employe of the month = Yes/No.

 

I need to count, how many times of the year, the user was employee of the month.

 

For example:

 

ID    NAME     EMPLOYEEOFMONTH?     HOW MANY TIMES?

5    Jhon                  Yes                                        2

5     jhon                  No                                        2
6    Ana                    No                                       0
7    Marc                  Yes                                       3
5   Jhon                    Yes                                      2
7  Marc                     Yes                                      3
7 Marc                     Yes                                      3


The idea is to create the column "How many times?

iwas wondering if someone can help me

 

Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    3 years ago

    Noredlac86 Maybe:

    How many times column =
  VAR __id = [ID]
  VAR __table = FILTER(ALL('Table'), [ID] = __id && [EMPLOYEEOFMONTH?] = "Yes")
RETURN
  COUNTROWS(__table)

3 Replies