I have this table with only start time of every task. What I want to do is to calculate for every user his starting time (doesn't matter what task) and end time (doesn't matter what task). Basically I want working hours for each day for each each user.
I tried to do this:
enter work = MINX(
SUMMARIZE(events,events[Date Only].[Date],events[user_id],
"MINN",MIN(events[ConvertedTimeToInteger])
),
[minn]
)
exit work = MAXX(
SUMMARIZE(events,events[Date Only].[Date],events[user_id],
"MAXX",MAX(events[ConvertedTimeToInteger])
),
[MAXX]
)
It works for a daily calculation, but for a total calculation its not good as it takes min/max of the date period:
Any help much appreciated
与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…