https://community.splunk.com/t5/Splunk-Search/How-to-append-a-single-value-to-multiple-rows-in-my-table/m-p/220149#M64710 <P>Try <CODE>... | filldown TotalCVE | eval perc=...</CODE>.</P> Tue, 09 Aug 2016 18:00:58 GMT richgalloway 2016-08-09T18:00:58Z https://community.splunk.com/t5/Splunk-Search/How-to-append-a-single-value-to-multiple-rows-in-my-table/m-p/220148#M64709 <PRE><CODE>base search| mvexpand Name | stats dc(Name) as totalcve by severity | appendcols [|inputlookup lookupname| stats count(Name) as TotalCVE] |eval perc=tostring(totalcve/TotalCVE*100, "commas")."% </CODE></PRE> <P>I have a search that outputs below table</P> <PRE><CODE>Severity totalCVE TotalCVE perc High 2000 10000 20% Medium 1000 Low 500 </CODE></PRE> <P>How can I append a single value (TotalCVE) to multiple rows and get perc for medium and low severities?</P> Tue, 09 Aug 2016 17:12:09 GMT https://community.splunk.com/t5/Splunk-Search/How-to-append-a-single-value-to-multiple-rows-in-my-table/m-p/220148#M64709 ashishlal82 2016-08-09T17:12:09Z https://community.splunk.com/t5/Splunk-Search/How-to-append-a-single-value-to-multiple-rows-in-my-table/m-p/220149#M64710 <P>Try <CODE>... | filldown TotalCVE | eval perc=...</CODE>.</P> Tue, 09 Aug 2016 18:00:58 GMT https://community.splunk.com/t5/Splunk-Search/How-to-append-a-single-value-to-multiple-rows-in-my-table/m-p/220149#M64710 richgalloway 2016-08-09T18:00:58Z https://community.splunk.com/t5/Splunk-Search/How-to-append-a-single-value-to-multiple-rows-in-my-table/m-p/220150#M64711 <P>Give this a try </P> <PRE><CODE> base search| mvexpand Name | stats dc(Name) as totalcve by severity | eval TotalCVE=[|inputlookup lookupname| stats count(Name) as search ] |eval perc=tostring(totalcve/TotalCVE*100, "commas")."% </CODE></PRE> Tue, 09 Aug 2016 18:30:07 GMT https://community.splunk.com/t5/Splunk-Search/How-to-append-a-single-value-to-multiple-rows-in-my-table/m-p/220150#M64711 somesoni2 2016-08-09T18:30:07Z