https://community.splunk.com/t5/Getting-Data-In/How-to-create-new-column-with-percentage/m-p/608566#M105574 <P>Hi,</P> <P>My search is giving below output,</P> <P>Month&nbsp; FieldA&nbsp; &nbsp; FieldB<BR />Jan&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;285&nbsp; &nbsp; &nbsp; 1410<BR />Feb&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;247&nbsp; &nbsp; &nbsp; 1934<BR />Mar&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;215&nbsp; &nbsp; &nbsp; 2197</P> <P>Can we create a new column with FieldA% and FieldB%, below is the example</P> <P>Month&nbsp; FieldA&nbsp; &nbsp; FieldB&nbsp; &nbsp;FieldA% FieldB%<BR />Jan&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;285&nbsp; &nbsp; &nbsp; 1410&nbsp; &nbsp; &nbsp; &nbsp; 20%&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;80%&nbsp; &nbsp; &nbsp;&nbsp;<BR />Feb&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;247&nbsp; &nbsp; &nbsp; 1934&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;22%&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 78%<BR />Mar&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;215&nbsp; &nbsp; &nbsp; 2197&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;15%&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;85%</P> <P>Eventually i will only be using Month and FieldA% in a column chart</P> Fri, 05 Aug 2022 22:59:03 GMT SS1 2022-08-05T22:59:03Z https://community.splunk.com/t5/Getting-Data-In/How-to-create-new-column-with-percentage/m-p/608566#M105574 <P>Hi,</P> <P>My search is giving below output,</P> <P>Month&nbsp; FieldA&nbsp; &nbsp; FieldB<BR />Jan&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;285&nbsp; &nbsp; &nbsp; 1410<BR />Feb&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;247&nbsp; &nbsp; &nbsp; 1934<BR />Mar&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;215&nbsp; &nbsp; &nbsp; 2197</P> <P>Can we create a new column with FieldA% and FieldB%, below is the example</P> <P>Month&nbsp; FieldA&nbsp; &nbsp; FieldB&nbsp; &nbsp;FieldA% FieldB%<BR />Jan&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;285&nbsp; &nbsp; &nbsp; 1410&nbsp; &nbsp; &nbsp; &nbsp; 20%&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;80%&nbsp; &nbsp; &nbsp;&nbsp;<BR />Feb&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;247&nbsp; &nbsp; &nbsp; 1934&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;22%&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 78%<BR />Mar&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;215&nbsp; &nbsp; &nbsp; 2197&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;15%&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;85%</P> <P>Eventually i will only be using Month and FieldA% in a column chart</P> Fri, 05 Aug 2022 22:59:03 GMT https://community.splunk.com/t5/Getting-Data-In/How-to-create-new-column-with-percentage/m-p/608566#M105574 SS1 2022-08-05T22:59:03Z https://community.splunk.com/t5/Getting-Data-In/How-to-create-new-column-with-percentage/m-p/608571#M105575 <P>Use <FONT face="courier new,courier">eval</FONT> to compute the percentage</P><LI-CODE lang="markup">| eval FieldApct = (FieldA*100)/(FieldA + FieldB) | rename FieldApct as "FieldA%"</LI-CODE><P>&nbsp;</P> Fri, 05 Aug 2022 23:28:38 GMT https://community.splunk.com/t5/Getting-Data-In/How-to-create-new-column-with-percentage/m-p/608571#M105575 richgalloway 2022-08-05T23:28:38Z