* * This post is a re-implementation of the old pivot1 plugin that can be found in this link * *
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.
The following steps will walk through the process of adding the new plugin.
STEP 1 - ADD THE PLUGIN
Download the latest version of the plugin from this link and extract the enclosed folder into the 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.
Please sign in to leave a comment.