hi @vinidegrandi
you could use this as a base:
- Group your data by date and email
- Add a column to the hours work to the group
Like this:
data: colVini {activityType: , activityTime: , activityDate: , email:}
GroupBy(colVini, "activityDate", "email", "Per Day")
Then add a column. the four context variables correspond to your type
AddColumns(GroupBy(colVini, "activityDate", "email", "Per Day"), "Hours",
With(
{
ctxCheckIn: LookUp('Per Day', activityType = 1).activityTime,
ctxLunchOut: LookUp('Per Day', activityType = 2).activityTime,
ctxLunchIn: LookUp('Per Day', activityType = 3).activityTime,
ctxCheckOut: LookUp('Per Day', activityType = 4).activityTime
},
DateDiff(ctxCheckIn, ctxLunchOut, Hours) + DateDiff(ctxLunchIn, ctxCheckOut, Hours)
)
)
Result
Collection:
Gallery with Items = colVini
Let's group and add the columns as per the code above
So from data above
lets add another person (email)
