Snowplow - Page Views Over Time visualization always shows no results
Problem to solve
The page_views_over_time.yaml
visualization always shows No results match your query or filter
even when page views events have been generated.
This can be demoed by checking out this branch and following the verification steps on Update individual dashboards to retrieve dashbo... (!121129 - merged).
Suspected cause
The issue seems to be that Cube cannot filter for the SnowplowTrackedEvents.event
value pageview
.
Suggested solution
Changing the value from pageview
to page_view
resolves the issue in the cube playground.
Implementation plan
backend
query:
measures:
- SnowplowTrackedEvents.pageViewsCount
timeDimensions:
- dimension: SnowplowTrackedEvents.derivedTstamp
granularity: day
filters:
- operator: equals
values:
- page_view
member: SnowplowTrackedEvents.event
limit: 100
timezone: UTC
dimensions: []
[] Confirmed the above with the backend team.