Hi, have you solve the issues? Can you share with us?
On Friday, September 11, 2015 at 2:27:46 PM UTC-4, Manou wrote:
>
> Hello,
>
> I have the following json data from our Sharepoint Server and I am trying
> to use Google charts to generate a pie chart and a bar chart:
>
> I have 4 teams for which I need to create a separate pie chart. For each
> pie chart, I need to:
> 1) count the number of all open task by team;
> 2) count the number of past due tasks by Team. To achieve this I am
> thinking of checking if the due date is past then count the total number
> the past due tasks by Team and show on the chart,
> 3) Count the total number of tasks that are due in 7 days from today by
> team.
>
> And for the Bar chart, I need to:
> 4) generate a bar chart for all the 4 teams with the average task duration
>
> So far I am able to pull the data from the server and show some basic
> piechart, which is not in the format that I need. Grouping or
> categorization is missing.
>
> I need help with with grouping the different elements of the list item by
> TeamName when producing the pie chart per team.
>
> I have spent many days trying to solve this without success.
>
> My data from our SharePoint list looks like below:
>
> {
> "d":
> {
> "results":
> [
> {
> "__metadata":
> {
> "id":
> "Web/Lists(guid'0000-000-0000-3344-afret4532')/Items(11)",
> "uri": "
> https://myserver/home/siteDev/_api/Web/Lists(guid'0000-000-0000-3344-afret4532')/Items(11)
> ",
> "etag": ""22"",
> "type": "SP.Data.TasksDevelopment"
> },
> "TeamName": "Team, (TE-08)",
> "TaskName": "Task1",
> "DueDate": "2014-04-25T04:00:00Z",
> "Status": "Closed",
> "Created": "2014-02-24T05:00:00Z",
> "DateClosed": "2014-04-17T04:00:00Z",
> "TaskDuration": "18",
> "PastDueDate": "2014-04-26T04:00:00Z"
> },
>
>
>
>
> Here is my current REST code that I am using and it is from the
> following blog post:
> http://blogs.microsoft.co.il/justguy/2013/05/22/google-charts-pie-2-with-angularjs-in-sharepoint-2013-using-rest/
>
>
> $scope.loadREST = function () {
>
> jQuery.ajax({
>
> url: "
> https://myserver/home/siteDev/_api/Web/Lists/GetByTitle('Teams')/Items?
>
>
> type: "GET",
>
> dataType: "json",
>
> async: "true",
>
> headers: { "Accept": "application/json;odata=verbose" },
>
> success: function (data) {
>
> var newData = [];
>
> jQuery.each(data.d.results, function(index,value) {
>
> newData.push([value.TeamName, value.Task_Duration]);
> });
>
> $scope.$apply(function(){
>
> $scope.chartData = newData;
>
> });
>
> },
>
> error: function () {
>
> alert("error");
>
> }
>
> });
>
> };
>
>
>
--
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 google-visualization-api+unsubscr...@googlegroups.com.
To post to this group, send email to google-visualization-api@googlegroups.com.
Visit this group at https://groups.google.com/group/google-visualization-api.
To view this discussion on the web visit
https://groups.google.com/d/msgid/google-visualization-api/85f0f54b-1c96-4dc9-9aaf-bd36fff7b087%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
