Offer a way to understand users' interactions with dashboards - filter usage
- 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.

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
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