Is there any way to change the number of series in a chart based on how many measurements are in a table? I can hardcode several series into a chart. But, if one month, there was a new series appearing in the table, would there be a way to pick that up?
What I have done so far is create a hidden variable whose value is the number of distinct values in a field called "metrics". And I was thinking of saying something like: IF ROWNUM <= :HIDDEN_VARIABLE THEN... I'm not quite sure how this would work. I'm thinking that it would use a loop and each iteration of the loop would add a new series up until it hit the value in that hidden variable.
Sorry if this is unclear. I'm kind of brainstorming myself here. Thanks.