How to hide the "Switch to view mode" button based on a role This article provides an example JavaScript snippet that could hide the "Switch to view mode" button based on the user's role. How to use it? First of all, you need to get the role name y...
Creating a Year-Over-Year Chart in Sisense Summary This article addresses the issue of creating a year-over-year comparing chart in Sisense that shows a Key Performance Indicator (KPI) for the current calendar year against the previous calendar year...
How to record a .har file and identify if specific requests are present in logs How to record a .har file Open Chrome and go to the page to be recorded. Click the More Actions menu (...) to the right of the toolbar and select More tools > Developer t...
How to check specific pods CPU/memory consumption in Grafana Instructions1. Open Grafana from Admin page ‘Monitoring’ section [ALT text: A screenshot of a web application interface showing the "System Management" section. On the left side, there...
Show full date format in the pivot or table widget If you want to show the full date format, like 2024-11-20 18:00:00 in the Pivot or Table widget, please do the following: 1. Go to the elasticube find the Date column and duplicate it ALT text: A us...
Enable/disable field suggestions in the NLQ (Simple Ask) For the latest version of Sisense like L2024.x to have a field suggestion, you need to enable it. First of all, what is the field suggestion, as illustrated by the picture below, if...
Connecting Sisense Git Version Control with Bitbucket Summary This article addresses common steps needed when establishing a connection between Sisense Git version control and Bitbucket. It provides step-by-step instructions on how to generate and u...
Converting an Existing Sisense Widget to a Dynamic ComposeSDK Widget Component Using either the widget Sisense API's, or the Sisense widget JS API object, it is possible to determine all components and parameters of a widget required to create an eq...
Disabling the "Custom Filter" Feature for End-Users This article provides a solution for administrators who wish to disable the "Custom Filter" feature in their applications to prevent confusion among end-users. Instructions The "Custom Filter" feat...
Question How to Calculate YTD by Month in a Pivot Table? Answer If you want to show YTD by Month next to your monthly amount you can utilize the "Running Sum" Quick Calculation. If you want to show this next to the monthly amount, just bring in th...
Symptoms Sometimes with a pivot table full of many columns with zero and only a few non-zero values, you want the zeroes to display as empty-string. That way the nonzero values really stand out. (This is the opposite of this: Solved: nulls to 0 in...
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 f...
Analytical Need Sometimes we wish to see how we are performing in the last x months and comparing that to the previous parallel period. For example, we wish to see how we perform from Sep last year to Aug this year and compare it with Sep 2 years ...
While Sisense provides powerful analytics and simple report printing, if pixel perfect report printing is required, additional tools like SAP Crystal Reports must be used. Purpose/Benefit Pixel Perfect reports can be designed which use data from a Si...
Trend analysis enables users to compare actual totals against measures derived from the data. This will enable users to compare actual results against derived amounts, and even project those amounts into the future. This example will use a simple ave...
Introduction This document outlines the process for overriding an existing chart with a Highcharts Donut Pie chart. For a more robust solution, it is recommended to create a custom plugin as that would allow non-technical users to create charts wi...
Introduction The code below allows you to color the x axis labels for each category of a bar chart based on the color of a secondary series. It also then hides the secondary series from being plotted. Steps STEP 1 The first step is to create a bar c...
1) Open the Developers Console (press F12 in Chrome.) 2) Navigate to Console tab: 3) In the console prompt line, enter the following script and press Enter: 4) prism.activeDashboard.widgets.toArray() 5) This results in a printout of an object with ...
Introduction In this post we will demonstrate how to add a twitter feed within a dashboard. Business Case Viewing the latest tweets from key people in your industry may be an enhancing capability. Example Embedded Twitter Widget that is shown below...
Analytical Need There are cases where we want to analyze our measures as a comparison between periods of time. For instance, ee want to know how did our measures behave on January this year vs. previous year. This means that we have to put down in...
