I am working on a new implementation of Sisense. Dashboards and reports are built using a live model. As part of testing, I notice that the dashboard share does not contain the dashboard subscription option. What settings or functions can I look at t...
Problem: One of our teams uses Sunday as the calendar week start day, which is different than our other teams that use Monday as the week start day. I have created a special column in a date dimensional table where the date reflects Sunday and am usi...
Hello, I am trying to create a column that links to our gift pages on our crm. The problem is when it goes to the url, it has the donor data at the top from the last viewed donor, instead of the donor data of the gift. Our solution is first to open t...
Hi all, Running Sisense L2022.1. I'm getting a lot of requests for expanding and collapsing data within pivot tables. Is this possible?The problem with the drill-down functionality is that it also filters on the value you selected, sometimes I don't ...
Hi all, We are facing a requirement about the Grand Total calculation in a Pivot table. The scenario is the following: W ehave a row with the YTDSUM of a metric, and a filter of time.It works as expected. But in the total of this column, we need the ...
Hello, Is there a way to schedule a "Changes only" build in Sisense? As per the article below, it appears that there is no option to select what type of build I want to run. By default it runs a "Replace All" build at the scheduled time. I wish to ru...
Dear Sisense Gurus, Is this possible? How can I go about using percentile (mean + (Z-score*standard Deviation)) as a way to bucket the columns in a bar chart. Thank you for any and all help! -Alec
Afternoon! I am trying to create a sunburst chart that looks at different exception types (which is the inner circle) and how long each employee averages clearing those exceptions (which is the outer circle). Each outer ring shows the correct average...
It is possible to add button(s) to widgets for various purposes like to change visualization type, show or hide value labels in chart, open a url and much more. Below script is to add button to show/hide value labels in widget: displayValue = false w...
Hi, I currently have conditional formatting for a blox widget. Based on the percentage change, it changes the font color (green or red) and a up or a down arrow. However, instead of the arrows I want a textblock with a background color. I tried takin...
I'm having trouble finding good documentation on Advanced Filtering. If I'm looking at the below, this will return 1 date, 7 days ago (July 19th). I was wondering, is there a way to manipulate this filter to return multiple days at set intervals. For...
Is there an easy way to pull some of the user data that's stored in Sisense into an elasticube? Specifically what I'm trying to do is pull a table of user IDs and names for all of our users with Sisense accounts and use this data in a dashboard. I ca...
Hi,I was wondering if it was possible to comment out text in the widget formula editor. I have tried various options (// , /*, --, etc) but none of them works. Perhaps its not possible, however someone might have another solutionHamza
Sisense documentation lists Data Dictionary as one of the product features. Documentation for that is shown here: Creating Data Dictionaries. However, this feature only supports the creation of table and column description information. This is helpfu...
I have currently implemented the benchmark target line from https://www.binextlevel.com/post/add-target-benchmark-line-to-a-chart-in-sisense I was wondering if it's possible to have a user input using Blox to set that benchmark line instead of using ...
