Hey Guys,
I want to find a system activity dataset that allows me to understand which of my dashboards are being used and which are now. I spent a lot of time going through the System Activity models but there doesnt seem to be a way to link user to dashboard name or to understand which are actual dashboard page visits. Maybe someone can help me? My ideal report would look like the below|:
Dimensions = username, usage type (e.g web visit or scheduled run), date, dashboard title
Measures = count dashboard runs's average duration on the dashbaord
Hello @shakermakerk,
Please, take a look on such analysis -
https://<your_looker_instance_url>/explore/system__activity/history?fields=user.name,dashboard.id,history.real_dash_id,dashboard.title,history.source,history.result_format,history.created_date,history.dashboard_run_count,history.average_runtime,history.approximate_usage_in_minutes&f[history.created_date]=7+days&sorts=history.created_date+desc&limit=500&column_limit=50&query_timezone=America%2FNew_York&vis=%7B%22show_view_names%22%3Afalse%2C%22show_row_numbers%22%3Atrue%2C%22transpose%22%3Afalse%2C%22truncate_text%22%3Atrue%2C%22hide_totals%22%3Afalse%2C%22hide_row_totals%22%3Afalse%2C%22size_to_fit%22%3Atrue%2C%22table_theme%22%3A%22white%22%2C%22limit_displayed_rows%22%3Afalse%2C%22enable_conditional_formatting%22%3Afalse%2C%22header_text_alignment%22%3A%22left%22%2C%22header_font_size%22%3A12%2C%22rows_font_size%22%3A12%2C%22conditional_formatting_include_totals%22%3Afalse%2C%22conditional_formatting_include_nulls%22%3Afalse%2C%22type%22%3A%22looker_grid%22%2C%22defaults_version%22%3A1%2C%22series_types%22%3A%7B%7D%7D&filter_config=%7B%22history.created_date%22%3A%5B%7B%22type%22%3A%22past%22%2C%22values%22%3A%5B%7B%22constant%22%3A%227%22%2C%22unit%22%3A%22day%22%7D%2C%7B%7D%5D%2C%22id%22%3A17%7D%5D%7D&dynamic_fields=%5B%5D&origin=share-expanded
if it would work for you. Default filter is last 7 days.