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?

akawacz
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

krish3
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

akawacz
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

krish3
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

akawacz
Path Finder

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

0 Karma
Get Updates on the Splunk Community!

Splunk Forwarders and Forced Time Based Load Balancing

Splunk customers use universal forwarders to collect and send data to Splunk. A universal forwarder can send ...

NEW! Log Views in Splunk Observability Dashboards Gives Context From a Single Page

Today, Splunk Observability releases log views, a new feature for users to add their logs data from Splunk Log ...

Last Chance to Submit Your Paper For BSides Splunk - Deadline is August 12th!

Hello everyone! Don't wait to submit - The deadline is August 12th! We have truly missed the community so ...