Quarter Type Amount 2014q1 a 100 2014q1 b 200 2015q2 a 100 2015q2 b 100
I would like to create an additional column with sum for the same quarter.
Quarter Type Amount New_column 2014q1 a 100 300 2014q1 b 200 300 2015q2 a 100 200 2015q2 b 100 200
My current search:
index=test |stats(amount) as amount by quarter type
I do not want to use join and append.
Could you help me?
Glad @somesoni2 helped you find your answer 🙂 Please be sure to accept his answer by clicking "Accept" directly below the answer, otherwise this post will show as unresolved. Thanks!