Download using the attachment below Introduction A common requirement when performing grouping and aggregate operations, is to include all dimension values in the group irrespective of the contextual filters applied on the transaction table. ...
The following solution is relevant to both Pi and column charts. Illustrations were supplied for Pi charts only for simplicity. If you'd like to remove the percentage value in the tooltip hover menu as illustrated below:For Pie charts:Edit widgetEdit...
Download: Center Zero Intersect Introduction This article explains how to center the zero intersect of a bar chart. This can be done manually be setting the axis min/max, but this solution provides a way to do this dynamically.StepsSTEP 1 - ADD THE ...
The widget script below can be used to change the opacity of scatter chart markers, either for specific series (colors) or for the entire chart (Last Tested on 7.1.1.10089).//Series you want to adjust. Leaving this array empty will adjust all series ...
One of the requests that have come up is the ability to show percentages on a tree map without needing to hover over the widget with a tooltip.The following code overwrites the 'name' displayed with 'name' + percentage to three decimal places:The pe...
Visualization ChallengeUnderstand the rank of each category by total or total contribution in stacked visualizations.SolutionEdit the order of stacked bar or area charts by the total sum of each category.Viz ExamplesWidget without order assigned to c...
How to Change the Pivot Header Row Style with TransformPivot This solution is based on Pivot 2.0 API supported in Sisense version L8.2.1 or later (not supported in Sisense for Windows). For this solution, we shall use cellStyle from Pivot 2.0 API. T...
This widget script will add a gradient to the widget's area spline charts.Configure opacity and RGBA colors as per comments.widget.on('processresult', function(a,b){ // Set colors for the gradient in the "stops" section below. // The top color...
Download: Filter Drill DownIntroduction We will introduce how to filter, drill down fields on a widget basis. Steps: Step 1:Download the attached plugin and place in .../PrismWeb/plugins, if plugins folder does not exist please create it. If you are ...
The 'drill-into' function on the widgets will add the recently used fields (from the datasource fields and not the hierarchical members) on the context menu of the widget which may distract the users who are using it.When there are hierarchies enable...
Introduction This article explains how to set up a jump to dashboard popup window with a dynamic elasticube Steps Install the Dynamic Elasticube pluginInstall the Jump To Dashboard pluginAdd the following script to the target dashboard script: va...
Auto-Refresh Dashboard based on Elasticube Build:This dashboard script queries the elasticube on the server, and checks to see if a new build has completed. As soon as a build is finished, the dashboard will auto-refresh, and all widgets will be base...
Disclaimer: This is the community solution that doesn't go through a proper testing and support cycle and is not officially supported. In recent times JS libraries markerclusterer.js and infobox.js used for this plugin development are not present on...
When you look at the script, you'll see some values that come from the dashboard:MedianPerc: This is the median percent (our X-axis is in percentages)SD1: This is a calculation to get to +1 Standard DeviationSDMinus1: This is the calculatoin to get t...
Description The Pivot2 Styler add-on enables you to hide columns and customize the style of Pivot2 widgets. Hiding Pivot2 widget columns can be used for advanced sorting. The Pivot2 Styler add-on is available for Sisense for Linux version L2021.3....
Edit the widge script.Copy and paste the code below and set the category name and color (hex format) desired.widget.on('ready', function(se, ev){ var e = element; var chart = e.data('hc'); var categoryName = "Beverages"; var data = chart.seri...
Introduction This article will show how to modify the style of the legend in you widget.Steps Open you widget in Edit mode.From the Options Menu choose "Edit Script" to open the script editor.3. Copy and paste the following code into the script edit...
Changing the style properties of a pivot can be done via the dashboard script.It is also possible to change the properties of the values only if needed.Open dashboard script editorpaste the code below in the editorAll the pivots will be affected by t...
Plugins are components that add specific features and extend the functionality of a core product. Sisense Web Application includes a plugin framework that allows you to easily add new customizations or modify existing functionalities according to you...
WiserFilterWidget on GitHubDownload: WiserFilterWidget (click the latest .zip) PURPOSE/BENEFITSWhile filtering is available to dashboard designers in the right-side filter pane, this pane may be hidden or otherwise unpreferred or unavailable to dashb...
