"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 |
---|---|
44 | |
29 | |
22 | |
20 | |
14 |