Thank you for bringing your family to game night  @mjennings ‌. Watching your boys play and enjoy the game was a highlight for me as well.

Patrick,How would you like to use this data.   We are considering exporting a few rollups that will be easier to deal with.   We would love to hear from you and others on what kind of rollups make sen...

sorry, there is a typo in that, the predicate should be: (workflow_state='completed') or (workflow_state='available')

the predicate would be (workflow_state='completed') or (workflow_state='available)We will update the docs and I think we might as an is_published field so this is easier to figure out.

"Time on page" is a common request, but unfortunately something that did not make the cut for v1.   You could approximate this by grouping events by user analyzing the time periods between the request...

Thank you for bringing your family to game night  @mjennings ‌. Watching your boys play and enjoy the game was a highlight for me as well.

Here is a more generalized query that also gets the other counts on the Canvas Analytics page.  This query is meant mostly to be instructive and is not necessarily a best practice.  It would probably ...

Meghan, this works great unless there are cross-listed courses in play.   I just posted a query on the thread Matt asked this question that takes cross listing into account: Re: Redshift vs. Canvas An...

Ok, I think I finally have an answer for this.  Sorry to take so long.The issue is with cross listed courses.  The Canvas Analytics page for a subaccount rolls the stats for all the courses in a sub a...

lkushma​ the work is not planned currently, but it is one of the most requested features that did not make the cut, so I would guess sometime soon after v1 releases in the fall.   Sorry I can't give a...