Yes, to your question. Here's where I'm confused, don't I need some type of wrapper/control that captures the dates and then binds it to the table and pie chart?
That's what seems to be going on here: https://code.google.com/apis/ajax/playground/?type=visualization#full_dashboard There is a slider and category picker control that's used to pass values to the charts and rendered accordingly. On Wed, May 7, 2014 at 5:09 PM, Andrew Gallant <[email protected]>wrote: > 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]> 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]>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]. >>>> 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. >>>> >>> >>> >>> >>> -- >>> -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 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]. > 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. > -- -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.
