Clarity

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.

Although it might not seem like it, this is essentially the same question I was vexing over recently here ;  Column Chart : Multiple X-Axis Values?  (and also here help setting up my graph portlet to show stacked values as project names )

(the difference between a column chart and a line chart being cosmetic)

So the answer is "YES" if your different metrics (managers in your case, OBSs in mine) is known and fixed at build time, and "NO (well ok yes but its far too fiddly)" if you are deriving your metrics dynamically.

The "YES" answer is a NSQL query that delivers the dimension (date) and score for manager1, score for manager2, score for manager3 (and so on) as separate metrics.

Darn, neither of those came up while searching (was looking for stuff like "lines", "series", etc), but unfortunately the plan was to have the list of managers filterable so it would be dynamic, might be 1 specific manager, might be a sub group. Looks like they might have to settle for just one at a time for now, atleast until we get Jasper up which just hasn't been much of a priority lately.