Skip to content

Instantly share code, notes, and snippets.

@mattm
Created December 5, 2017 15:20
Embed
What would you like to do?
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