Versions Compared

Old Version 20

changes.mady.by.user E. Lynette Rayle

Saved on

compared with

New Version Current

changes.mady.by.user Christina Cortland

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Updated link to Cornell's dashboard

...

Viewing the live Cornell site dashboard

  1. View Cornell's dashboard
  2. Select the desired date range in the top right (the default is the current month). The data will automatically refresh when a new date range is selected

...

Field to group pages by exhibits

Field NameExhibits
Formula

Uses regex to select out published exhibits

Example


Code Block
languagenone
CASE
WHEN (Page='/') THEN 'Home'
WHEN (REGEXP_MATCH(Page, '.*my-exhibit.*')) THEN 'My Exhibit'
WHEN (REGEXP_MATCH(Page, '.*my-other-exhibit.*')) THEN 'My Other Exhibit'
ELSE 'Unpublished'
END


Create withYou can use a utility script to generate this CASE statement. See DataStudio.published_exhibits_field. This uses Spotlight::Exhibit.where(published: true) to get the list of published exhibits to generate the case statement.


Field to group edit and admin pages

Field NameAdmin Pages
Formula

Uses regex to select out edit and admin pages

Example

NOTE: This is the code at the time this was written. It may have been adjusted if more patterns were identified to select admin pages.

Code Block
languagenone
CASE
WHEN (REGEXP_MATCH(Page, '.*dashboard.*')) THEN "Dashboard"
WHEN (REGEXP_MATCH(Page, '.*/edit')) THEN "Edit"
WHEN (REGEXP_MATCH(Page, '.*/edit#.*')) THEN "Edit Tab"
WHEN (REGEXP_MATCH(Page, '.*/edit/.*')) THEN "Edit Item"
WHEN (REGEXP_MATCH(Page, '.*/users')) THEN "Users"
WHEN (REGEXP_MATCH(Page, '.*/admin_users')) THEN "Admin Users"
WHEN (REGEXP_MATCH(Page, '.*custom_fields.*')) THEN "Custom Fields"
WHEN (REGEXP_MATCH(Page, '.*custom_search_fields.*')) THEN "Custom Search Fields"
WHEN (REGEXP_MATCH(Page, '.*catalog/admin.*')) THEN "Item Curation"
WHEN (REGEXP_MATCH(Page, '.*resources/new.*')) THEN "New Item Curation"
WHEN (REGEXP_MATCH(Page, '.*/new')) THEN "New Exhibit Curation"
WHEN (REGEXP_MATCH(Page, '.*tags')) THEN "Tag Curation"
WHEN (REGEXP_MATCH(Page, '.*searches')) THEN "Browse Curation"
WHEN (REGEXP_MATCH(Page, '.*feature')) THEN "Feature Curation"
WHEN (REGEXP_MATCH(Page, '.*feature#add-new')) THEN "Feature Curation (new)"
WHEN (REGEXP_MATCH(Page, '.*about')) THEN "About Curation"
WHEN (REGEXP_MATCH(Page, '.*about#add-new')) THEN "About Curation (new)"
ELSE "Public Pages"
END


Create withYou can use a utility script to generate this CASE statement. See DataStudio. admin_pages_field. This hardcodes the regex statements that group the various admin related pages.


Setting up Filters

Reference: Data Studio: Add Filters

...

Uses the Exhibits field to exclude unpublished exhibits.

Filter NamePublished Exhibits filter
Filter

Exclude Exhibits Equal to (=) Unpublished


Filter to exclude admin pages

Uses the Admin Pages field to exclude unpublished exhibits.

Filter NameExclude Admin Pages filter
Filter
Exclude    Admin Pages    In    Dashboard,Edit,Edit Tab,Edit Item,...

Note: List of page groups to exclude is truncated. See example.

Example

NOTE: This is the list of admin page groups at the time this was written. It may have been adjusted if more patterns were identified to select admin pages.

Code Block
languagenone
Dashboard,Edit,Edit Tab,Edit Item,Users,Admin Users,Custom Fields,Custom Search Fields,Item Curation,New Item Curation,New Exhibit Curation,Tag Curation,Browse Curation,Feature Curation,Feature Curation (new),About Curation,About Curation (new)


Create withYou can use a utility script to generate the list of admin page groups to exclude. See DataStudio. exclude_admin_pages_filter. This hardcodes the regex statements that group the various admin related pages.


Using Filters

Reference: Data Studio: Using Filters

...