[ARCHIVED] Which table(s) are 'pages views' stored in?

[p_dyson]

Dear Colleagues,

Please bear with me as I'm new to the community.

Having looked through the Canvas Data Portal Schema doc, I'm still unsure as to where 'page views' sit or how they are arrived at. Are they an aggregation of different attributes from different tables?
Notwithstanding the disclaimer that's included in the 'requests' section of the schema documentation, I would be really grateful if someone in the community could steer me in the right direction.

Many thanks,

Paul.

[Jeff_F]

Hello  @p_dyson ‌ -  I looked into this and there is a view_count field within the wiki_page_fact.  This may be a good starting point if you are using Tableau - 

I used this and was able to then add a column to the worksheet for the view count.  And to be fancy I added a few date columns from the wiki_page_dim and also placed a calculated field comparing the dates to ascertain if a specific wiki page had been updated since it was created with the course.

Is this useful?

[p_dyson]

Hi Jeff

Many thanks for taking the time to look at this, it's greatly appreciated.

Kind regards

Paul.

[awilliams]

Hi! We have two CanvasLIVE sessions coming up on Canvas Data you might want to RSVP to or follow for more information. If you have any questions about the events, feel free to post them in the comments section at the links below so the host has the opportunity to respond. Hope to see you there!

Oct. 5  9:30am MDT / 11:30am EDT

Learning Analytics and Canvas Data

Oct. 10 12pm MDT / 2pm EDT

Accessing Your Canvas Data with CanvasDataViewer: Encore!