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...
How to create a list of users with a current role based on the usage analytics elasticubeStep-by-step guide: To get a list of the users with their roles, you can use table usage from the Usage analytics elasticube. We will need the next fields from i...
How to create a list of users with a current role To get a list of the users with their roles you can use table usage. Get the next fields from it - email and userRole. In this table, you can find all the roles that these users had previously [ALT...
How to Visually Differentiate Active Filters from "Include All" (Change "Include All" Filter Style)IntroductionNote: The solution was developed on the L2025.1 Sisense version (Linux).This article addresses how to visually differentiate active filters...
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...
Question:In pivot tables, we would like to show column grand totals on top of the table and row grand totals at front. Please let us know how to alter positions.Asnwer:This script will move the grand total row to the top. widget.on('ready', function...
Render existing HTML code stored in your data modelFollow the steps below in order to URL clickable within a pivot table. Some steps are different depending on whether your Sisense instance is running on Windows or Linux. You can check whether your S...
How to Implement Linkable Text in a Widget (Linux)IntroductionThis article provides a guide on implementing linkable text to navigate to another dashboard in Sisense. The goal is to enable users to access a linked dashboard by clicking on a text elem...
Hide vertical lines on the Pivot widget To test this solution, you must create a dashboard based on any cube and create any Pivot widget. Once it is done - please go to the widget editor, click three dots select Edit Script, then paste the following ...
Auto zoom Area Map widget to a specific country on loadTo test this solution, you must create a dashboard based on Sample ECommerce and an Area Map widget based on a Country column. Once it is done - please go to the widget editor, click three dots s...
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...
Analytical Need There are cases where you wish to know for a certain point in time, how much you have accumulated up until now.This is called Running Sum.Although it is possible to use this in the dashboard, we may need to have the running sum on ea...
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...
Calculate the Average for the indicator as on the pivot with the filter To calculate the average value for the indicator and get the same result as in the Pivot, we use the simple AVG formula in both cases and get the correct result. But if we will...
How to pause widgets loadingIf you need to pause the loading of the widgets for some time, you should do the following.Open the dashboard, press edit widget, find three dots in the right corner of the widget, press on them, and choose Edit Script.Pas...
Migrating Assets Across Environments Leveraging GITSisense released its Git Integration for Linux version 2022.10. With the GIT GUI in Sisense, you can do a lot of exciting things like version control or integrate into CI/CD pipelines. I went ahead a...
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...
Users could sometimes want to compare performance on a particular time period vs the immediately preceding period. Sometimes those periods are not of a common size like months or quarters. It could be a campaign that lasts a few days, or an arbitrar...
