Background:
I created a dashboard to monitor ticket SLA times. The dashboard is slow because there are 18 single value panels and each panel has its own query. I'm looking for some way to optimize this dashboard to decrease the load time for the user and the server. I need to create similar dashboards for other departments, so I could have 8-10 of these in the end, which will increase the strain on the server. I also have a "manager" dashboard that contains the same information, but it's displayed in a table. I was able to populate the table with 1 query and a nested query, and the load time is dramatically better than the 18 individual panels.
My question:
The dashboard with the 18 panels has 18 queries that are almost identical, the only difference is the SLA time equation, which is how I was able to restructure the query in the manager dashboard. Is there some way I can run the query from the manager dashboard and display the results in the 18 panels? (I want to copy and paste the query, not reference one dashboard from another.) I've tried saving the results to tokens, using a searchTemplate and searchPostProcess, created a report and had the panels reference that report, and none of these ideas have worked. I also created a base search to have the panels reference, and while this works, it's not any faster than the separate queries. Any help is greatly appreciated. Thanks.
... View more