Sum of a multivalue field inside a row

[varunCarbyne]

Sum of a multivalue field inside a row

Hi below is how my processed data look like

And the expected output is to have aggregated values of Field A, field B, field C and Total,
the expected output looks like below :

[kamlesh_vaghela · Accepted solution]

@varunCarbyne

Try

YOUR_SEARCH | stats sum("field A") as "field A", sum("field B") as "field B",sum("field C") as "field C",sum(Total) as Total, Values(IP) as IP by User | table User IP "field A" "field B" "field C" Total

[DalJeanis]

Come on, @kamlesh_vaghela , if you're going to answer correctly, make it an answer!

[kamlesh_vaghela]

Thanks, @DalJeanis 🙂

Converted to Answer.

[gcusello]

Hi varunCarbyne,
could you share your search?
Bye.
Giuseppe

[varunCarbyne]

I have tried eventstats(FieldA) by User, But its now working

[varunCarbyne]

@vnravikumar @harishalipaka