Dashboard

[TheInnovator]

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!

[Andrew Gallant]

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)?

[Isaac Sogunro]

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.

--
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 google-visualizati...@googlegroups.com.
To post to this group, send email to google-visua...@googlegroups.com.
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 Sogunro]

Here's my sample data to give you an idea of what I have.  thanks

http://isaac.issharepoint.com/Lists/Ticketing%20System/AllItems.aspx

[Andrew Gallant]

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 <isog...@gmail.com> 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 <asgall...@gmail.com> 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 google-visualization-api+unsub...@googlegroups.com.

To post to this group, send email to google-visua...@googlegroups.com.
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 Sogunro]

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.

To unsubscribe from this group and all its topics, send an email to google-visualizati...@googlegroups.com.

To post to this group, send email to google-visua...@googlegroups.com.
Visit this group at http://groups.google.com/group/google-visualization-api.
For more options, visit https://groups.google.com/d/optout.

[Andrew Gallant]

You can use something like that if you want to handle the aggregation client-side, but the Dashboards (which tie controls to charts/tables) are not designed to do what you want.  Grouping data after applying a filter is a bit trickier to accomplish, but I wrote an example a while back demonstrating how you can do it: http://jsfiddle.net/asgallant/R9Fz4/.  The example filters on a category rather than on dates, but the same principles apply.

To unsubscribe from this group and all its topics, send an email to google-visualization-api+unsubscr...@googlegroups.com.