Hi,I want to display a selected item on a text filter as a simple text on dashboard. for example: I have a filter called account name and I filter it to the name 'Google', I want 'Google' to be displayed in the form of text widget on the dashboard.Th...
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...
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...
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...
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 = fals...
Hi, I am trying to sort the bar chart from Low to high and from left to right. The stacked bar need to be sorted as well. Attached the screen shot with Thanks, Sai
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...
There is a dashboard filter of months. If month jan’22 is selected, i need to get data not only from jan’22 but till jan’22. Currently my dashboard is returning only jan’22 data. Is there is any script for this implementation?
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
Hi all I have a dataset containing numeric values for audit scores, a date field, and an auditee field. I can create a line chart with the score over time, however the data is "gappy" because the frequency of these audits is inconsistent. This pres...
Hi everyone. I'm trying to find a way to order the columns of a pivot in ascending order, based on the number included in the description of the header. Below you'll find a screenshot with the content of the headers. The current order is "+150", "1-2...
