AnsweredAssumed Answered

Is it possible to create a line chart with multiple lines/series?

Question asked by L.Elias Champion on Feb 2, 2016
Latest reply on Feb 2, 2016 by L.Elias

I'd like to create a line chart portlet to display multiple trendlines, and can't seem to figure out how or if it is even possible. We have created a new Score attribute on Projects, and a new object to track it over time. A process runs nightly to update the score on the project, and create a new instance of the new object to track the Project, Manager, Score, Date. We'd like a line chart with date along the X axis, Score along Y, and points for each manager (sum of scores) per day. I've created a query to return the sum of score per manager per day, but not sure how to turn it in to NSQL that allows for multiple series, or is that just not possible? We're on 14.2 and don't have Jasper stood up yet but I'm sure this would be relatively trivial at that point.