Hi,I'd like to create a Box & Whisker Plot to show the distribution of "Bookings" by "Day of Week" across the time period so the client/tenant should be able to see, for example, that on Mondays their bookings can range from 150 to 325 but there are ...
I am building a bar chart show actual vs target number. And in my actual number, I am using a conditional color if it is over the target then show yellow if not show blue here. After I added the conditional color on the "Actual sale" value, the legen...
Hello! I have the following formula that I keep on getting an error message on, and I'm not sure why:MIN(DDIFF([Days in Invoice Billing End Date],[Days in Invoice Line Item Service Date]),DDIFF([Days in Invoice Line Item Service Date],[Days in Invoic...
In a table or pivot table widget I want to concatenate strings contained in two separate data model columns. Example: col1 contains "Abraham" and col2 contains "Lincoln". I want to concatenate them, along with a space to display "Abraham Lincoln" in ...
Live data model connected to Snowflake. We have some long text columns containing carriage returns and tabs. If we display these values in a table or pivot table in Sisense, the text is missing the carriage returns and tabs. Is it possible to have te...
On a pie chart, where the 'Others' slice is enabled, is there a way disable the click action for only the 'Others' slice? We have some instances where the Others slice contains several hundred members and can crash the page. Ideally, we'd like the us...
Prior to upgrading to the latest version, all our Dashboards displayed the date and time of the latest elasticube build for all our account types.Like thisThis was a useful feature as users could be sure they were viewing the latest data.After upgrad...
During widget creation, and dashboard development, we have all came across multiple dilemmas and questions like:- Does this widget look good?- Does this look good as part of the whole dashboard?- Is the dashboard too crowded? Is the widget too crowde...
When I select fields in a pivot 2 table for filtering, those fields will be highlighted. If I then hover over additional fields, they get highlighted in the same color, like this:I would like to achieve 2 things in my pivot 2 tables:1. set the hover ...
Hello, I'm trying to merge borders for multiple widgets. Lets say if I have two widgets I know I can customize each widget's border style using the below script ,but is there a way to only have 4 borders for 2 widgets instead of 8. TIA dashboard.on('...
Hi, I have a column chart which displays the % of documents approved on time each month for the past 3 months by location. The value is the total that were approved on time out of the total documents, so a 0% represents that none of the documents wer...
Hello All,I'm trying to get a dashboard filter values when Sisense dashboard is embedded in our website (using EmbedSDK). I was able to get the active filters when I use the below function and when "Include All" is not selected. // Function to retrie...
How is it possible to limit user actions with date filters (like the one below) to only choose a value from list of days and nothing else (change the list format to months/years, use calendar, time frame, ranking, allow multiple selections, etc.)?
On your website I example dashboard (screenshot attached) with a dot plot. However, I don't see ability to select a dot plot on widget. Am I missing this functionality or is it limited to only certain subscriptions? I work with customer Central Reach...
I used this formula to get days from creation to deactivation.DDiff([Days in Client Last Deactivated On],[Days in Client Creation Date])What formula can I use to obtain days from creation to current date/now?I only have designer access to Sisense and...
