Is you PieChart supposed to show a sum of each ticket type in the given time period (or something similar)?
There are two approaches you can take with this. In a typical database-driven system, you would be able to query the database and have it send you the sums. I assume SharePoint can do this as well, but I've learned to never underestimate Microsoft's willingness to release crippled products. If Sharepoint can't do it, or you want to handle it client-side, the Visualization API provides the google.visualization.data.group function, which will aggregate your data for you. If that is insufficient, you can always manually parse your data and build a DataTable in whatever form you need. On Wednesday, May 7, 2014 2:39:36 PM UTC-4, TheInnovator wrote: > > Here's my sample data to give you an idea of what I have. thanks > > http://isaac.issharepoint.com/Lists/Ticketing%20System/AllItems.aspx > > > > On Wed, May 7, 2014 at 11:41 AM, Isaac Sogunro <[email protected]<javascript:> > > wrote: > >> Hi, >> >> Yes I want to render the pieChart based on a set of dates. >> So if the user enters 5/1/2014 and 5/7/2014 as the begin and end date, I >> want my pie chart and a table to render based on those values. >> >> So, since my data is coming from a list, I will have to do calculations >> within the dates provided and render the pie chart and table. >> >> Visual Excel Example: >> >> Hope that makes sense. >> >> >> >> On Wed, May 7, 2014 at 10:40 AM, Andrew Gallant >> <[email protected]<javascript:> >> > wrote: >> >>> Do you just want to render the PieChart based on a set of dates, or do >>> you want to manipulate the data in some fashion first (like get a sum of >>> one category grouped by another category)? >>> >>> On Wednesday, May 7, 2014 9:15:22 AM UTC-4, TheInnovator wrote: >>>> >>>> Has anyone ever created a dashboard that accepted dates (Begin: and >>>> End:)? >>>> >>>> I have a SharePoint list that has date columns and I want my pie chart >>>> to render based on the begin and end dates. >>>> >>>> I would appreciate any insight on how to do this if possible. >>>> >>>> Thanks! >>>> >>> -- >>> You received this message because you are subscribed to a topic in the >>> Google Groups "Google Visualization API" group. >>> To unsubscribe from this topic, visit >>> https://groups.google.com/d/topic/google-visualization-api/cU3xajvokSI/unsubscribe >>> . >>> To unsubscribe from this group and all its topics, send an email to >>> [email protected] <javascript:>. >>> To post to this group, send email to >>> [email protected]<javascript:> >>> . >>> Visit this group at >>> http://groups.google.com/group/google-visualization-api. >>> For more options, visit https://groups.google.com/d/optout. >>> >> >> >> >> -- >> -Isaac- >> >> http://twitter.com/#!/feedy0urmind >> You are today where your thoughts have brought you; you will be tomorrow >> where your thoughts take you. >> - James Allen >> > > > > -- > -Isaac- > > http://twitter.com/#!/feedy0urmind > You are today where your thoughts have brought you; you will be tomorrow > where your thoughts take you. > - James Allen > -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/google-visualization-api. For more options, visit https://groups.google.com/d/optout.
