About
samuel-vanhorne
Samuel Van Horne
Rank:
Community Novice
Title:
Joined:
Feb 29, 2016 8:33:05 AM
Posts:
11
Solutions:
0
Likes Received:
42
Bio:
An amazing Instructure Community member
Most Liked Posts
That's right--and if the table is sorted by course_id>user_id>timestamp>session_id then you just need to use the timestamps in the first and last row of each unique session_id (per student per course)...
Ryan,I think one way to do this is to determine the period in which you are counting the number of times a user has logged in to a course. That might be more difficult than it sounds. But it seems lik...
I think it depends on how Canvas Data can help you answer a question you have or augment some kind of early-warning system that you might be using. It's useful to have a guiding question so that we fo...
I was curious about my question so I went digging...Session_id is unique for each timestamp_day value in requests--it's the session for someone's daily activity across Canvas. Thus, you could have mul...
When will the 'TBD' values be corrected in the information about the pseudonym_dim table? https://portal.inshosteddata.com/docs#pseudonym_dim
Most Recent Posts
Hi Jeff,We are still new at this, but there has been some work with the Canvas LMS before that you can look up. I recommend looking up the work of people like Mimi Recker and Andrew Walker, who have s...
Hi Lance,I'm not aware of how to use the API--our database is hosted by Unizin in the Amazon cloud. I misunderstood what you meant by "outcomes". I thought you were talking about assignment outcomes, ...
Can you be more specific about the outcome you are looking for? We use Canvas Data to go in the opposite direction (that is, use assignment_dim to find the assignments and then submission_dim to find ...
Hello,I share your confusion, but Instructure (in the schema) says that the description of "last_request_at" is "TBD," so the schema is not of much help here. I do think that the value in "last_reques...
I was curious about my question so I went digging...Session_id is unique for each timestamp_day value in requests--it's the session for someone's daily activity across Canvas. Thus, you could have mul...
Latest Badges
![25 Likes Received](https://community.canvaslms.com/html/@6DE2C3C77ACCE0E39FC5727CD1DB6AC5/badge_icons/Likes_25.png)
25 Likes Received
2024-01-05
![First Like Received](https://community.canvaslms.com/html/@7FB95FB5E588420F399FCFC1A4B92BE5/badge_icons/Likes_1.png)
First Like Received
2024-01-05
![Instructure Community: 7 Year](https://community.canvaslms.com/html/@AA56E7E183D8448B2C7682CA7E2EC8E3/badge_icons/Anniv_7.png)
Instructure Community: 7 Year
7 Years with Instructure Community
2024-01-03
![Instructure Community: 6 Year](https://community.canvaslms.com/html/@8CB87B2A2E83F5FC46BD1026FF6F049C/badge_icons/Anniv_6.png)
Instructure Community: 6 Year
6 Years with Instructure Community
2024-01-03