Hi:
I am quite new to Dashboards and was wondering if anyone could please help.
I am trying to build a dashboard that presents details on “Stores.” I have a combo box selector linked to the Store name. From here I have six queries and six components that I want to show all of the data. Each query has Store Name in common, i.e.: Store-Revenue, Store-Margin, Store-Hours Per Week etc. Each component I want to display these individual measures. I know how to set it up for one chart, but how do I set it up so that the one combo box selects a store and in turn changes all of the charts to show the relevant details, Revenue, Margin, etc. I understand that there is a way to do this with a prompt for the Store Name? Is this the case and if so can someone please explain? I am very new to Dashboards.
Thank you
Why do you have 6 queries? Why don’t you have only 1 query and use “Filtered rows” option on that combo box or selector and display data per store that way?
Hi and thank you for your response. I think one query will maybe not work for this as I am not only pulling measure data for each store. I also need to pull in top five customers by revenue and revenue by month. At least I think this complicates matters?
Is there a way to do it via prompts for Store name? or is there a way to manage with filtered rows and the complex query?
Thank you again - your help is highly appreciated.
thank you Debbie it is very helpful! I will go with this however if anyone does know about an alternate way via prompts please let me know as this is what I was initially instructed to do and at this point - I am just curious on the alternative method.
A prompt for the user to type something? That would introduce errors if the user mis-typed, or the store didn’t exist. Surely better to display a list of actual stores and allow the user to select one as in my example?
If you really want a prompt, you’ll have to have a data connection that takes the value entered and passes it back to the database as a variable. Then you’d need some kind of error-trapping to return a message/zero results for an invalid store name.
Just FYI, what you are asking for is one of those things that separate serious dashboard developers from dabblers. There is no easy solution. There are over a dozen different hard solutions, each of which has its own pros and cons. Picking the right one for your scenario is as much art as science.
I’m not trying to dissuade you from asking the question. Just letting you know that you are venturing beyond the point where a simple forum post is likely to be able to help.
Thanks again. I have tried this using Excel vlookup, (and index and match for another requirement to rank other data). Requirements for this have just changed and now I am asked to double the number of queries coming into the dashboard. It is falling over with too much excel logic to process, so this is sadly not an option. It does not seem like it should be so complicated to do this without too much fiddling in Excel :?
(BOB member since 2005-03-01)