Splunk Enterprise

Results are miss match while using appedcols

marisstella
Explorer

Hello everyone,

I am getting incorrect values while using appendcols to fetch the different results like a currentweek, 1weekago,  2weeksago.

 

|bin _time span=1h |
stats count{trid) as transaction_count_1WAgo avg(duration) as Average RT_1WAgo by _time ABC | fields *
 
|appendcols [search earliest=** latest=** |
|bin _time span=1h
| stats count(trid) as transaction_count_2WAgo avg(duration) as Average RT_2WAgo by _time ABC | fields *
]
 
|appendcols [search earliest=** latest=** |
|bin _time span=1h |
stats count{trid) as transaction_count_currentweek avg(duration) as Average RT_currentweek by _time ABC| fields *]
 
If I run all this queries individually it shows some results and when I am trying to use them in a single search by appending using "appendcols" they shows different..
 
Please suggest on this?
Note: i have used all latest, earliest time frames correctly but didn't show here.
Labels (3)
0 Karma
Get Updates on the Splunk Community!

Buttercup Games: Further Dashboarding Techniques (Part 2)

This series of blogs assumes you have already completed the Splunk Enterprise Search Tutorial as it uses the ...

Index This | What is the next number in the series? 7,645 5,764 4,576…

February 2025 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with this ...

Buttercup Games: Further Dashboarding Techniques

Hello! We are excited to kick off a new series of blogs from SplunkTrust member ITWhisperer, who demonstrates ...