https://community.splunk.com/t5/Splunk-Search/How-to-create-a-single-value-element-for-the-dashboard/m-p/362494#M107097 <P>Super appreciated, many thanks buddy!</P> Wed, 25 Apr 2018 18:48:11 GMT leanpro 2018-04-25T18:48:11Z https://community.splunk.com/t5/Splunk-Search/How-to-create-a-single-value-element-for-the-dashboard/m-p/362492#M107095 <P>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.<span class="lia-inline-image-display-wrapper" image-alt="alt text"><img src="https://community.splunk.com/t5/image/serverpage/image-id/4837i0C6884CB5A65B871/image-size/large?v=v2&amp;px=999" role="button" title="alt text" alt="alt text" /></span></P> Wed, 25 Apr 2018 17:34:17 GMT https://community.splunk.com/t5/Splunk-Search/How-to-create-a-single-value-element-for-the-dashboard/m-p/362492#M107095 leanpro 2018-04-25T17:34:17Z https://community.splunk.com/t5/Splunk-Search/How-to-create-a-single-value-element-for-the-dashboard/m-p/362493#M107096 <P>Try this</P> <PRE><CODE>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 </CODE></PRE> <P>select single value visualization in Visualization tab. If all looks good, Save As dashboard panel.</P> Wed, 25 Apr 2018 18:13:18 GMT https://community.splunk.com/t5/Splunk-Search/How-to-create-a-single-value-element-for-the-dashboard/m-p/362493#M107096 somesoni2 2018-04-25T18:13:18Z https://community.splunk.com/t5/Splunk-Search/How-to-create-a-single-value-element-for-the-dashboard/m-p/362494#M107097 <P>Super appreciated, many thanks buddy!</P> Wed, 25 Apr 2018 18:48:11 GMT https://community.splunk.com/t5/Splunk-Search/How-to-create-a-single-value-element-for-the-dashboard/m-p/362494#M107097 leanpro 2018-04-25T18:48:11Z