Looker Google Sheet View
view: monthly_unique_visitors_test { | |
sql_table_name: google_sheets.monthly_unique_visitors_test ;; | |
dimension_group: visit { | |
type: time | |
timeframes: [ | |
month | |
] | |
sql: CAST(PARSE_DATE("%e-%b-%y", ${TABLE}.month) AS TIMESTAMP) ;; | |
} | |
measure: unique_visitors { | |
type: max | |
sql: CAST(REPLACE(${TABLE}.users, ",", "") AS INT64) ;; | |
value_format_name: decimal_0 | |
} | |
} |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment