Follow the steps below to configure a Line Chart with Dynamic Series. If you are unsure if a Dynamic Series is right for your usage please consult the example here.

 

1. Select the Switch to Dynamic Series button. NOTE: You will be warned that you will lose any configurations at this point. You can, additionally, switch back to a static series configuration at any point.

 

Figure 1: The Dynamic Series button in the insert chart dialog.

 

2. Select the Field that you want to be presented on the Category Axis ( X-Axis) from the drop down list of available fields.

 

Figure 2: Year was selected for the Category axis value.

 

 

3. Select the Field that you want to be presented on the Value Axis ( Y-Axis) from the drop down list of available fields.

 

Figure 3: The sum of the Retail Sales was selected to be the value of the chart.

 

4. If needed change the function of the Value Axis by selecting the summation button.

 

Figure 4: The list of available function types.

 

5. You will need to select the dimension whose values will be used to create the series dynamically.

 

Figure 5: Education was selected to be the series of the chart.

 

6. Select the Line Type that you would like to use for this chart.

 

Figure 6: The options for the line type.

 

7. Once you have configured all of your series all of your Chart, you may need to apply a local filter to your data. Visit this helpful page to learn more about applying a local filter.

 

Figure 7: The edit filter button in the Insert Chart Dialog.

 

8. You are able to enter a Caption for the Chart in the Properties section if needed.

 

Figure 8: A caption was added to the Chart.

 

9. Once you have set up the Dynamic Series select Insert and the chart will be inserted in to the design surface.

 

Figure 9: The resulting chart in the design surface.

 

Next Steps

Chart Properties - Learn about how to edit and customize your chart after inserting it into the design surface.

Include or Exclude Widgets - Learn how to exclude widgets from your dashboard without deleting it all together.

Resizing Widgets - Learn how to resize your widgets in the design surface.

Repositioning Widgets - Lean how to reposition your widgets after inserting into the design surface.