Sparkline Trends
In addition to showing the KPIs and Variance to a benchmark, we can also visualize the trend of a KPI.
Insert a Category in the ‘Sparkline’ data field which will be the X-axis:
![](https://docs.xviz.com/~gitbook/image?url=https%3A%2F%2F382510089-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FIuuIZWiXEx25eV75hmmJ%252Fuploads%252FMSE6w0So2TKwWaNWVdvv%252Fimage.png%3Falt%3Dmedia%26token%3D1eba5aac-38db-4eff-aefa-85f140e18dd7&width=768&dpr=4&quality=100&sign=f53c8ab9&sv=1)
Let’s also add a third metric for Employee Performance in the ‘Values’ data field:
![](https://docs.xviz.com/~gitbook/image?url=https%3A%2F%2F382510089-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FIuuIZWiXEx25eV75hmmJ%252Fuploads%252Fbx1GERjdxGzpKxSXnJjR%252Fimage.png%3Falt%3Dmedia%26token%3D688d2664-80ff-47ab-adca-461fad4aef43&width=768&dpr=4&quality=100&sign=c1fb4841&sv=1)
By default, all the measures in the ‘Values’ field will be plotted in the Sparkline:
![](https://docs.xviz.com/~gitbook/image?url=https%3A%2F%2F382510089-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FIuuIZWiXEx25eV75hmmJ%252Fuploads%252FpNI2UVXdMr6Xt1r3Tp0u%252Fimage.png%3Falt%3Dmedia%26token%3D04e8dd60-5b40-40e1-863c-968789dd3349&width=768&dpr=4&quality=100&sign=2454e911&sv=1)
We can select the measures to be used in the Sparkline using the Sparkline ‘Settings’ in the top ribbon menu:
![](https://docs.xviz.com/~gitbook/image?url=https%3A%2F%2F382510089-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FIuuIZWiXEx25eV75hmmJ%252Fuploads%252FwUeKsZQoxRcfXgdR65Bm%252Fimage.png%3Falt%3Dmedia%26token%3Da2205e54-13be-47e0-8f3f-fbb8f1f12e24&width=768&dpr=4&quality=100&sign=7529aca3&sv=1)
For our example, let’s plot only ‘Performance Score’ in the Sparkline as shown in the above settings. The visual now looks as shown below:
![](https://docs.xviz.com/~gitbook/image?url=https%3A%2F%2F382510089-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FIuuIZWiXEx25eV75hmmJ%252Fuploads%252FdTLmtGEAGuL5chSoFdCV%252Fimage.png%3Falt%3Dmedia%26token%3Df15d198f-9edb-44da-ae10-d5d3a12eb02f&width=768&dpr=4&quality=100&sign=e51a093&sv=1)
We can also change the ‘Chart Type’ to change the line chart of the sparkline to an alternate visualization:
![](https://docs.xviz.com/~gitbook/image?url=https%3A%2F%2F382510089-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FIuuIZWiXEx25eV75hmmJ%252Fuploads%252FDgwQwD9XoPyV94wvy6yS%252Fimage.png%3Falt%3Dmedia%26token%3D4d5bccaa-a1be-41dd-908e-416d793fb589&width=768&dpr=4&quality=100&sign=a02015fa&sv=1)
Additional configurations for the sparkline are provided here:
![](https://docs.xviz.com/~gitbook/image?url=https%3A%2F%2F382510089-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FIuuIZWiXEx25eV75hmmJ%252Fuploads%252Fjr6GUWDnPpSjfexKEdlw%252Fimage.png%3Falt%3Dmedia%26token%3Dfca65097-a6e9-4eb3-beda-c4c3e5ad8bdf&width=768&dpr=4&quality=100&sign=daacbe8b&sv=1)
For our example, we have set the Chart Type to Area Chart. And enabled Marker for all datapoints.
Last updated