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.
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.
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.
Super appreciated, many thanks buddy!