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...
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...
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...
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...
![83227784_3726975083979609_8570336295451099136_n[1].jpg](/t5/image/serverpage/image-id/602i3D789947CB5B424B/image-size/medium/is-moderation-mode/true?v=v2&px=400)
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...
*****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 ...
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...
This is a Sisense.js Demo built with React, which includes functionality such as changing filters and dashboards with native web components. This can be used as a reference or starting point for building and customizing Sisense.js applications with ...
Analytical Need In this article, we can find a suggested approach on how to better maintain our Sisense environment. The current tools and methodologies take us to an encumbering and challenging work. By creating a dedicated dashboard to show our env...
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...
Sometimes we'd like to define variables to hold specific metrics and use them throughout the dashboard in several places, with the ability to change / control them in one repository without the need to manually change each formula or widget. A good ...
Introduction: By using the re-branding API you can replace the default homepage with a specific dashboard. (For further explanation of the branding functionality please read this article.) Keep in mind you need to leave only what you change ("string...
If you need to color columns in a column chart based on a different formula you will need to use the following solution. For this example, we will color the columns that calculate [Total Cost] for the [City] by another value, that is calculated by t...
This page is intended to keep a focus on Dashboard design in terms of: Planning Implementation User experience and functionalityDashboard training for end users Dashboard Planning Dashboard planning goes hand in hand with project planning, and will ...
Issue In Survey Data you might have 10th or even 100ds of parameters per questionnaire, Sisense suggest transposing all the parameter into one column (See article). Once you do that you might run into an issue filtering questionnaires that answered ...
