Does anyone have a script or a way that I can add a pop-up to a dashboard? Basically, I want a pop-up on dashboard load that says something like : "Updates in progress". This is to alert viewers that there are changes being made.
Hello, I have used the following javascript before to modify results within a column of a pivot table, but when I try to do the same for column table objects I get strange behavior. Here is the javascript I use to modify the pivot table. widge...
We are trying to standardize the folder structure we use for storing dashboards to include different folders for each department's dashboards. The problem I'm running into is that we might have multiple Dashboard Designers working on dashboards for t...
I need to create a dashboard filter that will filter the Closed Date In Last 180 days OR if Closed Date is NULLWould you know how to include the OR Condition in a Dashboard Filter? I tried using the Advanced formula below and some variations of this ...
Hi,I am trying to create a jaql query that replicates what I can filter on the dashboard using the UI - filtering a date range to 'This week and last week'. But in the jaql editor, it looks like 'weeks' are not accepted as a date level, so I was wond...
Hi, I need to create a healthcare pivot table with three columns. Provider Name, number of claims by provider, and earliest date of encounter for each provider. Something like above.. However this being a pivot table is it possible to achieve the l...
In my Blox Code, if the "Panel" value is not returned, the display shows No Results. Is there anyway to display a 0 instead? Blox Code is as below: { "style": { "verticalAlignment": "center" }, "script": "", "title": "", "showCarousel": true, "caro...
Hi All, Is there a way when using the inbuilt PDF exporter for the Dashboard as a whole that it shows the entire set of data in all the rows and not just 1 page worth? I have tried making it so it isnt paginated but i still only get the first page of...
I'm using the BloX transposed pivot template below: https://support.sisense.com/kb/en/article/transposed-pivot-table-with-blox How can I add a column on the right that shows the grand total of each value?
When creating a formula in Pivot to get number of days between two date fields, using the DDIFF() function, I get the following message when the widget errors out. function date_part(unknown, integer) does not exist Note, these are date only fields a...
It is possible to write custom scripts to change the formatting of a Blox widget when displaying in the Sisense Mobile App?
Hi! I have a pivot table and would like to grey out some of the rows. These rows are for future weeks, or dates that are larger than the current week. I would rather grey out those rows instead of removing them, does anyone know how to do this? Thank...
Hello, I am very new to sisense and have a typical requirement so I am using blox buttons to change the granularity in a widget In the same widget I would like to show comparisons in tooltip for last month, last quarter depending on the granularit...
I have a set of data that gives out a Numerical Number for MAX(Score). I want to count the number of each record that falls into a set of ranges. 100-96, 95-90, 89-85, 84-80, 79-75 and <75 My case statement is starting like this: Case When (max([Scor...
Hello!I'm looking for a way (most likely a plugin) to allow Dashboard users (not owners, viewers or designers) to have more editing capabilities when extracting a report as a PDF. Some of our users woudl like to have control over which widget is disp...
