Hi!
I would like to anyone has scheduled an excel report based on an existing dashboard?
I have create a dashboard that contains only one drop down in which the user will choose a single loca...
See more...
Hi!
I would like to anyone has scheduled an excel report based on an existing dashboard?
I have create a dashboard that contains only one drop down in which the user will choose a single location. Then the dashboard displays the counts based on that location.
Now I'd like to know if there's an easy way to have all that data (per location), and add them in one single Excel file. For example
The dashboard looks like this:
Location dropdown: All, Avenue1, Avenue2, Avenue3.... Displaying: Panel 1 Panel 2 Panel 3
Each panel is coming from 4 saved searches for that particular location, and it returns the numbers for WTD, MTD, QTD and YTD then appending the numbers to create the columns. I'd like to know if I can create an Excel file from this Dashboard that can be scheduled to run daily. In other words, for each location: All locations, Avenue1, Avenue2, and so on, it can be written into one single Excel (if that cannot be done, at least get each location per Excel file). In that case, I'd have to create 7 Excel files (1 file per location) that will contain the different panels per location.
What I was envisioning it follow but I don't know if it's possible.
If anyone knows how I can approach this problem, it would be great or if they have a suggestion, a workaround, would be great too. Thank you so much in advance.
Dyana