Dynamic aggregation in dashboard

Feedback and Requests
1

Hi,

Currently in dashboard, we are able to add filters, that allow to customize the where-clause in a query like "SELECT FROM

WHERE GROUP BY ". I would like to have a similar widget, that would allow to customize the GROUP BY clause.

Here's a mockup of what we would like :

custom_aggregation
custom_aggregation1781×467 29.6 KB

On the top-left, we have some filters, that we can already add in the dashboards. And on the top-right, we have some widgets that would allow to customize the grouping of the results, which currently doesn't exist in Metabase.

Is there any plan to add such a feature ?

1 Like
2

We have something in our plans for changing the time granularity in dashboards only, is that what you’re looking for?

3

Hi,
Not exactly. It's not only about time, it can be any field.
For example, imagine that I have a query in my dashboard, corresponding to "SELECT FROM WHERE GROUP BY .
What I would like is a widget that, when I click on it, changes the field in the GROUP BY of my query (similarly to what we can do with filters in order to change the condition in the WHERE-clause of the query).