How to create a single value element for the dashboard?

[leanpro]

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.

[somesoni2 · Accepted solution]

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.

[leanpro]

Super appreciated, many thanks buddy!