Reporting

Data Model: If I have a 2 columns in a pivot with numeric values, is it possible to create a 3rd column with a ratio of those values?

Path Finder

Hi

In the pivot, I have two columns with numeric values. I would like to create third column with ratio of those two compute columns.

Is it possible? I do not want to add to the search in the data model because then I cannot use other attributes.

e.g
Column1/column2=column3

Data Column1 Column2 Column3
01-01-2015 100 200 0.5
02-02- 2015 200 100 2

Contributor

Add a calculated field using eval expression to your data model.

App-> pivot->choose datamodel-> Edit->disable acceleration(if enabled) -> Edit --> Add attribute --> Choose Eval ( enter below eval condition & Preview, submit)

eval Column3=Cloumn2/Column1

And also you can find more information for adding calculated fields here.

Calculated Fields
Defining calculated fields

0 Karma

Path Finder

This will not work because Column 1 and Column2 are created in Pivot as Column Volume (they do not exist in the objects)
Basically they are aggregated values created in Pivot editor

0 Karma

Contributor

OK try to open the search and apply the eval on the search and you can save it as report/Dashboard.

AFAIK calculation on the pivot editor not possible, never tried let me check it out.

0 Karma

Path Finder

in search I can not add this because calculated fields do not exist. They are computed in the Pivot

0 Karma
State of Splunk Careers

Access the Splunk Careers Report to see real data that shows how Splunk mastery increases your value and job satisfaction.

Find out what your skills are worth!