Hi, for this moment we have such a behaviour: sum(NULL * 10) = NULL but SUM(NULL * [id]) = [id] in the same time if [id] have values (1,NULL) and we will do SUM([id]) = NULL Is it possible to add some toggle in the system how to work with NULL values. For example, if it is disabled it works as NULL is empty and SUM(NULL * [id]) = [id] But if it is enabled, so all NULL should be works as in mathematic SUM(NULL * [id]) = NULL etc ... View more

Similar to widow-orphan control of Paragraph page breaks in MS Word... it would be nice to have this in pivot tables too. That is, let's say the existing rows/subtotals in a pivot table take up 20 out of the "rows per page" value of 25.  If the next sub-section to display is going to take 3 rows, great, show that section.  But if the next sub-section is going to show 10 items, it means the subsection/subtotal will be split across two pages.  This is hard to remembe/digest/use when interacting with the dashboard.  With widow-orphan control, it would do a page break "early" before showing that next subsection of 10 items. ... View more

Hello, I would like to porpose the following regarding formulas : - beeing able to defined formulas in the line or column section (for widget "pivot table"). Functions like SUBSTRING, LEFT, RIGHT, or CONCAT in order to reformat the content of a dimension also beeing able to use CASE function (to build buckets). - beeing able to use string function to define conditions to apply to a dimension. ie : CASE [Type] WHEN "A" THEN price * 09 WHEN "B" THEN price * 08 ELSE price END Thank you ... View more

Hi, Whenever an user with owner access is deleted, all the dasboard created by him are getting deleted. Also, those dashboards shared with others are also deleted. This looks like a critical issue, since the dashboard will be shared among other users, they won't be able to see any dashboard if the user gets deleted. Atleast the dashboard shared with other users should be retained.   Thank You, Deviprasad ... View more

We use the SSO JWT option for Single Sign-on. In Single sign-on configuration, we specify the Remote Logout URL. We want a way to specify this remote logout URL at the user group level. ... View more

Simply put, the ability to have a button within the UI for when new users are created within a particular data group (or similar category) to replicate permissions, DS, dashboard sharing, pulse, data model shares, etc.  Even simpler, the ability to have a column within User Mgmt. to show which dashboards are shared with which user.  ... View more

Current behavior of the Simply Ask feature doesn't support automatic saving of the modified NLQ model to the "*.dash" file. So you loose your development work after exporting the dashboard with already enabled and tuned "Simply Ask" to a "*.dash" file. After importing this dashboard back to Sisense the feature is automatically disabled. Also if a developer will enable it manually it starts running based on the "By Default" NLQ model. This forces to redo all the work on the model back again which is time consuming and not efficient. We expect Sisense to consider in the future the development work on making this more convenient for a BI engineer. If a "Simply Ask" feature will be automatically enabled on an imported dashboard with a corrected model, it would be beneficial for dashboard deploy automation and will reduce unneeded additional manual work on setting up this feature again and again for different working environments for the same dashboard. ... View more

Right now, if you're making significant changes to an existing cube, the only way to verify that you haven't broken something is to actually do a build. I'd like a Verify or Validate button, next to the Build button, that would do the initial steps of the build process and then stop.  For example, determine if the metadata in the table can actually be retrieved from the underlying data source.  Or checking datatype mismatches in existing joins.  And so on.  Just leave out the last step where you actually retrieve the full data set and then build the cube. This would save time during the development process. ... View more

Because a non-trivial amount of the population is colorblind, it's a best practice to never rely solely on color when indicating behavior or status of a UI element. The filter-pane buttons are by default, I think, green for positive selection, red for exclusion, and grey for unselected. It would be better if there was also a small icon in the button that would indicate checkmark if positive, "X" if negative, and blank if unselected. Or perhaps, if Unselected (red), show a thin "X" over the whole body of the button. Thank you. ... View more

We are a multi-tenant software provider and we embed and white label Sisense.  In our setup, we have 2 models.  Model 1 is used by Engineering to create our pre-built dashboards, where we share these with specific groups we've set up so that all of our customers see our pre-built "out of the box" dashboards The second model is what we expose to our Premium users so that they can create their own custom dashboards.   There are times when our customers will create a new, custom dashboard with the second model.  These users sometimes share their dashboard very broadly.  When this happens, there are certain users that wish to remove themselves from the share.  Perhaps they don't have row-level security to see anything.  Perhaps they have changed roles or simply do not use that dashboard. Note that we do not want to allow customers to remove themselves from our pre-built shared dashboards, as this could cause support confusion as to why our analytics solution is enabled but a user doesn't see "all of the dashboards".   With the above noted, we would like a configurable means to show/hide a "leave shared dashboard" dashboard option, based on the model with which a dashboard is associated.  This will ensure that users cannot remove themselves from our pre-built dashboards (we would hide on our model) yet allow them to remove themselves from custom dashboards that were shared with them (we would show on model 2 for self-authoring) When a user leaves a shared dashboard, there should also be configuration options to alert the owner of the dashboard via email.  This email should be capable of white labeling.  It should include dashboard name, who left, and when.  Should there be links to the dashboard in the email, there must be a way to disable hyperlinks in the email. ... View more

We produce pre-built dashboards for our customers.  They can build their own as well.  Often, they will start with one of our pre-built dashboards and modify to their needs. Users want a way to "filter out" our pre-built once they have created their own.  One mechanism mentioned was the ability to "Favorite" a dashboard and have a new "Favorites" toggle on the Analytics tab. ... View more

Hello There, We need to create a data model with 2 different data sources . One databricks live and another one is an excel file with some additional data . We need to create a combined model so that we can join these two tables and get the result. Currently sisense does not support it and other providers like Power BI and Zoho supports this feature. This is a common use case for our scenario  ... View more

We support multiple applications of data within a model, as there is crossover between the applications; however, our customers have granularity to choose which application data with which they are allowed to see when they create new dashboards. We use column level security for attributes today so that Application A author can only see table of data pertaining to application A while Application B author can only see tables of data pertaining to application B (note that a user can have both author rights and see all both application data). We found that this does not pertain to Shared Formulas.  This now increases the "noise" that authors see, as they are seeing formulas for an application that isn't something they can readily use. ... View more

The list of our shared formulas can grow to be quite long.  We would like the ability to search within formulas, just as you can for attributes. ... View more

We embed and white label Sisense and our premium customers have the ability to author new dashboards with the formulas and attributes we provide. Our users want the ability to create new attributes, comparable to creating a new formulas. Examples: new "Northeast Location" attribute = existing location attribute that we provide where sites = A, B, C new "Shutdown 2023" = existing date field that we provide where date range between X and Y Concatenation of multiple fields to form a new attributes, comparable to Excel new "Is True" type attributes = existing attributes we expose if value(s) = ... Customers want the ability to create their own custom attribute, have then be added to the default values list, in their own "custom" section, where they can search and reuse their own creations. We are a multi-tenant solution provider so tenancy of these custom creation must stay "in tenant" and must do so with us implementing the multi-tenancy feature of Sisense (as we are already deployed and this is not yet robust enough for us to utilize) ... View more

A nice feature in Microsoft SQL Server is the ability to see multiple data sets from queries in stacked windows. Currently only one query can be executed at a time and only display that one query's data set. It would be nice to be able to compare data by having multiple data sets appear at the bottom. Currently I have to open multiple browser windows to compare values and it can get a bit busy. It would be nice to compare 2 or more queries in the same window. Select * from table 1 where id = 123 Select * from table 1 where id = 456 data set for id = 123 data set for id = 456 ... View more

When building dashboards, a common frustration is the lack of ability to multi-select widgets and perform mass actions, such as moving a group of widgets all-together at the same time, or deleting multiple widgets at once. Currently, to do either of those actions, you must do it one-at-a-time on each widget individually. This is tedious and time-consuming if you have many widgets you need to move or delete. It would be nice if there was some way to select multiple widgets at once and perform some kind of mass action on them, like click-and-drag to reposition, or to select "delete" and delete all selected widgets at once. I'm not sure what the best way to do this would be. Perhaps a toggle at the top of the dashboard that allows you to click a checkbox next to each widget. Similar functionality already exists for the main dashboard list, on the left-hand sidebar...a toggle at the top will cause checkboxes to display next to each dashboard (or dashboard folder). Checking any of the boxes will cause additional options to display at the bottom of the sidebar, allowing you to export or delete the selected dashboards. Alternatively, if there were a way to "group" widgets into a container of some sort, then you could perform an action on that container which would apply to all widgets within it. For example, if you had a container, and then three widgets inside, you could select the container and move it, which would move the widgets as well, or you could select "delete" which would delete the container and everything inside it. ... View more

In the left-hand sidebar where the list of Dashboards is shown, it would be nice if there was a visual indicator of whether a Dashboard that you own is being shared with anyone else. Currently, the only way to determine this is to click the kebab icon (⋮) next to the dashboard name and see if it says "Republish" (indicating the dashboard is currently being shared) or "Share" (indicating the dashboard is not currently being shared with anyone). However, if you are the owner of MANY dashboards, some of which are shared and some of which are not, then it can be very tedious to check this one-by-one. If you hover over a dashboard in the list, a pop-up will display with additional information, one of which is a "Last Published" date/time. However, this doesn't really help. First, it only appears on mouseover, so it doesn't solve the problem of this information being tedious to check/verify (since you still have to check each dashboard one-by-one). Second, the "Last Published" displays if the dashboard has EVER been shared, even if it's not currently being shared with anybody. For example, if I shared a dashboard with Bob, but then later removed him from the share list, then the dashboard is only visible to me and no one else, but the pop-up will still show the last time I published it to Bob (even though he can't see it anymore). There's also a visual indicator, to the left of the dashboards, in the form of an icon that changes depending on the status of the dashboard in question. Unfortunately, this icon only shows the ownership status of the dashboard, not it's share status. That is: it helps you identify at-a-glance (A) which dashboards in a list are ones you own, vs (B) dashboards that someone else owns and has shared with you. However, for the dashboards that fall into (A), there's no indicator as to whether you've shared it or if they are only visible to you.  Perhaps a different icon could be used to indicate each state. Another nice-to-have: for dashboards that fall into (B), i.e. dashboards that someone else owns and has shared with you, perhaps there could be different icons depending on the way it was shared with you. That is: whether the person shared it with you specifically vs shared it with a group that you're part of. Essentially, the icon should indicate all the possible states that a dashboard can be in: Dashboards you own that are not shared with anybody (i.e. only you can see it) Dashboards you own that have been shared with others Dashboards you do NOT own that have been shared with you Dashboards shared with you specifically Dashboards shared with a group you're in ... View more

We want to rotate the API key for our system user but need to make sure there's no downtime.  This means we need to have 2 keys working in parallel for the same user for a period of time until we can cycle all of our services to pick up the latest api key. The problem is as soon as the API key is rotated, the old key immediately stopped working.   Majority of systems out there support key rotation (like allowing a time delay before the old key expires like FB app, or ability to temporary create a second key and then we can promote it as primary once we are ready).   Key rotation is a best practice for security principles. ... View more