topic Re: Reporting in Splunk Search

Reporting

revanthammineni — Tue, 08 Dec 2020 08:01:24 GMT

Hi Splunkers!

Hope you guys are doing good.

I'm working on a usecase where I have to show daily chart of overall results of search. I'm attaching a screenshot below. I'm trying to show a daily count of the number in a line graph. For Example (see screenshot): I got 1350 dest statistics today and 1200 dest statistics yesteday. I want to show both on the line graph with dates.
by doing timechart count by dest is not giving accurate results.
Thanks in advance.

Re: Reporting

richgalloway — Tue, 08 Dec 2020 14:09:02 GMT

Please share your current query and explain why you think timechart is not accurate.

Re: Reporting

revanthammineni — Tue, 08 Dec 2020 16:19:14 GMT

So I have results that I get is 1300+ for a day. I want to report a daily chart of the statistcs.

I have included the screenshot where I tried timechart dest, But the result I'm seeing there would be spreading all the dest over the report and counting it. All I want is overall dest count for a day, So I can show the trend.

Thanks.

Re: Reporting

richgalloway — Tue, 08 Dec 2020 18:19:42 GMT

In general, if timechart gives unexpected results then you should blame your query rather than timechart.

For instance, it makes little sense to use dedup before timechart count because your counts will all be 1.