topic Re: Is there any method to compute separate totals? in Splunk Enterprise
https://community.splunk.com/t5/Splunk-Enterprise/Is-there-any-method-to-compute-separate-totals/m-p/410808#M8044
<P>I thought I had a glimmer of what you were asking, and was going to answer, but then I got stuck -</P>
<P>How does the sample data you provide related to the outcome? You have <CODE>1,10</CODE> in the first row of the former, but no reference to what to do with that in the latter. Where do we get the a, b or c? Is the a in "2a" the same a as in "4a" that adds/multiplies up to total1? And <EM>why</EM> is total2 got a 2a but a 4b instead of 4a? What determines that?</P>
<P>So I think it'll help to get you an answer if you could actually describe, step by step, how to get from the data to the answers that you want.</P>
<P>(For what it's worth, I have a suspicion this won't be a real hard thing to answer once it's described better.)</P>Mon, 26 Nov 2018 16:28:58 GMTRichfez2018-11-26T16:28:58ZIs there any method to compute separate totals?
https://community.splunk.com/t5/Splunk-Enterprise/Is-there-any-method-to-compute-separate-totals/m-p/410807#M8043
<P>Products, value </P>
<HR />
<P>1, 10<BR />
2a, 5<BR />
2b , 8<BR />
3, 10<BR />
4a, 2<BR />
4b, 4<BR />
4c, 6<BR />
5, 8</P>
<P>Outcome that i would like:<BR />
total1 = 1 + 2a + 3 + 4a + 5<BR />
total2 = 1 + 2a + 3 + 4b + 5<BR />
total3 = 1 + 2a + 3 + 4c + 5<BR />
total4 = 1 + 2b + 3 + 4a + 5<BR />
total5 = 1 + 2b + 3 + 4b + 5<BR />
total6 = 1 + 2b + 3 + 4c + 5<BR />
* *where the number of (a,b,c...) for each product (1,2,3,4) is not fixed (min 1 - 99).*</P>
<P>Thank you so much.</P>Mon, 26 Nov 2018 04:10:50 GMThttps://community.splunk.com/t5/Splunk-Enterprise/Is-there-any-method-to-compute-separate-totals/m-p/410807#M8043nipseaedwin2018-11-26T04:10:50ZRe: Is there any method to compute separate totals?
https://community.splunk.com/t5/Splunk-Enterprise/Is-there-any-method-to-compute-separate-totals/m-p/410808#M8044
<P>I thought I had a glimmer of what you were asking, and was going to answer, but then I got stuck -</P>
<P>How does the sample data you provide related to the outcome? You have <CODE>1,10</CODE> in the first row of the former, but no reference to what to do with that in the latter. Where do we get the a, b or c? Is the a in "2a" the same a as in "4a" that adds/multiplies up to total1? And <EM>why</EM> is total2 got a 2a but a 4b instead of 4a? What determines that?</P>
<P>So I think it'll help to get you an answer if you could actually describe, step by step, how to get from the data to the answers that you want.</P>
<P>(For what it's worth, I have a suspicion this won't be a real hard thing to answer once it's described better.)</P>Mon, 26 Nov 2018 16:28:58 GMThttps://community.splunk.com/t5/Splunk-Enterprise/Is-there-any-method-to-compute-separate-totals/m-p/410808#M8044Richfez2018-11-26T16:28:58Z