hey there
trying to add this query however there is some weirdness with processing special characters and the filters are not being set. Shared below
- view: ios_shop_usage
derived_table:
sql: |
SELECT
event_type
FROM ios_event_properties
WHERE event_type = ‘module:tappped’
fields:
- dimension: session_id
type: number
specifically adding “:” character seems to make the query not run