Recently, we were trying to create a widget using the RPAVG function for a rolling 30-day average, which broke our connection to the live model while working (to an extent) on an elasticube. The function worked past the first 30 days on the elasticube, while the first thirty days were (SUM N )/ N. This formula works past those thirty days, but for the first value, for example, gives simply the first value.  A new version of these functions would be greatly appreciated.  ... View more

Using the jumpToDashboard plugin, there is a feature enabled with flag "hideSharedDashboardsForNonOwner" that allow the owner of a dashboard to hide dashboards even if shared with other users. The owner is the only one who can see it. The problem of this option is that, when a dashboard is configured to be hidden, the only way the owner has to know this setting is to open the dashboard menu and check the flag status. As a result, it could happen that the owner doesn't have a clear overview of which of his dashboards are visible and which one are hidden to other users. It could be useful to show somehow to the owner, in the tile and list view, if a dashboard is hidden. One simple option is to set a value of opacity for hidden dashboard like "0.65" to distinguish them easily. Attached my implementation of this feature. It's based on 1.3.1 version of jumpToDashboard and adds this feature; it also fixes some issue I found with proxy base url set on the system (win and linux). There is a know bug in this feature (already in the base plugin version); the viewer see the real count of dashboards but then see just the dashboard that are not hidden (e.g.: 5 dashboards counted, but 3 tiles displayed). Here an example of 2 dashboards listed, one hidden and one not: 2024-10-02 - Updated attached version to fix dashboard counter when some dashboard is hidden ... View more

It's not possible to create a dashboard filter using formulas. I could create a dashboard filter only with variables that are present in a data source. I am able to create a value in pivot table and then use it as widget filter, but it can't be done to other widgets that are not pivots. ... View more

I'd like to have the easy option of making a customized table or pivot table with any data types in my data model. Below is the ideal table I can easily achieve in Tableau and PowerBI today, with string and number data types. Sisense cannot achieve this without adding in bespoke BloX or code snippet. My data looks like the below: Trying to achieve my ideal result in Sisense pivot table looks like below, which is not a good look. Sisense cannot visualize the string data type in a pivot table or a table with numbers in the way I hoped for. Other softwares have the option of dragging and dropping any data into an area in the dashboard which will solve this issue.  Here is my sisense community post where I asked for help on this issue: https://community.sisense.com/t5/technical-troubleshooting/how-to-pivot-this-data-table/m-p/23187#M175 ... View more

When opening a support ticket, it's required that a large form be completed. Among these is the Sisense Account Type, Environment, and Version. We too frequently open a support ticket only to be provided with a response unrelated to the information provided in these fields (e.g. a Linux based recommendation after specifying the issue is occurring in a Windows environment and being asked for a version number after the information was already provided). Given the global distribution of Sisense support resources, it can already take a day before expecting a response, but for that response to then be unaware of the information provided in the ticket details causes delays, extra rounds of communication (especially when our support rep doesn't realize that the Sisense response is for the wrong version), and frustrates our support teams and the clients they in turn support. And we imagine the Sisense support reps don't love finding they sent irrelevant advice and don't like seeing our support reps' confusion when they aren't already aware of the information provided in the case opening form. We appreciate Sisense support reps and want to see them support us with as little friction as possible. Thanks. ... View more

When I sort cubes in descending order and then click into a cube and come back to the list view I lose sorting. This can be annoying/frustrating. Can you make it so that my sorting remains until I change it? ... View more

Custom Code is currently disabled in a multi-tenant environment, which is an odd thing to disable as it is among the many features that make Sisense so great because of the ability to manipulate the data within Sisense and part of the Tranform stage of ETL processes.  I am a Tenant Admin in my multi-tenant environment and I can click on Custom Code but I am not able to access the jupyter notebook environment. This creates a lot of confusion for clients who have multi-tenant environments and also takes a feature that the other clients have in single-tenant environments.  Sisense should seriously consider making this a permanent feature in all environments because it is so useful.  ... View more

When a Sisense server's IP address changes, you have to reinstall Sisense. I want a script or button that changes all the relevant settings. We need it because we're planning changes to our network. There are other reasons that an IP address might need to change, e.g. I might restore from a system image backup to a different location, or I might start a new server and, after testing, want to redirect my old server's IP address to it. We'll do it by reinstalling, but that feels like more work than it should be. ... View more

Can we get a "refresh schema for all tables" button? Reason: Our tables are usually "Select * From AnalyticsSchema.ViewName". We control which fields to return by editing the view, not the Sisense table definition. When a field gets added/removed/changed, we need to refresh schema. That's fine to do manually as you're working on that datamodel+views, but we need to refresh all when: We copy a datamodel to a different server. We need to refresh schema at least to double-check that the views are as expected on the new server. (If any fields have changed, then I'll need to go fix any widgets using those fields, or, more likely, update the view to include them.) A view gets edited, perhaps for a different datamodel, and my datamodel hasn't been updated.  I edit several views and want to refresh schema for all those Sisense tables. If I've changed used fields then I'll need to go into each table manually anyway so it doesn't matter, but I've had a case where I've removed unused fields from several views and now I need to click refresh schema on every table individually. ... View more

Within dashboards, the only way to know currently if there is a filter on a widget is to open that widget. This is VERY time consuming if there are multiple widgets within a dashboard (we sometimes have up to 10). Please add an icon at the top of widgets (near the pencil would be great). If the icon is grey, no widget level filter is set. If the icon is colored in, a filter is set. If a filter is set, mousing over the icon should return a preview of what the filter is. ... 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 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

When adding a dependent filter, the only [available] lock option is a group lock. It is more useful having the ability to lock the primary filter but allow for dependent filtering. For example, if I lock an audit title, I want to retain the ability to filter specific question(s) within the audit. If both are locked as a group, I have to ensure end users know how to filter through the widget, which can be difficult if the full text of the question does not display or the user is not proficient. ... View more

We would like the ability to export table widget data to Excel.  While CSV is supported, we have had customer complaints because they format in the CSV file and forget to save as Excel, losing the work they've done.  We prefer this is a Sisense feature over use of a plugin as plugins require additional operational overhead to maintain and upgrade. ... View more

Hi, We are facing some issues in the hour timezone related to builds. There's no way to change the UTC setting for the build schedule. It's very confusing and it's generating many issues in timezones when there are changes in the hour due to summer/winter time adjustments. We tried to change the timezone in the upgrade process, but the build schedule only works in UTC. This is a nightmare for data administrators. We need to be able to set the local timezone as the build schedule setting.  Best ... 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

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

Hello, In a multitenancy environment, it would be useful to be able to define different "look and feel" theme for each tenant. Currently, the one define on the system tenant is applied to every tenant. Thank you. ... View more