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

Knowledge Base Articles

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

Configure Color of Links in Jump To Dashboard

The colors of the links or clickable elements opening the modal dashboard in a widget where Jump To Dashboard is enabled, can be changed with slight modification of the plugin. The two files that can be modified for this functionality are :The color ...

Screen Shot 2022-02-11 at 12.11.10 PM (1).png Screen Shot 2022-02-11 at 12.10.46 PM.png Screen Shot 2022-02-11 at 12.11.04 PM.png Screen Shot 2022-02-11 at 12.11.10 PM.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
  • 3591 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
  • 2134 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
  • 3439 Views
  • 0 comments
  • 2 kudos

Many-to-Many Relationships - Knowing and Avoiding Them

Introduction The following article discussed "Many-to-Many" relationships - Both expected and unexpected. It focuses on how they occur and the best practices which one can implement to avoid them.   Table of Contents IntroductionTable of ContentsTabl...

Ophir_Buchman_0-1644955176043.png Ophir_Buchman_2-1644955319311.png Ophir_Buchman_3-1644955380874.png Ophir_Buchman_0-1645470915372.png

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

How to configure Data Groups

Introduction This article will guide you on how to configure the Data Groups’ parameters based on the current performance and business requirements. What are "Data Groups”? The “Data Groups” administrative feature allows configuring Quality-Of-Servi...

Liran_Elnekave_0-1644318516409.png

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
  • 1319 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

Sisense Go-Live Checklist

Here is the Google Sheets version of the Checklist.    Complete our go-live checklist to ensure you are going into production following all of the Sisense best practices!   Ensure A Healthy Production Environment Complete Dev to Prod MigrationSisens...

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

Funnel Charts In Python

  Funnel charts are a great way to represent any drop-offs in sample size throughout a series of steps. Using a little bit of Python handiwork in Sisense for Cloud Data Teams' R/Python integration, we can easily create this chart type. A common use ...

Community_Admin_0-1635241790831.png
Labels