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...
Likes: 5
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...
Likes: 3
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...
Likes: 1
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...
Likes: 1
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. 
Likes: 0

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. 
Dec 8, 2023 7:38:44 AM
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...
Aug 25, 2018 11:46:16 AM
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...
Mar 20, 2018 10:25:48 AM
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...
Jun 16, 2017 2:40:39 PM
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...
Apr 18, 2017 8:56:00 AM

Latest Badges

3 Solutions Provided

3 Solutions Provided

Earned: 2024-08-23

First Solution Provided

First Solution Provided

Earned: 2024-08-23

Instructure Community: 7 Year

Instructure Community: 7 Year

7 Years with Instructure Community

Earned: 2024-08-23

25 Logins Completed

25 Logins Completed

Earned: 2024-01-25