metabase / metabase/metabase

Offer a way to understand users' interactions with dashboards - filter usage

Open
#52,092 0 comments 3 reactions 0 assignees View on GitHub
Administration/Usage analytics Type:New Feature
Dominant language
Clojure
Stars
49.3k
Forks
6.8k
Avg merge
1d 13h
Merged PRs (30d)
653

Description

**Is your feature request related to a problem? Please describe.**

Currently the [Usage Analytics]() shows basic metrics like daily user access per dashboard and so on. Nothing around how users are using the dashboards, selecting filters, ...

It appears that the required data is stored within the "parameters" list in the 'query' column of the Usage Analytics's Query Log model, which is formatted as a JSON object.

![Image](https://uploads.linear.app/a24a1a82-ddc8-4567-aacc-c3804ea2385e/98a093e5-5a96-4656-8e4f-cdee2378bac5/8c6420b5-0e47-460a-9933-05668e385fe9?signature=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJwYXRoIjoiL2EyNGExYTgyLWRkYzgtNDU2Ny1hYWNjLWMzODA0ZWEyMzg1ZS85OGEwOTNlNS01YTk2LTQ2NTYtOGU0Zi1jZGVlMjM3OGJhYzUvOGM2NDIwYjUtMGU0Ny00NjBhLTk5MzMtMDU2NjhlMzg1ZmU5IiwiaWF0IjoxNzc4Nzg2MjUzLCJleHAiOjE4MTAzNTY4MTN9.Asq0T4Rq1NdwMzE698hfEpPjdCxO6KgWyzkai07OZ_w)

Currently there is a limitation with JSON functions for strings and a restriction on executing custom SQL against the Usage Analytics database. So you just cannot extract anything via the Usage Analytics on this matter even though the data is there!!

**Describe the solution you'd like**

Ability to show filter values customers use most frequently on specific dashboards via the Usage Analytics

**Describe alternatives you've considered**
Skip the Usage Analytics and query directly the Application Database. For Cloud Customers this is something they are not able to do

**Additional context**
Might be related to [https://github.com/metabase/metabase/issues/49461]()

Contributor guide

Open the contributing guide

Research direction

Start by reviewing the Usage Analytics documentation and related issue #49461, then trace the Usage Analytics Query Log model and its query column's parameters JSON. The work is done when Usage Analytics can report the filter values customers use most frequently for specific dashboards, including for Cloud customers without direct application-database access.

Written by the indexing model from the issue text.

Assessment

Tech stack
clojure
Domain
analytics, data, databases
Issue type
Feature
Difficulty
5/5
Estimated time
Over a week
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.