Same Question in various Dashboard

1

My friends:

Can I visualize which Dashboards are using the same question (query)?

Thanks

Jose Carllinni

2

@Turco01 you should be able to use Usage Analytics, specifically Viewing usage insights for a question, dashboard, or model

3

Hello @Turco01,

If you're self-hosting the open-source version of Metabase, and don't have access to the Usage Analytics, you can query your Metabase DB itself using the SQL below to get it:

select distinct 
     t1.dashboard_id
    ,t3.archived as dashboard_archived_flag
    ,t3.name as dashboard_name
    ,t1.card_id as question_id
    ,t4.archived as question_archived_flag
    ,t4.name as question_name
    ,t1.dashboard_tab_id
    ,t2.name as dashboard_tab_name
    ,t1.created_at as dashboard_question_bind_created_at
    ,t1.updated_at as dashboard_question_bind_updated_at    
from report_dashboardcard t1
    
    left join dashboard_tab t2
        on t1.dashboard_tab_id = t2.id
    
    left join report_dashboard t3
        on t1.dashboard_id = t3.id
    
    left join report_card t4
        on t1.card_id = t4.id

order by t1.dashboard_id, t1.card_id

I hope this is useful! :slight_smile: