I have a pivot table with a few columns with JTD enable to another dashboard. However, I want the OldestNoteDateofVisit column to not pass as a filter. Is it possible to exclude specific column to be passed as a filter in JTD?
Here is a script to convert a Column chart to WordCloud chart Reference: https://www.binextlevel.com/post/wordcloud-from-column-chart Create a Column chart. It should contain only one field as category and one Value panel and apply below script. (fun...
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...
Is there a way to select 1 particular slice of a pie chart and move the rest to "Others". By choosing the Select 1 slice option, it picks up the highest value and moves the rest to others. I want to be able to pick another category of the slice.
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.
Hi. Im working on new layout of dashboard. I use some small indicators , blox, textboxes etc. and just realized I cannot add widget to row where there is already 8 widgets. This seems to be maximum limit. Is there script or server property I can use ...
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 las...
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...
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?
Hello, I have a requirement to add a URL to the widget title so the users will be redirected to a page that will give them more information about the widget data. Can I achieve these 2 things for all widget types ? NOTE : I have already gone through ...
The premium Report Manager plug-in has very limited documentation on using Templates. There is a "out-of-the-box look and feel feature" mentioned. Q1) Is this the API Report Manager Template? Q2) Report Manager allows multiple templates to be created...
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 granularity s...
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, Has anybody managed to use a BloX action button to call the Sisense API, such as build ElastiCube? I have tried searching online and see that I need to use type "Action.Submit", action is "post" and provide the url and data parameters. I think...
