"Hello, (sorry for my english which is not very good)
I would like to know how to add the time spent on each site per day. I record my times on a googlsheet using a mobile application (Tasker).
My data is saved like this:
-Site A: โโtimestartโโ โ> โโTimestopโโ ----> โโTotal durationโโ
-Site B: โโtimestartโโ โ> โโTimestopโโ ----> โโTotal durationโโ
-Site A: โโtimestartโโ โ> โโTimestopโโ ----> โTotal durationโ
-Site B: โโtimestartโโ โ> โโTimestopโโ ----> โTotal durationโ
I would like to know how to have a duration of site A and a duration of site B."
Thanks
@Anthony21
You can create a Virtual Column with an expression like this:
SUM(
SELECT(
TableName[Total Duration],
[SiteName] = [_Thisrow].[SiteName] // Change the column name for [SiteName] as per your schema
)
)
@LeventK
Awesome !!
Thank you very much for your help, this is exactly what I was looking for
Youโre welcome
@LeventK
Sorry but I still have a problem that I cannot solve.
If I use my example
-Site A: โโ timestart โโ -> โโ Timestop โโ ----> โโ Total duration โโ
-Site B: โโ timestart โโ -> โโ Timestop โโ ----> โโ Total duration โโ
-Site A: โโ timestart โโ -> โโ Timestop โโ ----> โTotal durationโ
-Site B: โโ timestart โโ -> โโ Timestop โโ ----> โTotal durationโ
In my application after using the expression it looks like this:
Site A
Day 1: Total duration
Day 2: Total duration
Site B
Day 1: Total duration
Day 2: Total duration
But I would like it to appear like this:
Site A: Total duration
Site B: Total duration
Thanks
User | Count |
---|---|
43 | |
28 | |
24 | |
24 | |
13 |