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 ‘Gr...
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 Sometimes we want to display 2 dimensions and one measure in a widget. Ordinarily we will use a pivot table for this purpose. A pivot table may be very nice & good but it doesn't allow us to filter the dashboard based on values from ...
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 ...
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 betwee...
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....
Analytical Need For a metric, I need to calculate the month difference between the min and max date of purchase for each brand in my dataset. I want the dates to be dynamic in respect to filtering, etc. I am using the attached .ecdata and .dash fi...
Question Is there any way to get the views to execute sequentially instead of simultaneously? How does the dashboard in Sisense execute the queries? Answer The Sisense client application does attempt to send out all queries (one per widget) at onc...
Question: How to see the latest date in the Pivot? Answer: You need to change the date to an integer. Then I used the script in the comments in a previous post, and was able to request results. This is the script we used var m_names = new Array("J...
