Hi all,
I'm trying to create a sum of fields inside a row, but I can't figure how to do it. This is my scenario:
My actual table:
T Service RequestTime A RequestTime B RequestTime C
---------------------------------------------------------------------
12 ms A 3 0 0
B 0 6 0
A 3 0 0
B 0 2 0
C 0 0 6
---------------------------------------------------------------------
56 ms A 2 0 0
B 0 4 0
A 3 0 0
B 0 2 0
C 0 0 1
I want to add 3 more columns with the each RequestTime column sum by row, to be like this:
T Service RequestTime A RequestTime B RequestTime C Total_A Total_B Total_C
-------------------------------------------------------------------------------------------------
12 ms A 3 0 0 6 8 6
B 0 6 0
A 3 0 0
B 0 2 0
C 0 0 6
------------------------------------------------------------------------------------------------
56 ms A 2 0 0 5 6 1
B 0 4 0
A 3 0 0
B 0 2 0
C 0 0 1
It's possible to do that?
Thank you
I found it:
... | eventstats sum(RequestTime A) as Total_A by Service | eventstats sum(RequestTime B) as Total_B by Service | eventstats sum(RequestTime C) as Total_C by Service | table ...
You can still club all three eventstats into one.
... | eventstats sum(RequestTime A) as Total_A by Service | eventstats sum(RequestTime B) as Total_B , sum(RequestTime C) as Total_C by Service | table...