I've two counter streams, I would like to display that as a percentage as
B/(B+C) in the chart but it always gives me an error.
B = data('prod.metrics.biz.l2_cache_miss', rollup='rate', extrapolation='zero').publish(label='B')
C = data('prod.metrics.biz.l2_cache_hit', rollup='rate', extrapolation='zero').publish(label='C')
How can I create a new metrics out of these two to find either cache hit or miss percentage?
Hi @sks if you want just the percentage of misses and the percentage of hits, you can do this with eval:
| eval Bperc=('B'/(B+C))*100
| eval Cperc=('C'/(B+C))*100
If you want to show this in a chart (e.g. pie chart) you don't need to calculate the percentage as Splunk will do this for you, but you will need to get the values of B and C in the same column using transpose. Example:
Hi @KendallW
Thanks for the reply, but that does not work as I'm plotting this in the line chart. The data is coming to SignalFx from the StatsD agent.