Archive

How to set a formula for each column in the summary row

New Member

If you use table visualization during a dashboard, you can set a summary row at the bottom.
The summary row simply shows the sum or percentage of the corresponding column in the table,
Can you set this to a formula for each column?

For example, if you have a
The summary row for each column of 'sales', 'number of customers', and 'customer price' shows only the sum of the corresponding columns,
The summary line of 'customer price' is 'sales' / 'number of customers' = 7366600/951 = 7746.16 ... .
alt text

Tags (1)
0 Karma
1 Solution

You can achieve this by adding an appendpipe subsearch to the end of your current search:

your base search yielding the table above
| appendpipe 
[ | stats sum(sales) AS sales, stats sum("number of customers") AS "number of customers" 
  | eval "customer price"=sales/'number of customers' ]

View solution in original post

0 Karma

You can achieve this by adding an appendpipe subsearch to the end of your current search:

your base search yielding the table above
| appendpipe 
[ | stats sum(sales) AS sales, stats sum("number of customers") AS "number of customers" 
  | eval "customer price"=sales/'number of customers' ]

View solution in original post

0 Karma

New Member

thank you for your help!
i solved it.

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!