topic Why does appendcols only show a fraction of overall search? in Splunk Search

Why does appendcols only show a fraction of overall search?

sbentley_ea — Thu, 14 Nov 2019 17:53:47 GMT

index=* App=appA OR appB OR appC | 
stats sum(Rate) as appSumRate by _time, App | 
appendcols [ search  index=* App=appD | 
stats sum(Rate) as appDsumRate by _time, App ]

When I try the above search I only get a fraction of the subsearch results, no matter what timerange.

When I do the appendcols subsearch by itself, it gets the full timerange.
What can I do to increase the range?

Re: Why does appendcols only show a fraction of overall search?

woodcock — Fri, 15 Nov 2019 00:39:53 GMT

It is best not to use it. Try this:

(index=* App IN("appA", "appB", "appC", "apD")
| eval AppCategory=if(App=="appD", "appD", "appsABC")
| timechart sum(Rate) AS appSumRate BY AppCategory

Re: Why does appendcols only show a fraction of overall search?

sbentley_ea — Mon, 18 Nov 2019 18:20:48 GMT

I wanted to separate the appSumRate by Apps and when I use this I only get two categories. To add on to what I was trying to do, with appDsumRate, I wanted to use it to get the ratios relative to the rest of the apps.