Hi,
My search is giving below output,
Month FieldA FieldB
Jan 285 1410
Feb 247 1934
Mar 215 2197
Can we create a new column with FieldA% and FieldB%, below is the example
Month FieldA FieldB FieldA% FieldB%
Jan 285 1410 20% 80%
Feb 247 1934 22% 78%
Mar 215 2197 15% 85%
Eventually i will only be using Month and FieldA% in a column chart
Use eval to compute the percentage
| eval FieldApct = (FieldA*100)/(FieldA + FieldB)
| rename FieldApct as "FieldA%"