Forum Discussion
Teams Live Event Attendee Report - Track Attendee Duration
MSWilko see attached. The concept I used was the same but:
a) made the original data table formatted as a table to use table references
b) added a new Date Time column because the original one is text instead of a Date Value
c) used MAP and LAMBDA to automatically calculate the full array instead of fill down
hope this helps
- mtarler
Hi, thank you so much for the attachment!
Unfortunately when I make any changes to the 'original data' tab (like pasting the new information) the date-time column H formula breaks. I try and paste that formula in again though returning #VALUE.
I am not great with excel - hence me posting on here - did you have any suggestions on how I can repair?
Thank you!does it need consider sum each session_id duration๏ผ
if so,you may try this online sql tool.
http://e.anyoupin.cn/ceshi/jstest/pull_up_demo.php?s=attendee
create temp table aa as
select *,julianday(udf_my_date_format(UTC_Event_Timestamp)) time from track_attendee_duration_by_Participant_Id;
create temp table bb as
select Full_Name,Session_Id,sum(iif(Action like 'left',time,-1*time)*24*60) duration,Session_Id,group_concat(UTC_Event_Timestamp) session_duration from aa group by Full_Name,Session_Id;
select Full_Name,round(sum(duration)) duration,group_concat(session_duration,'<br>') from bb group by Full_Name;โ
- Hi, I appreciate the reply ๐ Unfortunately I do not know how I would input this in the doc..... Only have basic excel skills.
