Can I add the value of two columns parsed from log data using Advanced Data Model?

Sample CSV DATA:

date,col2,col3

9/1/18 0:45,64.82448364,32.82448364

9/1/18 1:00,64.00945408,32.00945408

Based on the example data above, I would like to create a 4th column for use in Advanced Search that provides the sum of column2 and column 3. How can I get this accomplished? The values in col2 and col3 only display when I choose Float for the value type. I have tried $col2+$col3 but did not end in success; rather NULL.

 

 

 

 

(1) Answer

Login