Profile Picture

Creating YTD PIE Chart

Posted By Steve Murray 2 Years Ago
Author
Message
Steve Murray
Posted 2 Years Ago
View Quick Profile
Forum Newbie

Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)

Group: Forum Members
Last Active: 11 Months Ago
Posts: 17, Visits: 79
https://www.nevron.com/forum/uploads/images/4968d393-b890-4ae9-bf08-d3ef.pngI am trying to create a YTD chart for costs (Monthly, Local, Data, International and Roaming).  The information is contained in a Sharepoint Teamsite list which is 15,000 records.  The fields I want to SUM are contained within the individual records, but each record has all of the fields (Monthly, Local, Data, International and Roaming).
The YTD Chart works if I place a filter on Month="10"; but doesn't work and displays nothing if I remove the filter.
Does Nevron Chart support lookups with 15,000 records, multiple fields?
I am attaching screenshots of the Sharepoint code.
1) Screenshot of chart working when I use a filter for Monnth="10"
2) Second screenshot is for value definitions
3) Third screenshot is for filter setting.https://www.nevron.com/forum/uploads/images/fcdad20a-7634-40f2-bc1c-aee5.png
https://www.nevron.com/forum/uploads/images/d2de99de-be19-44db-b7cc-aa85.png


Steve Murray
Posted 2 Years Ago
View Quick Profile
Forum Newbie

Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)

Group: Forum Members
Last Active: 11 Months Ago
Posts: 17, Visits: 79
Problem resolved.... Below are my Value settings.... Still don't know how to get those commas inserted into the number values.https://www.nevron.com/forum/uploads/images/15ad629c-fe95-4350-b21e-6891.png

Nevron Support Team
Posted 2 Years Ago
View Quick Profile
Supreme Being

Supreme Being (3,273 reputation)Supreme Being (3,273 reputation)Supreme Being (3,273 reputation)Supreme Being (3,273 reputation)Supreme Being (3,273 reputation)Supreme Being (3,273 reputation)Supreme Being (3,273 reputation)Supreme Being (3,273 reputation)Supreme Being (3,273 reputation)

Group: Moderators
Last Active: 3 days ago @ 8:33 AM
Posts: 2,593, Visits: 2,279
Please, take a look at the following Forum topic:
https://www.nevron.com/Forum/9497/Rounding-Percentages-and-Numbers-adding-a-second-row-in-legend-so-it-displays-two-lines-per-box


Best Regards,
Nevron Support Team





Similar Topics


Reading This Topic