Add Images from External Table Instead of Labels in Pie ChartDisclaimer: Please note that this blog post contains one possible custom workaround solution for users with similar use cases. We cannot guarantee that the custom code solution described in...
Metadata Plugin - Grouping Provider Example (Multiple Translations for Different User Groups) This community post will provide a great example of how to implement a grouping provider in the Metadata Plugin. This solution covers the following case: ha...
How to Show a Secondary Value in an Indicator Based on a Date FilterThis article provides an example solution on how to show a secondary value in the Indicator widget based on the date filter. This allows you to have multiple dashboard filters but sh...
The following script can change the labelwidget.on('ready',function(e, args){ $('[id="' + args.widget.oid + '"]').find('span:contains("Grand Total")').text("YTD"); $('widget[oid="' + args.widget.oid + '"]').find('span:contains("Grand Total")').te...
How to Remove or Hide the "Analyze It" Button from a Specific Widget This article explains how to remove or hide the "Analyze It" button from a specific widget. Please note if you would like to remove the button from all widgets in all dashboards, y...
How to Add a TimeStamp to a Widget Title This article provides directions on how to add a timestamp to a widget title using JavaScript. This could be useful in cases where a user needs to calculate specific metrics in a Live Data model (the script a...
Introduction This post will give the JavaScript necessary to format the Widget Title.Purpose/Benefits When formatting your dashboard, manipulating the Widget Title to match your other formatting will give the dashboard a more personalized feel.Exampl...
IntroductionThis post and it’s JavaScript will Allow you to customize the data point ‘markers’ on a line chart to whichever image you would like to display. Purpose/Benefits Add some creativity to the standard Line chart by adding an image of your ch...
IntroductionAdding a visual representation to your measures will allow you to read the bigger picture in a glance, recognize trends and have better user engagement to your dashboards.Comparing data columns or even different values within the same co...
Download: Latest version (Sisense v7.0+), legacy version (Sisense v6) Introduction This article explains how to create filter bookmarks using Sisense. Purpose/Benefits It is easy for dashboard users to add/update filters on a given dashboard, but an...
This article will cover two methods you can use to connect Python to the Elasticube. Method 1: Using ODBCMethod 2: Using the REST API Method 1: Connect to the EC with ODBC Download Sisense ODBC This method will require you to download the ODBC ...
Introduction This script displays a total line over your stacked column / bar chart. It also works with the classic (side by side) grouping.Instructions Create your chart and add the following script. Edit > Options Menu > Edit Script.Note: You can m...
Here is an example of a widget script you can use to create a Waterfall Chart using the standard Column Chart widget.First, create a column chart with multiple measures/values.In the example below I have a starting price, and then two adjustments (th...
IntroductionThis article will explain how use MAX() / MIN() functions on date fields using Pivot2.Business CaseSometimes we need to present the last / first date that a certain action occurred in or planned to.ExampleFor example, we want to present w...
Apply the following script on a table with aggregation's widget script to create a row with Grand Totals.This will be considered as just another value and may not always appear on the first page of results if results are paginated.widget.on('processr...
How to Get a Vertical Line in the X-Axis in a Line Chart This article explains how to get a vertical line in the x-axis in a Line chart and covers 3 use-cases: 1. A vertical line on a maximum value (metric). 2. A vertical line when x-axis category ...
In order to sort both axes in the Scatter chart you might need to use the following script under the "Widget Script" levelvar xOrder = 'asc' //also, this value can be desc var yOrder = 'asc' widget.on('beforeviewloaded', function(scope, args) { ...
Use case: Capturing what the end-user has selected to filter. Then writing back the filtered selection to the app mongodb for further analysis of customer dashboard interaction.Instructions: Add the code below as a dashboard script.Notes: Current scr...
Conditional formatting of background colors in pivot tables is one of the best ways to draw attention to numbers, but still provide a clean visual. The use of data bars creates a lot of visual noise, whereas background colors are subtle and act more...
On article Uploading Files Locally Using Rest (Linux) we saw examples of how to automate the upload of files to File Management. This article describe methods to automate the management of files on File Manager. Compatible with Linux Version <= L...
