Single question & multiple view

Get Help
1

I need to create 2 reports which use the same query which is too long and complex.

  • Top 10 Best seller
  • Pie chart for Best seller

I want to use the same query for for both reports otherwise maintaining both reports will be difficult in case of change.

One option is to create View in database and use view instead of raw query.

Is there any other option available in Metabase to handle this?

2

Hi @manish.joisar
Depending on the database type and how advanced the query is, you can use Saved Questions as the base for the Pie and Table questions: https://www.metabase.com/docs/latest/users-guide/custom-questions.html#picking-your-starting-data

1 Like