Knowledge
Note: We are actively completing a knowledge migration process. This space will grow over the next few months as this work is completed.
cancel
Showing results for 
Search instead for 
Did you mean: 

Knowledge Base Articles

Turn a dashboard into a card view - Spaces between widgets

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').css('background-c...

Community_Admin_0-1634653060998.png Community_Admin_1-1634653061004.png

How To Create & Use Variables

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

Replace the homepage with an embedded dashboard

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

Community_Admin_0-1634652709740.png

Replace Values with Text - Pivot Table Widget

Introduction The following enables to change the value in pivot tables to specific strings, while allowing the use of conditional coloring as normal. Step 1 - Add The Following Script To Your Pivot's Edit Script widget.on('ready', function(){ $('td[c...

Community_Admin_0-1634651775311.png

Color a column chart based on another formula

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

Community_Admin_0-1634651516418.png Community_Admin_1-1634651516661.png Community_Admin_2-1634651515740.png Community_Admin_3-1634651516092.png

Dashboard Planning and Implementation

This page is intended to keep a focus on Dashboard design in terms of: Planning Implementation User experience and functionality Dashboard training for end users Dashboard Planning Dashboard planning goes hand in hand with project planning, and will ...

Community_Admin_0-1634627284977.png Community_Admin_1-1634627285046.png

Create an AND Filter For Survey Data

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

Community_Admin_7-1634627102566.png Community_Admin_8-1634627102575.png Community_Admin_9-1634627102548.png Community_Admin_10-1634627102561.png

Reset to Default Filters Button using BloX

This article will explain how to create reset to default filters button in BloX This helps in case you want to provide this icon functionality on the dashboard and not just in the Filters panel. Create a new custom action with the below code: *Make s...

Community_Admin_0-1634626087594.png Community_Admin_1-1634626087829.gif Community_Admin_2-1634626399819.png Community_Admin_3-1634626399665.png

How To Create Customized "Time Frame" Radio-Button Filter

This post will show how to create an easy to use Radiobutton filter (single selection type) with a list of predefined custom time frames. The created time frames can also be used for breaking by charts or pivots, providing a visual comparison between...

Community_Admin_0-1634625933508.png Community_Admin_1-1634625933581.png Community_Admin_2-1634625933665.png Community_Admin_3-1634625933749.png

Passing Dashboard filters by URL Parameters

This article describes how the append dashboard filters as URL params to apply scope automatically to embedded dashboards. The example below shows how to apply members as filters. If you already have dashboard filters defined, you can write the follo...

Automatic switching between dashboards

This article explains how to automatically switch between dashboards every predetermined amount of time. This might come useful, when you have multiple dashboards that you want to be presented in a cycle on a monitor to reflect updated data\records. ...

Restoring dashboards default settings automatically

In this post you can learn how to automatically 'Restore Dashboard' on each page refresh or opening, this setting will always restore the dashboards initial published state for your viewers and designers. This can be used for cases where you would li...

Labels
Community Toolbox

Recommended quick links to assist you in optimizing your community experience:

Developers Group:

Product Feedback Forum:

Need additional support?:

Submit a Support Request

The Legal Stuff

Have a question about the Sisense Community?

Email community@sisense.com