Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Row count per day per employee

Hi all,   I have the following issue:     For each date and employee I want a row count. (see picture) (Employee A has 2 rows on 1-1-2018 so I expect 2 as a result, etc) The column 'rowcount...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi, already solved with another solution. I made a 'group by' in my dataset.  Thnx for your help.  

petrovnikitamai's avatar
petrovnikitamai
Icon for Resolver V rankResolver V
7 years ago

if i understand u

try this

new column = countrows(filter(tableName;earlier([Date])=[Date]&&earlier([employee])=[employee]))
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi, already solved with another solution. I made a 'group by' in my dataset.  Thnx for your help.