Sparkline charts require comma-separated values for input, so if your data is not in that format, you must create a function to pull it from your data source and put commas between each data point. You can also create data points by hand and enter them into a formula directly.
To add a sparkline chart to your report, follow this process.
-
Drag and drop a Sparkline Pie, Sparkline Bar, or Sparkline Line element into a layout band.
-
Using the resize handles, change the size of the chart to fit your
specifications.
-
Click the round green + icon in the Value row.
A formula field will appear.
-
In the formula field, select the function that formats your sparkline data, or type in comma-separated values by hand directly, then click Close.
-
Click Preview to verify that your chart appears as intended.