зеркало из https://github.com/mozilla/looker-poc.git
90 строки
1.9 KiB
Plaintext
90 строки
1.9 KiB
Plaintext
connection: "bigquery"
|
|
|
|
# include all the views
|
|
include: "/views/**/*.view"
|
|
|
|
datagroup: fenix_release_default_datagroup {
|
|
# sql_trigger: SELECT MAX(id) FROM etl_log;;
|
|
max_cache_age: "1 hour"
|
|
}
|
|
|
|
persist_with: fenix_release_default_datagroup
|
|
|
|
explore: user_activity {
|
|
|
|
}
|
|
|
|
explore: one_day_cls {
|
|
from: baseline_clients_last_seen_2
|
|
hidden: yes
|
|
sql_always_where: submission_date = DATE_SUB(current_date, INTERVAL 7 DAY) ;;
|
|
}
|
|
|
|
explore: metrics_v1_schema {
|
|
hidden: yes
|
|
sql_always_where: column_name = 'metrics' AND data_type = 'INT64' AND field_path NOT LIKE '%labeled%';;
|
|
}
|
|
|
|
explore: metrics {
|
|
always_filter: {
|
|
filters: [
|
|
submission_date: "1 year",
|
|
metric: "",
|
|
metrics.client_aggregation_type: "sum"
|
|
]
|
|
}
|
|
}
|
|
|
|
explore: derived_per_client_aggregate {
|
|
always_filter: {
|
|
filters: [
|
|
submission_date: "1 year",
|
|
metric: "",
|
|
client_aggregation_type: "sum",
|
|
daily_aggregation_type: "max"
|
|
]
|
|
}
|
|
}
|
|
|
|
# should use this next time: https://help.looker.com/hc/en-us/articles/360048648594-Filtering-a-View-Using-a-Field-from-Another-View-without-Joining-Views
|
|
explore: funnel_analysis {
|
|
from: events_daily
|
|
join: event_types {
|
|
view_label: "Funnel Event 1"
|
|
relationship: many_to_one
|
|
type: cross
|
|
}
|
|
join: event_2 {
|
|
view_label: "Funnel Event 2"
|
|
from: event_types
|
|
relationship: many_to_one
|
|
type: cross
|
|
}
|
|
join: event_3 {
|
|
view_label: "Funnel Event 3"
|
|
from: event_types
|
|
relationship: many_to_one
|
|
type: cross
|
|
}
|
|
join: event_4 {
|
|
view_label: "Funnel Event 4"
|
|
from: event_types
|
|
relationship: many_to_one
|
|
type: cross
|
|
}
|
|
always_filter: {
|
|
filters: [
|
|
submission_date: "1 year",
|
|
event_types.name: "events - app^_opened^_all^_startup",
|
|
event_2.name: "events - search^_bar^_tapped",
|
|
event_3.name: "events - search^_bar^_tapped",
|
|
event_4.name: "events - search^_bar^_tapped"
|
|
]
|
|
}
|
|
}
|
|
|
|
|
|
explore: growth_accounting {
|
|
|
|
}
|