nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

dynamic series on chart

dmoore

I have dynamic measures for different projects.
I may have at 1 point in time 4 projects with 10-30 different measures each
is it possible to have each measure plot out to individual series in the chart dynamically? 
or does every measure have to be created before hand and if the data doesn't support it then it doesn't show on chart? or perhaps behind the scenes I tell chart (with API) to not show certain series? 
it just appears to me that you have to create the series manually in the chart GUI and cant tell it to just say - with the data given (filtered data) show every measure in the current data?

Find more posts tagged with

Comments

mwilliams

Depending on your data setup, the optional y-series grouping would dynamically create the series if it exists in the data.

dmoore

what I am asking is it dynamically creating up to 30 series on the fly - not a single series on the right side. 
is this possible or would I have to manually create every series first?

mwilliams

I'm not certain you understand what the optional y-series grouping does. It creates N series in your chart based on the field used. So, if your data was set up to be able to use the optional y-series grouping properly, it'd create MANY series.
 
For example:
 
If you had data like this:
ID | Group A | Group B | Group C
1 | Value 1 | Value 1 | Value1
2 | Value 2 | Value 2 | Value2
3 | Value 3 | Value 3 | Value3
4 | Value 4 | Value 4 | Value4
 
You'd have to create three separate series manually for A, B, and C.
 
If you transformed your data to be like this:
 
ID | Value | Group
1 | Val 1 | A
1 | Val 1 | B
1 | Val 1 | C
2 | Val 2 | A
2 | Val 2 | B
2 | Val 2 | C
3 | Val 3 | A
3 | Val 3 | B
3 | Val 3 | C
4 | Val 4 | A
4 | Val 4 | B
4 | Val 4 | C
 
You could use Id for the xAxis, Value for the yAxis, and Group for the optional y-series grouping field and the chart would automatically be created with three series A, B, and C. If any one of those three values wasn't represented, it wouldn't have a series created.
 
Hope this better explains the option I suggested.