Splunk Search
Highlighted

How to create a single value element for the dashboard?

Engager

I have following stats. I want to create a single value element which will show the revenue of 2014 and increase/decrease from last year.alt text

0 Karma
Highlighted

Re: How to create a single value element for the dashboard?

SplunkTrust
SplunkTrust

Try this

index="sales_data" sourcetype=csv | stats sum(Revenue) as Total_Revenue by Year 
| eval _time=strptime(Year."-01-01","%Y-%m-%d")
| timechart span=1y sum(Total_Revenue) as Total_Revenue

select single value visualization in Visualization tab. If all looks good, Save As dashboard panel.

View solution in original post

0 Karma
Highlighted

Re: How to create a single value element for the dashboard?

Engager

Super appreciated, many thanks buddy!

0 Karma