Perspectives is a great addition to the application and making only certain parts of the model visible to those dashboards connected to that perspective is excellent.  Adding the ability to filter the perspective is something that is required for many of the use cases we have.  For example, we have a model that has All Tickets.  We have many dashboards that have a locking filter at the top to show only Open Tickets which doesn't look good from a user and design point of view.  Being able to create a Perspective and not only be able to refine the columns but also filter to (in this example) Open Tickets only would greatly add to the power and usability of this feature. ... View more

Currently sorting of dimensions/categories/series is by Ascending and Descending only.  There are times when such data points need to be sorted in a non alphanumeric manner.  For example, Critical, High, Medium, Low is the desired sort, but this appears as Critical, High, Low, Medium or Medium, Low, High, Critical which looks sub optimal to the user.  A workaround is to add a number prefix via modelling, again this is less than ideal for the user, as is a script to update the displayed values to remove the prefix.  As is possible with other BI Tools, there should be an option for the Designer to configure the sort.  There are various community plugins and scripts that do this on an explicit per widget basis, however these are prone to fail/break and aren't guaranteed or supported through version upgrades.  This should be a part of core application functionality. ... View more

Currently the box and whisker plot is not supported when using a live model. When the widget is created, it has an error and won't show any data. We would really like that to be supported on the live model. Article showing that its not supported: https://docs.sisense.com/win/SisenseWin/live-connect.htm ... View more

Is there a way to retain formatting when exporting to Excel? We currently highlight rows in red if they meet a condition, but the formatting does not carry forward to Excel ... View more

Hi, We are having several issues when dealing with Elasticube Builds. We can now schedule the build (both UI and REST API), but we have no tool to monitor and control this key functionality. What's the history of the builds for a cube? When can we see the whole picture of the time each build for each cube happens to optimize resources and find concurrent builds in time? Now we can just see the last build log, as an isolated entity. We cannot monitor all the builds as a whole, to see the whole picture of all the builds (when it happened, how many time it got, etc.). As administrators, we have no way to control now this. Even we cannot check the history of builds for a cube. It's a critical feature for administrators.  Best ... View more

Allow widget designers to turn off the display of the Grand Totals calculation for certain columns in a pivot table. Situations exist for which it is highly beneficial to display the Grand Total of a select few columns in a pivot table, and not to show others as they can be misleading or distract from the primary purpose of the pivot table. I envision an implementation that enables the Grand Total to be toggled on/off for each column, with the default being 'on' for all columns. ... View more

As a standard offering, enable color conditions to also be displayed in the Grand Totals columns/rows. The coloring should also carry through to Excel or pdf downloads, the same for the rest of the pivot table.  Current custom script solutions are at risk of breaking with future version updates, and the Grand Totals colors do not carry through to Excel and pdf downloads. ... View more

There are three features for BigQuery connections that would make your Edit Chart interface great. Show descriptions on the tables and fields: BigQuery supports adding a description to the fields and tables themselves. This information is often useful, and I find myself going to check the documentation on BigQuery consola in Google Cloud itself. We make use of this feature. Other databases also allow defining comments on tables and/or fields. It would be great to show them on the intervace via a tooltip when you put your mice over the field (right now is showing the type only) Display amount of data to be processed: one of the characteristics of BigQuery is that you pay by the amount of bytes you process. Building queries that are "efficient" is tricky task. Having a visual clue on the cost of the query allows me to understand better, before adding something in a dashboard or even running the query, how much data is going to consume. Also, if you tie that to the fact that I usually want to run the query using filters, and that there is no way for me to change filters in the editor, it makes my life miserable, because I need to copy the query, go to Google console, replace the generic filters [name=value] by real SQL filters, make a sense of the cost in SQL, etc... miserable experience. Show partitioned tables differently: For example, on Google Cloud BigQuery editor, partitioned tables are shown with a different icon than normal tables. Knowing if a table is partitioned, and knowing also which fields are the ones partitioned, would help to build efficient queries without leaving Sisense. Right now I find myself jumping in and out sisense. This takes time, and you are already showing all fields and tables in there, it would be great to just use a different icon for partitioned tables. That would be already helpful. Displaying the amount of data processed, to keep costs slim, would likely be the top thing (and Google does have API / command line in order to get the amount of bytes to be processed by a query). ... View more

I use Chrome browser. I keep multiple tabs of sisense opened. When the session expires, it expires on ALL the tabs (which makes total sense).  The problem is that all those tabs get redirected to the login page and I need to login on each and every one of them. It does not detect I've logged in in another tab, neither if I hit the browser Refresh button it will detect the login and redirect me to the page I was in before I got logged out.   This is annoying because I have to either login again, or open a new window and search for the dashboard I had open. Ideal expected behaviour (preferred, but probably harder): Once I'm logged out on several tabs, logging in one of them should make the others notice and log me in automatically. Good-enough behaviour ("easier"): Once I'm logged out on several tabs, logging in one of them should allow me to go to other opened tabs, which are showing the login windows, and refresh them (e.g using Ctrl+R) so that itwill automatically detect my session and redirect to the page I was before I was logged out.   This will save me a lot of time and make sisense less annoying. ... View more

The default color scheme for the sunburst chart is defined per ring, while it should be per category. For example, category 1 has the red color, category 2 has green, and category 3 has blue color scheme ... View more

we want larger area to edit and view widget description ... View more

A while back the JTD didn't pick up measured values properly and we configured our dashboards so that the measured value filters were not relevant to the jump. We have some situations where there are conflicting filters with-in the measure (e.g. comparing different things as a numerator and denominator). Can you add a widget config option to ignore measured value filters? It would require adding an item in config and then adding an if statement to the filtersHelperService.js in the getMeasuredValueFilters like if(config.ignoreMeasureFilter) return [] ; around line 560. This would greatly help us out as we do have fairly complex filters running and much more often than not want to only consider dashboard and widget filters in the Jump. ... View more

Currently in version 0.9 /datasources/{title} is used for cancel all queries but also return a datasource. It is the only way to get a datasource by title. The other alternative is use the get datasources endpoint but the filtering does not work to filter by title.  It would be really good to have an endpoint to get the datasource by title. ... View more

The Sunburst chart is a great way to view multilayered data and obtain high level values and percentages from the source. Surprisingly, this visualisation does not support Jump to Dashboard (JTD) functionality which I would like to request. The ability to drill into the data is vital and provides users with an understanding of what sits beneath the chart should they require the detail.  ... View more

Hello, How about having a better control over queries parallelism ? My use case : Elasticubes using 2 connections : DB1 / DB2 Currently, the parameter BaseTableMaxThreads (sets to 2 for us) controls how many queries can run in parallel, whatever the connection. During build, we frequently see situations where we have 1 query on DB1 and another one on DB2. Reducing the level of parallelism was necessary to limit contention on one connection but it would be fine to have 2 queries on DB1 and 2 queries on DB2 at the same time. My proposal is the following : having a parameters to controls the level of parallelism per connection and not per build. Thank you.    ... View more

When utilising the Fiscal Year functionality, it is frustrating that there is no option to display the calendar year as a formatting option. We are based in Australia and our Fiscal Year starts in July, so our 2023/2024 Fiscal Year (called 2024) runs from July 2023 to June 2024. If I create a simple pivot with our Date, Year (Calendar Year formula) and Fiscal Year (formula in format YYYY/YYYY), then you can see that the date is actually distorted.  There is no way to display that this date actually falls in 2023, which is the case for the first two records in the below pivot. Applying a filter with a date range handles this correctly, but it is confusing for our Finance department as to what date this is referring to. I've connected with Sisense support and they've provided a solution for a Date Display Field (thanks @AssafHanina) which does solve the issue, but then we need to have complicated rules for dashboard designers to use X field on their Dashboards but Y fields on filters, etc. I feel like an additional date format of "cy" for Calendar Year would solve this issue from the display side and make things much simpler.  Some logic already exists for "yp" for the previous year, this would be very useful for our designers to have this additional option and to keep the date as one field rather than needing a second. Has anyone else encountered this issue or would find this useful? ... View more

Our primary brand colour is red with our second colour a dark blue, but if I make that the main colour (as I would like), then my buttons become red and cancel buttons need to be another colour. It makes sense for the cancel buttons to be red and I understand the concept in making buttons the same as the primary colour, but in this instance we really want to be able to change that setting and have the buttons be blue so that the cancel buttons could still be red. If I make the primary colour our brand blue then the whole site looks black and white. Suggestion: allow the button colour to vary from the main colour. ... View more