Solved: How to create a single value element for the dashb... - Splunk Community

Splunk Search

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.

13 KB

1 Solution

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.

View solution in original post

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.

Super appreciated, many thanks buddy!

Get Updates on the Splunk Community!

Vibe-coding, AI, and Splunkcraft: Highlights from the .conf26 Builder Bar

If you stopped by the Builder Bar at .conf26, thank you! This year, we brought ...

Thanks for the Memories: .conf26 Took Learning to New Heights

Thank you, Splunk Community, for making .conf26 in Denver one for the books. From packed Splunk University ...

Best Practices: Splunk auto adjust pipeline queue

When you enable autoAdjustQueue in Splunk, maxSize should be understood as the queue size Splunk starts with ...