Forum Discussion
Summarize grouping by 2 columns
Hallo, I need to group the table 1) a column: grouped by date 2) second column: grouped by hours 3) 3d coumn: count distinct for each hour how many operators I have for each hour 4) 4 column: c...
Anonymous , Try like this
New column
Date =Table[INIZIO].date
hour =hour(Table[INIZIO])New Table
summarize(Table, Table[Date], Table[hour], "op nr", distinctcount(Table[MATRICOLA]), "contenitori",count(Table[CONTENITORE]))
amitchandak
Super User
Super UserAnonymous , Try like this
New column
Date =Table[INIZIO].date
hour =hour(Table[INIZIO])
New Table
summarize(Table, Table[Date], Table[hour], "op nr", distinctcount(Table[MATRICOLA]), "contenitori",count(Table[CONTENITORE]))