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...
Hi,I am very new to Sisense and I am struggling with the formatting capabilities of the table widget. I would like to do some basic formatting of the table as follows:Format the column header row as boldAlign certain headers as centre.Align certain c...
I am creating a new JDBC connector and when I import the JDBC connector icon it appears slightly to the left. Is there a reason for this, or is there something within the JDBC connector configuration that manages this? @DRay
I would like to conditionally format a pivot table depending on the combination of 2 dimensions in the view.For example, in the screenshot below, I would like to color 'Bindable Ready to Quote' and 'cold' or 'open' green, and 'Bindable Ready to Quote...
I want to be able to hide a starred formula per user or role. Is there a way to do that in Sisense currently or does this require custom code? @DRay @Liliia_DevX
I have a need to filter based on day of week - for example, I need to total all weekend (or weekday) sales.The filter would seem to be the way to go, but I can't find a way to get it to filter based on weekday. I tried JAQL exclude, which it parsed o...
Hi Community,I am facing an issue while working with Redshift Live Connection and would appreciate your insights.Here’s the situation:I have a stored procedure in Redshift that stores data into temporary tables when executed.To connect to Redshift, I...
Hello All,Is there a way to customize "No Results" layout, we have few buttons at the top being hidden when widget has no data. Also adding the html script we're using. TIA const dropdownWrapperHTML = `<div class="dropdown-wrapper-${w.oid} ${dimnam...
I have two dates and i want to calculate the hours between... sisense says to use HDIFFHour Difference HDiff( <Start Time>, <EndTime> )Returns the difference between <Start Time> and <End Time> inhours.But when selecting a date field from the data se...
We want to be able to disable jump to dashboard for certain rows in a pivot table and bars/pie-slices in various charts. Currently we are only able to disable it completely. We would like to be able to be more specific on the disabling and only remov...
Creating a new post as I cannot comment on this post - https://community.sisense.com/t5/build-analytics/hide-widgets-based-on-selected-filters/m-p/5375I am using the widget script that the above post from @harikm007 to hide widgets based on selected ...
I have a dashboard where one of the dashboard-level filters is for a date field that's filtering down to "Last Quarter"Is there a way I can have the exact date range for this value displayed somewhere within the dashboard itself? I know users can see...
There was a forum post a long while back about avoiding having to create formulas that add up PREV(1) + PREV(2) + ... + PREV(N) periods to get a rolling average or sum. I can't find it now but it referenced an undocumented function for rolling previo...
Hi all!I'm relatively new to Sisense & just finding my way. I've followed the instructions in this post about adding a Target or Benchmark line to a chart (https://www.binextlevel.com/post/add-target-benchmark-line-to-a-chart-in-sisense).However, I'v...
