About
apritchett
Rank:
Community Participant
Title:
Joined:
Feb 3, 2017 9:27:58 AM
Posts:
7
Solutions:
2
Likes Received:
13
Bio:
An amazing Instructure Community member
Most Liked Posts
I have a question about the submission_dim and determining the difference between the submitted_at and created_at fields. The submitted_at field matches the time stamp in Canvas that the submission w...
You may already have your answer but I was curious so I went in and started digging around. To answer your question no, if you connect to the ASSIGNMENT_FACT you will not be able to display the multi...
Thanks to @brenden_goetz and @James for the great responses. One of the things I am looking for is for students who call into our Tech Support saying they submitted their paper but it isn't showi...
Greetings Jeffrey, I think I understand what your trying to do so hopefully my answer helps you. First, I would start with the [quiz_fact] and join [quiz_fact].[Quiz Id] to [quiz_dim].[Id] and then [q...
Does CD2 refresh at certain times during the day? I want to set up a scheduler to pull the latest incremental refresh and load it into our database.
Most Recent Posts
Does CD2 refresh at certain times during the day? I want to set up a scheduler to pull the latest incremental refresh and load it into our database.
I have worked with Canvas and Tableau and I discovered the issue was with Tableau and the way it reads flat files. For what ever reason Tableau will sometimes have errors reading large flat files. W...
I noticed this morning that we have a lot of missing data in some of our tables. I first discovered it in the course_dim and in the course_section_dim. This causes a problem for us since we run regu...
Greetings Jeffrey, I think I understand what your trying to do so hopefully my answer helps you. First, I would start with the [quiz_fact] and join [quiz_fact].[Quiz Id] to [quiz_dim].[Id] and then [q...
You may already have your answer but I was curious so I went in and started digging around. To answer your question no, if you connect to the ASSIGNMENT_FACT you will not be able to display the multi...
Latest Badges
![25 Logins Completed](https://community.canvaslms.com/html/@3E68C0E5C6557D84E11D9B5EF042F9AC/badge_icons/LogIns_25.png)
25 Logins Completed
2024-01-25
![15 Logins Completed](https://community.canvaslms.com/html/@2E8E8D3BD2530D8D339C74E72D043C6B/badge_icons/LogIns_15.png)
15 Logins Completed
2024-01-25
![10 Logins Completed](https://community.canvaslms.com/html/@E595FA76E29AD7C0DA86EE7C4B4A8223/badge_icons/LogIns_10.png)
10 Logins Completed
2024-01-25
![5 Logins Completed](https://community.canvaslms.com/html/@AF00A32A7DFF4D7EE8D64580F05253BE/badge_icons/LogIns_5.png)
5 Logins Completed
2024-01-25