• Assignment Statistics

    How do I find statistics for an assignment or quiz in the new gradebook? I'd like to see the class average on a test. 
  • Removing html tags from CanvasData files

    does anyone knows how to clean all html tags from CanvasData files?   We are having issues uploading CanvasData files to our DWH, fields like description, body, message are have a lot of characters, in several c...
    David Daza
    last modified by David Daza
  • can all reports be downloaded in one file such as in a mdb file?

    can all reports be downloaded in one file such as in a mdb file?
  • how could I identified survey answers in CanvasData?

    Does anyone know howto identify each answer submitted per student in a survey, using CanvasData? I feel a little lost in here, I'm able to identify the course, the survey, the pool of questions of the survey, but I'm ...
    David Daza
    last modified by David Daza
  • Login count - Requests

    Hi!! I need information and tips on how you perform the login count by 'user_id' and 'timestamp' using the Canvas Data requests files   Tks
    graziela.moura
    last modified by graziela.moura
  • Is there a mock data set we can use for developing?

    Hello,   I was wondering if there is some mock data available for a fresh canvas installation. I am developing an app that will use the canvas environment of my school, but for testing we use a standalone canva...
    Kona Jones
    created by Kona Jones
  • Submission comments on specific items

    In speedgrader you can comment on particular items in a quiz, for instance. Are those retrievable in canvas data or through api?
    Stefanie Sanders
    created by Stefanie Sanders
  • Item analysis results unreadable/unusable

    The item analysis results I get are unreadable/unusable. Some examples:   In all of these cases I created the questions and answers entirely in Canvas and they show up correctly when students take the qu...
  • How to retrieve all questions from a quiz

    Hi,   I have a problem when I'm retrieving data from a quiz.   current situation: - Question Bank has 10 question groups, and each has five questions. - The quiz has 10 question groups and each grou...
    Stefanie Sanders
    created by Stefanie Sanders
  • Submission Date/Time for External Content - Part II

    Part I of my question can be found here. As Robert Carroll suggested, I reached out to Canvas Data Help to find out why we had blank submission dates in our Canvas Data for every external tool except Webassign and SCO...
    Tess Bond
    created by Tess Bond
  • Submission Date/Time for External Content?

    Where would I locate the submission date and time for assignments that are set up as external content, such as assignments that are set up at a publisher site like Pearson or Hawkes? I know there is a gradebook column...
    Tess Bond
    last modified by Tess Bond
  • Scores on an assignment across different sections and quarters

    I'm new to Canvas Data and just took my first SQL course on Lynda.com. I'm currently trying to determine which tables to join to create meaningful reports.   We have a course that's taught in different sections ...
    Glenn Saito
    last modified by Glenn Saito
  • New Learning Outcome Tables

    Has anyone made sense of the new learning outcome tables in Canvas Data?   Release Notes: Canvas Data    I am hoping for a demo or use case profile of how these can be used. 
    fernerj@erau.edu
    last modified by fernerj@erau.edu
  • Users Pageview Interaction_seconds and canvas data

    Looking in the Users API documentation, under the section that describes a PageView object, there is a field titled "interaction_seconds" // An approximation of how long the user spent on the page, in seconds https:...
    Glen Parker
    last modified by Glen Parker
  • Account-level usage statistics (clicks) on external tools

    Is there a way to get usage statistics (number of clicks) on an external tool/app/LTI at the account/sub-account level? I've seen ways to report on navigation menu activity at the course level, but have not figured ou...
    Stefanie Sanders
    created by Stefanie Sanders
  • Analytics

    Is there a way to manually update the analytics instead of having to wait for the system to update once a day?
    Stefanie Sanders
    created by Stefanie Sanders
  • Anyone experienced Canvas data files in multiple table format?

    Hi,   When creating some BI reports yesterday, I imported an unpacked discussion_topic_dim file from the Canvas Data portal using the Canvas CLI tool and it appeared that the format of the file had changed. The ...
    Maeve McCooey
    last modified by Maeve McCooey
  • Joining Canvas Fact and Dimension Files

    New canvas user here with limited experience working with star schema data.  I am having trouble figuring out which fact and dimension files I need to build a simple table.  The table I want would look like ...
    Kona Jones
    created by Kona Jones
  • Canvas Data API url 403 & 400

    Canvas Data API sometimes gives 403 Timeout and 400 Not found when I access URLs to download files.  u rl header: https://hosted-data-work.s3.amazonaws.com/............../account_dim_00000-xxxx.gz   ...
  • Changes to requests and possible impact

    Hi    Our IT team are looking to improve the efficiency of how data from Canvas is imported into our data warehouse. The problem table is, unsurprisingly, requests and it is likely that a number of fileds w...
    Stefanie Sanders
    created by Stefanie Sanders