topic Re: How to aggregate data from CSV file in Splunk Chart? in Splunk Search https://community.splunk.com/t5/Splunk-Search/How-to-aggregate-data-from-CSV-file-in-Splunk-Chart/m-p/135928#M37180 <P>You can use your tickets opened per each day to accumulate that:</P> <PRE><CODE>... | stats count by OpenDate | accum count as openTickets </CODE></PRE> <P>Verify that your rows are sorted by date correctly before the <CODE>accum</CODE>.</P> Wed, 09 Jul 2014 17:48:45 GMT martin_mueller 2014-07-09T17:48:45Z How to aggregate data from CSV file in Splunk Chart? https://community.splunk.com/t5/Splunk-Search/How-to-aggregate-data-from-CSV-file-in-Splunk-Chart/m-p/135927#M37179 <P>Hi guys,</P> <P>I have CSV file with following structure,</P> <P>TicketNumber,OpenDate<BR /> 1,date1<BR /> 2,date1<BR /> 3,date1<BR /> 4,date2<BR /> 5,date3<BR /> 6,date3</P> <P>And I need to build bars with information on how many tickets were opened for specific date. I mean:</P> <P>Date1 = 3 tickets<BR /> Date2 = 3 tickets + 1 ticket = 4 tickets<BR /> Date3 = 4 tickets + 2 tickets = 6 tickets</P> <P>Is it possible?</P> <P>For now I've built a graph with "how many tickets were opened in date1, date2, date3", but I need some kind of aggregation.</P> Wed, 09 Jul 2014 17:27:19 GMT https://community.splunk.com/t5/Splunk-Search/How-to-aggregate-data-from-CSV-file-in-Splunk-Chart/m-p/135927#M37179 rus7am 2014-07-09T17:27:19Z Re: How to aggregate data from CSV file in Splunk Chart? https://community.splunk.com/t5/Splunk-Search/How-to-aggregate-data-from-CSV-file-in-Splunk-Chart/m-p/135928#M37180 <P>You can use your tickets opened per each day to accumulate that:</P> <PRE><CODE>... | stats count by OpenDate | accum count as openTickets </CODE></PRE> <P>Verify that your rows are sorted by date correctly before the <CODE>accum</CODE>.</P> Wed, 09 Jul 2014 17:48:45 GMT https://community.splunk.com/t5/Splunk-Search/How-to-aggregate-data-from-CSV-file-in-Splunk-Chart/m-p/135928#M37180 martin_mueller 2014-07-09T17:48:45Z Re: How to aggregate data from CSV file in Splunk Chart? https://community.splunk.com/t5/Splunk-Search/How-to-aggregate-data-from-CSV-file-in-Splunk-Chart/m-p/135929#M37181 <P>thanks a lot! that's works!</P> Thu, 10 Jul 2014 09:43:36 GMT https://community.splunk.com/t5/Splunk-Search/How-to-aggregate-data-from-CSV-file-in-Splunk-Chart/m-p/135929#M37181 rus7am 2014-07-10T09:43:36Z Re: How to aggregate data from CSV file in Splunk Chart? https://community.splunk.com/t5/Splunk-Search/How-to-aggregate-data-from-CSV-file-in-Splunk-Chart/m-p/135930#M37182 <P>Great. Don't forget to mark this as solved.</P> Thu, 10 Jul 2014 15:53:33 GMT https://community.splunk.com/t5/Splunk-Search/How-to-aggregate-data-from-CSV-file-in-Splunk-Chart/m-p/135930#M37182 martin_mueller 2014-07-10T15:53:33Z