cancel
Showing results for 
Search instead for 
Did you mean: 
intapiuser
Community Team Member
Community Team Member

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 latest version of the plugin from this link and extract the enclosed folder into the plugins folder:
/opt/sisense/storage/plugins/
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. 
Version history
Last update:
‎02-01-2024 09:41 AM
Updated by:
Contributors
Community Toolbox

Recommended quick links to assist you in optimizing your community experience:

Developers Group:

Product Feedback Forum:

Need additional support?:

Submit a Support Request

The Legal Stuff

Have a question about the Sisense Community?

Email [email protected]

Share this page: