Is there a way we can add a switch to dashboard that can change what dimension is being summarized?

Carlin · June 13, 2024, 9:08pm

For example, I have a chart that has the count of customers, summarized by their plan_level (basic, pro, or advanced).
I would like the user to be able to select from a dropdown that allows them to pick from plan_level, plan_length, country, age_category etc.
If they pick plan_length, the chart will change to show plan_length (monthly or yearly)

I have looked at adding a parameter via SQL but it only seems to work as a filter within a dimension, not as a way to change your dimension.

so, instead of this (the example in the parameter help page):
select count() from people where state = {{State}}
It would be more like this:
select {{state}}, count() from people group by {{state}} --- and i could change state to source with dropdown

leeloo · June 13, 2024, 9:46pm

This sounds similar to this feature request. If that sounds right please feel free to upvote it and add any context you feel would be valuable!

github.com/metabase/metabase

Proposal: "Group by" for dashboard cards

opened 12:57PM - 16 Jun 17 UTC

edklimov

Reporting/Dashboards Type:New Feature

Hello, First of all thank you for building such a great product! In my opini…on it will be a great thing to support “group by” operations for predefined hierarchies in dashboard cards. I have no idea how painful it is from technical perspective, but to my mind it will certainly have some benefits when single predefined grouping is not enough to explore data: 1. User don’t have to make a transition from dashboard’s view to question’s view and loose sight of other dashboard’s data. 2. There will be no need to place charts with the same series but with different groupings near each other on the same dashboard - it will save much of dashboard’s space. 3. Sometimes it is very useful to encapsulate query building process from users and provide just dashboard interface for interaction. Just a quick sketch for you to better understand what I mean: ![img6](https://user-images.githubusercontent.com/15221186/27227339-c80693de-52ab-11e7-8414-04cdfdf4a082.png) I suppose this feature will require a lot of extensive work, so maybe you’ll consider more simple option - to create some kind of “overlay” mechanism for dashboard cards and enable its configuration in dashboard edit mode. In theory, this overlay mechanism can allow to compose multiple dashboard cards in one and show desired card using some controls (in my example it is bottom button panel). Overlaid cards can be downloaded lazily. This kind of flexibility will allow to compose collections of dashboard cards in a various and very comfortable for end-user ways (even with semantic grouping). I’ll very appreciate any feedback on this. Thank you in advance. ⬇️ Please click the 👍 reaction instead of leaving a `+1` or 👍 comment

Parameterized date granularity is on the roadmap, though, and is expected in one of the next few major releases: Metabase Product Roadmap

s1g9 · February 12, 2025, 10:56am

Hey Carlin,
Yes you can do it by using a case when statement.

Check the syntax below.

select case when {{dropdown}}='plan_level' then plan_level
when {{dropdown}}='plan_length' then plan_length
else null end as dropdown_selected
, count(* ) from people
group by dropdown_selected

Hope it is helpful.

imtiazu · February 12, 2025, 1:14pm

I requested a feature a while called "Alternate Dimensions" which is what Qlik does. Meaning you could just swap out a dimension on a chart interactively .