Download: Parameters Widget
This article explains how to add user input boxes for use as parameters in Widget Formulas.
This plugin is an extension of an earlier plugin, but adds the ability to have multiple parameters in the same area. It also provides an option for setting default values for each parameter.
The following steps will walk through the process of adding the new chart type and creating a sample.
Step 1 - Add the Plugin
Download the attachment and unzip the contents into your C:\Program Files\Sisense\PrismWeb\plugins\ folder. If you are using version 7.2 and higher unzip the contents into your C:\Program Files\Sisense\app\plugins\ folder. If the plugins folder doesn't exist, just create it. After those files have been unzipped there, you may also have to restart the web server. Now, when you create a new widget the parameters widget should show up in the list of options.
Step 2 - Add the default values into the Elasticube
Edit the included Excel file to have the number of parameters you'll need, as well as the default values for each parameter. In the screenshot below, we are adding in support for up to 5 numeric input parameters. Once this structure is defined, add it to your Elasticube and perform an Elasticube build. You should not connect this to any other table, it should stand alone. This doesn't have to be driven from the included Excel sheet, but you should make sure this table is named Parameters in the Elasticube.
Step 3 - Create the Widget
On your dashboard, click the Create Widget button and select Advanced Configuration. Next, select Parameters from the chart types menu. Under ITEMS, add in 1 or more fields from the Elasticube's Parameters table. You can override the field names, either in the Elasticube or just the labels in the dashboard. Each input box will default to the values from your Excel sheet, but users in the dashboard will have the option to override the values. You can also adjust whether the dashboard updates with these new values immediately after entering them, or if you want the end user to set all the parameters first and then click an UPDATE button. When finished, click the APPLY button to save this widget to the dashboard.
Step 4 - Reference the Parameters in Formulas
At this point, users can update the inputs but you need to reference these parameters within Widget formulas in order to take effect. Create/edit a widget's formula and add in a reference to a field from the Elasticube's Parameters table. The formula editor will default to a SUM of this field, but rename it to @fieldname.value . For example if your parameter field is named P2 in the Elasticube, then it should be renamed to @P2.value. In the widget editor the formula will use the default values, but once in the dashboard it should take on the user-input values instead.
- This plugin does not save user inputs, each dashboard load will start with the default values.
- If you want to name your Parameters table something different, then you will need to update the included config.js file settings.table property to match.
- This example used an Excel sheet to manage the default parameter values, but these can be persisted anywhere (database, google sheet, etc).
- This plugin is meant as a replacement for the original floating input parameters and parameters plugin combination. If you want to use this one, please remove the other plugins from your Sisense installation first.
- UPDATE Aug 8, 2016 - Updated to work with Sisense v6.4
- UPDATE Dec 14, 2016 - Updated to work with Sisense v6.5
- UPDATE Sep,14, 2018 (Ronen Avidor)- Update to work with version 7.2 and also leave backward compatibility to earlier version
- UPDATE Feb 19, 2019 - added support to save parameters between sessions
Please sign in to leave a comment.