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 ... .
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' ]
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' ]
thank you for your help!
i solved it.