Dynamic dashboards - repeat charts

Hi there,

I want to be able to create dashboard that will be populated with same chart based on the available filter.
So my chart will be duplicated as many times as we have a value to duplicate it with.

Let's say I have next columns:

| amount | type | city | date |
| 10 | sale | london | 2021-01-01 |
| 1 | refund | london | 2021-01-01 |
| 10 | sale | nyc | 2021-01-01 |
| 1 | refund | nyc | 2021-01-01 |

and I filter (or any new term) by city - I will end up with two graphs on my dashboard.

Here is an example how it's done in grafana - https://grafana.com/blog/2020/06/09/learn-grafana-how-to-automatically-repeat-rows-and-panels-in-dynamic-dashboards/

Hi @alekseyp
That's not possible to do in Metabase, and would require a big rewrite of how dashboards and cards functions.
But isn't it similar to Pivot Table where it would group data depending on what you return?

1 Like

I would like to be able to see graphs - it's hard or/and actually close to impossible to spot any anomalies when you have 100 "things" to check. My example is very simple, data I work with is way more complicated than that.

By allowing same graph (let's say it's per minute/hour) duplicated/repeated for each source, you can see how they all perform over same period of time.

I really went and created 100 questions just to accomplish one "question" :crazy_face:

I do believe it's a pretty good idea and I would even say necessary feature IF Metabase wants to improve on dashboard functionality. I think it can be a game changer for a lot of folks :slight_smile:

@alekseyp Well, each tool has it's merits and it's strengths. I don't know how Grafana handles this, or how Metabase should dynamically create cards on the dashboard.
But it sounds like you're looking for this:
https://github.com/metabase/metabase/issues/3575 - upvote by clicking :+1: on the first post

I've spent good hour reading all open and closed issues trying to find something similar and was not able to find that one. Thanks!

Basically I see it as group by filter to duplicate cards, let's say we have a question with group by a and on dashboard we set a setting for that card to duplicate itself for each a from that query.

@alekseyp I can understand that from the Grafana page, but I don't see how to implement it in Metabase without a completely rewrite of how dashboards works currently. And it would need to be dynamic, so if A was returning 3 distinct groups, when you created 3 cards on the dashboard, what should happen, when it returns 2 or 5 distinct groups?

You might be interested in these issues too - upvote by clicking :+1: on the first post of each issue:

Thanks for extra issues, I've also found one that pretty much describes my pain point:

And it would need to be dynamic, so if A was returning 3 distinct groups, when you created 3 cards on the dashboard, what should happen, when it returns 2 or 5 distinct groups?

So the idea is to create just one card, that will just clone itself after original one and fill the space. probably pushing other down...I do understand that cards are assigned to dashboard spaces right now, so maybe we can add new type, let's call it "block/row", that will fill that dynamic card, so when it's adding new card it will just expand that row and push anything bellow it even further.

Also, after typing all that - I thought of an idea - what if we just create new type of dashboard or even question that can do that dynamic graphs? So we'll still get one page with many graphs that can be readable.

and... if we do it on card level, we can just make it scrollable like it's right now with tables.