Creating a Query Function on a Dashboard
Is there a way to create a query that can be accessed via a dashboard to return data from a set of sheets? Here is my use case:
Sheet 1 includes customer profile and demographic data
Sheet 2 includes customer call history (date, topics discussed, etc.)
An Executive Level Dashboard includes reports that pull from the two sheets.
We want to be able to query by customer name and selected fields drawing from the two sheets. For example: Is the customer under contract, where are they located, contact info, and what is the call history.
I know I can set up a report and filter on the customer name. I'm looking for a simpler approach for the user to just plug in the name and fields of interest to see the data they're looking for.