Graphs with unknown number of series
I want a graph that displays a score for each indiviual, in a way to engage employees. The problem I see is that a graph can only have a set number of series, and the way it is done makes a lot of programming needed every time someone quits or is hired.
As I understand it, every emplyee needs their own data table instead of merging all stats into one table and just have the employment number. Which means the data mining script that runs every night needs to be changed all the time. This is not a solution that fits the needs.
In a somewhat easied version, I see a table with three fields, "employee" [number], "date" [auto populated at creation of post] and score [number]. I want x to be date, y to be score, and employees as different lines in the graph over a selectable time period.
Anyone see another solution I don't?