The following Python script allows exporting dashboard data to CSV files. The script will export each widget to a separate CSV file. This new version of the script uses Sisense's REST API an eliminates the direct connection to the mongodb. Important:...
Introduction This post describes the process for creating a new plugin that extends the functionality of the dashboard user interface. There are several different aspects that you can modify, this document will focus on the most common use cases. ...
Introduction This document outlines the process for overriding an existing chart with a Highcharts Donut Pie chart. For a more robust solution, it is recommended to create a custom plugin as that would allow non-technical users to create charts wi...
Introduction The code below allows you to color the x axis labels for each category of a bar chart based on the color of a secondary series. It also then hides the secondary series from being plotted. Steps STEP 1 The first step is to create a bar c...
1) Open the Developers Console (press F12 in Chrome.) 2) Navigate to Console tab: 3) In the console prompt line, enter the following script and press Enter: 4) prism.activeDashboard.widgets.toArray() 5) This results in a printout of an object with ...
Introduction In this post we will demonstrate how to add a twitter feed within a dashboard. Business Case Viewing the latest tweets from key people in your industry may be an enhancing capability. Example Embedded Twitter Widget that is shown below...
Analytical Need We have multiple sources for our measures and multiple sources to slice & dice these measures. Modeling Challenge How do we build a schema that will enable us to perform our needed analysis? We will need to connect all of our t...
Analytical Need There are cases where we want to analyze our measures as a comparison between periods of time. For instance, ee want to know how did our measures behave on January this year vs. previous year. This means that we have to put down in...
HOW TO TROUBLESHOOT BUILD FAILURES (Linux OS)Building an ElastiCube imports the data from the data source(s) that have been added. The data is stored on the Sisense instance, where future dashboard queries will be run against it. You must build an El...
BloX - A Technical Introduction To start, download the attached file ‘BloXTutorial-Styling.dash’ file and import this into your Sisense environment. This dashboard uses the ‘Sample Ecommerce’ data model and contains all iterations of the BloX widget...
Controlling JAQL Timeout | Linux Please note this article is for Linux users. What You’ll Learn Main Properties of a JAQL requestWhen the JaqlPool parameters for managing JAQL request timeouts are triggeredWhen to change the default values for these...
Websocket Functionality Within SisenseIntroductionSisense uses the WebSocket Protocol to load dynamic content within the platform. It’s important to remember that the WebSocket Protocol is simply an upgrade of HTTP(S) traffic, relying on the same bas...
Advanced Configuration Control via API Calls Frequently, there are situations when a user is required to change some Sisense parameters when access is not available due to a wrong configuration, or it is required to automate switching of some config...
Viewing Widget JAQL Queries There are a large number of reasons you may want to view the query(ies) being sent from a dashboard widget, most of which are performance or data quality related. This article explains two methods that can be used indepen...
Sometimes we would like to hide a column in our pivot table so we will be able to apply a specific logic or order the table by a column without displaying it. The following script will allow you to hide the needed columns in your Pivot table. To imp...
Introduction The following article discusses how to assess the quality and adoption of your dashboard. Table of Contents IntroductionTable of ContentsHow to Measure a Dashboard's Quality?Planning Makes PerfectAssessing a Dashboard's QualityThe "Prac...
There are multiple factors that affect dashboard performance. A dashboard consists of widgets, plugins, scripts, filters, and, most important, queries. In this article, we will examine how to diagnose and pinpoint what may be slowing your dashboard d...
Introduction The following document provides code snippets for customizing a Pivot 1.0 widget Table of Contents IntroductionTable of ContentsHow to Use This Page?Widget CustomizationsLayout #1 - Single Row, Single Value, No ColumnsLayout #2 - Single ...
This article will show you how to quickly color a pivot table into two sections: by Row and by Value1. Build your pivot table. 2. In the widget editor, add the widget script below. Information on how to add a widget script here: Dashboard and Widge...
If you wish to turn this dashboard : into this: Please copy & paste this dashboard script: dashboard.on('widgetready',function(d) { //Card view $('.dashboard-layout-column').css('background-color', '#F0F0F0'); $('.dashboard-layout').c...
