One of my dashboard panel is not showing any results. But when I run the search manually it is giving results. Out of 8 panels only one panel is having the issue. I am not using base searches.
Ugly and stupid but I've seen this before and didn't find a nice answer. Try this...
'initial search spl'
| fields *
'remainder of search as written'
Found the issue. It was because I am not using null values before the transforming command
@vjsplunk- Glad you found solution to your problem. Please accept your own answer by clicking "Accept as Answer" so in future community users get benefited from this.
Community Moderator,
Vatsal Jagani
OK so there is probably something different about the search which is not working - perhaps if you shared that with us we might be able to spot something, but at the moment this knowledge is unavailable to us.
Yes. If I open the panel from "Open in Search" it is giving the results.
Hi @vjsplunk ,
are you using a post process search?
if yes, you have to declare all the fields that you use in the panels, using fields.
Ciao.
Giuseppe
I am using an xyseries command after the filtering commands it is not giving any results.
index="test" source="test2" "REPORT RequestId: "| eval Latency = rex(***)
|xyseries avg(Latency) as avg_Latency over _time by useragent
The xyseries command doesn't work like that
https://docs.splunk.com/Documentation/Splunk/latest/SearchReference/Xyseries
Try replacing it with the chart command
|chart avg(fusionapiLatency) as avg_fusionapiLatency over _time by useragent
Chart also not giving the results
Please share some sample anonymised events in a code block so we can see what you are dealing with?
Yes. If I open the panel from "Open in Search" it is giving the results.
@vjsplunk- If that is the case and you said you are not using base-searches then the only issue could be browser caching or cookie issue. Try incognito window.
@vjsplunk- Is your Panel and Direct search using the same time-range??
Also, what happens when you open the panel in "Open in Search" from the bottom right of the panel? Do you see the results or no?
I hope this helps!!! Kindly upvote if it does!!!