https://community.splunk.com/t5/Splunk-Search/Splunk-JavaScript-API-getting-stats-in-a-search/m-p/226497#M66791 <P>I am using the Splunk JavaScript API to create a dashboard to aggregate data. One of my searches that I want literally just sums up the total of a given field using</P> <PRE><CODE>search index=[index] source="[path]" | stats sum("Val_in rep_cur") as Total </CODE></PRE> <P>Even though this gives the correct number on the website, it is in the 'statistics' tab. When I run this same search in the JavaScript API, the results object is just empty. How can I get the sum of a field in the JavaScript API?</P> <P>EDIT:<BR /> So it looks like if I replace stats with eventstats it will add a new field to each event. However, I am still not getting any results in the API.</P> <P>My new search is</P> <PRE><CODE>search index=[index] source="[path]" | eventstats sum("Val_in rep_cur") as Total | dedup Total | fields Total </CODE></PRE> Thu, 11 Aug 2016 13:01:56 GMT najarvis 2016-08-11T13:01:56Z https://community.splunk.com/t5/Splunk-Search/Splunk-JavaScript-API-getting-stats-in-a-search/m-p/226497#M66791 <P>I am using the Splunk JavaScript API to create a dashboard to aggregate data. One of my searches that I want literally just sums up the total of a given field using</P> <PRE><CODE>search index=[index] source="[path]" | stats sum("Val_in rep_cur") as Total </CODE></PRE> <P>Even though this gives the correct number on the website, it is in the 'statistics' tab. When I run this same search in the JavaScript API, the results object is just empty. How can I get the sum of a field in the JavaScript API?</P> <P>EDIT:<BR /> So it looks like if I replace stats with eventstats it will add a new field to each event. However, I am still not getting any results in the API.</P> <P>My new search is</P> <PRE><CODE>search index=[index] source="[path]" | eventstats sum("Val_in rep_cur") as Total | dedup Total | fields Total </CODE></PRE> Thu, 11 Aug 2016 13:01:56 GMT https://community.splunk.com/t5/Splunk-Search/Splunk-JavaScript-API-getting-stats-in-a-search/m-p/226497#M66791 najarvis 2016-08-11T13:01:56Z https://community.splunk.com/t5/Splunk-Search/Splunk-JavaScript-API-getting-stats-in-a-search/m-p/226498#M66792 <P><STRIKE>Somehow removing the source ended up fixing the problem</STRIKE>. The answer I was looking for was changing stats to eventstats. I only had two backslashes in my search, but because it was in a string in JavaScript it needed 4.</P> <PRE><CODE>source="G:\\AutoIndex\\spending\\Catalog Report - 8758 Devices.csv" </CODE></PRE> <P>should've been</P> <PRE><CODE>source="G:\\\\AutoIndex\\\\spending\\\\Catalog Report - 8758 Devices.csv" </CODE></PRE> Thu, 11 Aug 2016 14:48:26 GMT https://community.splunk.com/t5/Splunk-Search/Splunk-JavaScript-API-getting-stats-in-a-search/m-p/226498#M66792 najarvis 2016-08-11T14:48:26Z