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?
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
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.