Knowledge Base
cancel
Showing results for 
Search instead for 
Did you mean: 

Knowledge Base Articles

How To Troubleshoot Build Failures (Linux OS)

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...

Krutika_0-1659023295057.png Krutika_1-1659023295088.png Krutika_2-1659023295249.png
Krutika by Sisense Team Member
  • 7545 Views
  • 15 comments
  • 6 kudos

BloX - A Technical Introduction

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...

alexfrisbie_0-1675282038054.png alexfrisbie_1-1675282038020.png alexfrisbie_2-1675282038037.png

Websocket Functionality Within Sisense

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...

Wyatt_0-1669658656681.png Wyatt_1-1669658656667.png Wyatt_2-1669658656712.png
Wyatt by Sisense Team Member
  • 1283 Views
  • 0 comments
  • 2 kudos

Advanced Configuration Control via API Calls

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...

vsolodkyi_0-1668468073706.png vsolodkyi_2-1668468073717.png vsolodkyi_3-1668468073720.png
vsolodkyi by Sisense Team Member
  • 621 Views
  • 0 comments
  • 0 kudos

Viewing Widget JAQL Queries

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...

Darwin by Sisense Team Member
  • 1949 Views
  • 0 comments
  • 0 kudos

Hide a column - Linux Pivot

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...

Community_Admin_0-1634394440994.png Community_Admin_1-1634394440939.png

Assessing the Quality of Your Dashboard

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...

Ophir_0-1643746737747.png Ophir_0-1643270125878.png Ophir_1-1643270192433.png Ophir_3-1643270522581.png

How to Diagnose Slow Dashboard Load Time

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...

Krutika_0-1651781532458.png Krutika_1-1651781532454.png
Krutika by Sisense Team Member
  • 3590 Views
  • 0 comments
  • 8 kudos

Customizing a Pivot 1.0 Widget

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 ...

343efa6e-cbb4-4f8b-a00f-2e14afc820f9.png f6146f7f-14fb-489b-a56d-2dff68792cd8.png 2173460c-0eaf-4166-a680-4691b4af82c4.png 7c928253-4473-4da6-8e0f-b85b0404ce68.png

Add tooltips to a Pivot table

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...

Screen Shot 2022-04-19 at 14.03.05.png
edselv by 9 - Travel Pro
  • 2133 Views
  • 0 comments
  • 1 kudos

Format Seconds to Time (HH:MM:SS) in a Pivot Table

This article will explain how to convert seconds into date-time format on a pivot table. 1. Ensure your seconds column is of type integer.2. In the widget editor, add the widget script below. Information on how to add a widget script here: https://si...

Screen Shot 2022-03-31 at 14.11.55.png
edselv by 9 - Travel Pro
  • 3438 Views
  • 0 comments
  • 2 kudos

Stacked Bar & Single Bar

Question: I want a Column Chart with 3 metrics- 2 of the metrics are stacked while one remains a single Column. I would even consider doing the 2 metrics stacked and the 3rd as a line, but if I choose 'Stacked' as my Column Chart Type, the ability t...

Community_Admin_0-1634257847586.png

Taking your Dashboard to the Next Level

Introduction The following article discusses how to take a good functional dashboard to the next level. It mentions the relevant Sisense features available to help achieve your next goal.   Table of Contents IntroductionTable of ContentsDashboard Co...

Ophir_Buchman_1-1644436248334.png 83227784_3726975083979609_8570336295451099136_n[1].jpg

Dynamic Widget Scripts

Download: GitHub Link Version: 1.0.0 Introduction: This article explains how to install the plug-in and how to interact with the js and configuration file. Purpose/Benefits: This plug-in will add or change change the current script applied to widget...

Screen Shot 2021-12-27 at 12.34.05.png Screen Shot 2021-12-27 at 12.36.06.png
edselv by 9 - Travel Pro
  • 1317 Views
  • 0 comments
  • 1 kudos

Changing the ‘Grand Total’ label on pivot table

*****Windows Only****When having a pivot table which contains more than one value and present the grand total for each of the values, the total row is called “Grand Total”In some cases you can be faced with users’ requirement for changing the ‘Grand ...

Community_Admin_0-1634626611002.png Community_Admin_1-1634626611013.png Community_Admin_2-1634626610901.png Community_Admin_3-1634626610927.png

Customizing an Indicator Widget

Introduction The following document provides code snippets for customizing an indicator widget. Table of Contents IntroductionTable of ContentsHow to Use This Page?Widget CustomizationsThe “Simple” Numerical WidgetThe “Ticker” Numerical WidgetThe Ga...

b5485102-44cf-41b3-badf-edf337b8d7b9.png 6e733207-031c-489e-ba47-df36b86e0c29.png bab45ba4-551a-4f86-873a-81689e3e4ba4.png d01d5297-07a6-492c-9b4c-ba3abcf91f1d.png

Chart Type - Radial Bar Chart In Matplotlib (Python)

    Here's a script that takes a data frame with two values, the current and benchmark, and returns radial bar charts to plot progress toward a goal. You can also choose a color using the color_theme parameter that takes values 'Grey', 'Purple, 'Bl...

Community_Admin_0-1635242545447.png
Labels