hello I am using dynamic buckets to show number of customers in each spend range for the selected time period, I am using the dynamic bucket plugin. My issue is the highest bucket range i.e. 800 is wrong as the maximum spend I have in my view is 741 ...
For a business dashboard one of the requirements is to show the average and grand total (see attached file). As far as I know, Sisense only allows one of them. Is it possible through e.g. a widget script to include this behavior? Kind regards,ScheurK...
I need to create a custom column on one of my tables. This column will be a LOOKUP from another table. However, if the current row has no match in the remote table, I want to use the value from the current match column. Here is what I am attempting t...
In my table, Values are arranged vertically as columns (first table in my screenshot). How can I move the Values so that they are arranged horizontally as rows (second table in my screenshot)?
Hi, Is there a way to hide the left [Dashboard list] and right panel [Filter List] for a dashboard? The aim is to restrict user from manipulating the filters and not jumping to other dashboards from the left and right panels Thanks, Rahul
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. widget.on('r...
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...
