topic Re: In Dashboard Studio using count of results in a different section in Dashboards & Visualizations

In Dashboard Studio using count of results in a different section

jwhughes58 — Thu, 05 Sep 2024 17:05:06 GMT

I'm working with Dashboard Studio for the first time and I've got a question.

Originally I created a table search that returns data depending on what is in the $servers_entered$ field. That works. I have been asked to add two single value fields. The first is showing the number of servers in the $servers_entered$ field and that works. The second is showing the number of servers in the table search. There should be a way of linking that information, but I can't figure out how. I could run the search again, but that is rather inefficient.

How do you tie the search result count from a table search to a single value field?

TIA,

Joe

Re: In Dashboard Studio using count of results in a different section

ITWhisperer — Thu, 05 Sep 2024 18:43:53 GMT

You can make the meta-data from the data source visible, then set up another search to use the meta-data tokens, such as resultCount for the search for the single value.

"ds_tOBtSQ7e": { "type": "ds.search", "options": { "query": "index=_internal\n| stats count by sourcetype", "enableSmartSources": true, "queryParameters": { "earliest": "-24h@h", "latest": "now" } }, "name": "Search_1" }, "ds_aRrJ4C9T": { "type": "ds.search", "options": { "query": "| makeresults\n| fields - _time\n| eval count=$Search_1:job.resultCount$", "queryParameters": { "earliest": "-24h@h", "latest": "now" } }, "name": "Search_3" }

Re: In Dashboard Studio using count of results in a different section

jwhughes58 — Thu, 05 Sep 2024 18:52:45 GMT

Thanks @ITWhisperer . That is the solution.