Download: pivotsparklines.zip
Introduction
This plugin was created to allow dashboard designers to create sparklines within a pivot table. This plugin currently supports line, area, and column charts as the sparklines.
Steps
The following steps will walk through the process of adding the new plugin.
STEP 1 - ADD THE PLUGIN
Download the attached .zip file, and extract it to the following path "[Sisense installation path]\PrismWeb\Plugins". If you are using version 7.2 and higher unzip the contents into your C:\Program Files\Sisense\app\plugins\ folder.
STEP 2 - CREATE THE PIVOT FORMULA
The main challenge with sparklines is that they require more data than just what's displayed in the pivot table. In order to specify the extra dimensions needed, you can create a multi-pass aggregation function, that this plugin will use to generate a new query. The screenshots below show how to create a formula that includes the extra dimension needed to get supporting data used by the sparkline. Please note, you can use either a measure or starred formula for the last item in the sparkline formula
STEP 3 - DEFINE YOUR SPARKLINE
Click on the settings menu of your formula, and then the sparkline option. You should see a menu listing the available chart types.
If you change your formula, you must recheck the sparkline box. Also, you can set the color of the sparkline, similarly to how you would for any other value in the pivot table.
NOTES
- This sample has been confirmed working on Sisense version 7.1, and should be backwards compatible with previous version
- This plugin supports only pivot tables with rows, not dimensions as columns
- This plugin does not support exporting to PDF, XLS, or CSV
- This plugin leverages highcharts to render the sparklines, you can customize the look/behavior of the sparklines by editing the chartTypes object within charts.js
