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

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

Currently, it appears that Shared Formulas are displayed in the selection dialog based on the order they were created. It would be great if they can be arranged logically, or at least sorted alphabetically, otherwise the list can grow to become disorganized and difficult to use. ... View more

The idea here is to expand the formula editor (Specifically CASE WHEN Statements) to allow the creation of dimensions or "buckets" based on filtered data. This is useful on the dashboard level as we may want to recategorize our data dynamically after filtering the dashboard.    Lets say I have a pretend table holding daily customer transactions. In my report I'd want to see each customer's average spending for an arbitrary time frame. I'd also like to categorize that player BASED off that average spending. Which could change based on any filters I use.  IE)   CASE WHEN [Avg Money Spent] > 999 then '1000+' WHEN [Avg Money Spent] > 699 then '700 to 999' WHEN [Avg Money Spent] > 399 then '400 to 699' ... WHEN [Avg Money Spent] >= 0 then '0 to 99' ELSE NULL END   I would then use this calculated dimension in visualizations like pie charts, etc. I'm not sure if this is possible, but being able to use this dimension as a filter would be very useful as well. IE) Show me all the customer who fall under '400 to 699' range for any given period. ... View more

Problem: Users commonly wish to share data with their team members, but reports with many filters can be difficult to reproduce and share with others while abiding by security permissions. This causes confusion when numbers appear different, but the result is simply that the users are comparing data with two different filter sets applied. Summary: Saved searches would allow for users to create filter sets across multiple dashboard filters to quickly return to a filtered view of data. These saved searches would also be highly beneficial if it allowed users to quickly share these filter sets with users that have access/permissions to the dashboard of origin when the two users are both part of a user group that allows filter sharing.    Admin User Story: As an admin, I would like to create a saved search that allows users to see data for each region of the United States for the current year-to-date as well as saved searches for each quarter of the current year. I don't want to create multiple dashboards or even multiple widgets as I'd like the user to be able to see consistent stats for each time frame.  The admin creates a saved search for each of the desired filters to allow a user to quickly navigate and select the different saved searches to populate multiple filters at once with the desired filter set.  The admin has access to share with all users, but they decide to share the filters with the Executive user group. In order to share with the executive user group, the admin must enable filter sharing within this group. The admin as well as members within the executive user group will be allowed to share with all members in the executive user group once this permission is enabled.  After enabling filter sharing, the admin shares the filters with the executive team. The admin can choose to include an email or only share within the system with no notification. They decide not to notify all users of the group, but they copy the share link for the 3rd Quarter Western Region saved search. They send an email to the director of the West Region with the saved search link. (See Viewer User Story)  Viewer User Story (West Region Director): A viewer belonging to the executive user group receives an email from their Sisense admin including a link to the 3rd Quarter Western Region saved search. They click the link and are directed to the new strategic dashboard with the filter set for the 3rd Quarter Western Region applied to the available filters.  The viewer reviews the data and reviews the other available saved searches for the additional quarters that were provided by the admin. The viewer clicks on the 2nd Quarter Western Region and the filter set populates in the filter pane.  After reviewing the filter sets provided, the viewer adds regional subdivision filters based on the territories of their Western Region managers. The viewer creates the "West - Territory 1  (Q3)" saved search and shares it with their West - Territory 1 manager only and sends a notification to the manager. In addition, the viewer identifies issues with two specific teams and filters to these teams in the manager's territory. The manager filters to the two teams as well as the product's where issues were identified. The viewer saves the search as "{Manager Name} - Quality Assurance Focus" and sends a notification when sharing the search to the manager. The saved search allows the manager to quickly highlight focal points with his manager so that the manager can review the data the director sees prior to meeting and discussing the issues at hand.       ... View more

Users would like to be able to define the text sent in the email notification body. Each report sent via Report Manager could have a different text to explain the content of the report / the frequency / the purpose ... For now, it only possible to customize the email body at the server level ... View more

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

I think table and custom table usage should be added to the scope of usage analytics. I have large data sources that have been around for many years. Often dashboards are unused (which I can currently track with usage analytics) and can be deleted or archived. But the data that drives them is much harder to keep track of. I have no way of knowing which tables are used in dashboards and which ones could be removed. This is especially true for custom tables that eat up build time and might not be used at all. ... View more

Currently the values that get displayed in a "text" based dashboard filter is sorted by default in ascending order. This is ok for most cases. But for certain cases (e.g. date as text) - we wish to showcase values in descending order. Hence, the feature request for allowing sorting in dashboard filters. ... View more

Please add support of the First day of the week for the Live models. ... View more

Upon receiving the warning "Maximum number of series (50) exceeded", the warning does not reappear with a widget, dashboard, or page refresh. Instead, a filter change is required in order to trigger it again. IMO the warning should persist with refreshes and be visible every time due to the impact of the limitation being exceed - data is literally missing from the widget and the widget does not reflect the data set expected by the user.  To that end of being clear about the impact of having more series than the limitation allows, the warning would be best reworded to indicate that impact and avoid users making decisions on an uncontrolled subset of data. For example, "Results limited to maximum number of series (50)..." or "Data limited..." This limitation should also be documented in Sisense documentation, but is not currently. ... View more

Hi, Currently in the filters, we are unable to directly filter a comma separated list of entries. The options available are individually selecting the members, however that can get tedious if the list of entries we need to filter are large. For example, filter more than 100 entries. The other option is using the custom option in the filter. However, that too requires JAQL code which might be difficult for non technical users.  It can be useful to have the option to directly copy paste a comma separated list of entries in the filters instead of multiselecting or using the custom JAQL option.   ... View more

We have had several users complain that the way series selection for charts is not intuitive. Currently, when you have multiple series in a line chart and click on one in the legend, it gets disabled to highlight the others. The intent is to allow focus, but it's the wrong way around - most users expect that the item clicked should be selected and the others hidden. The current behaviour is quite painful if you want to see one series when there are several (you have to click on all the others). Is there a simple way to reverse the selection behaviour, or do we need to look at other options: wrap the control and handle it ourselves (possible?) build some drop-downs/UI to allow selection of whats shown some other neat UI work-around?? ... View more

The number of source of frustration and confusion amongst our users, when building Dashboards, is conflicts/inconsistencies between Dashboard and Widget filters. I have separately suggested that Sisense introduce a visual indicator of widget-level filters and it sounds like that is planned for the future, which is great. Another related feature that a user suggested was a "reset all widget filters" button which would be a single place at the Dashboard level. If the user clicks it, it forces all Widget filters to (a) be deleted (or maybe disabled?), and (b) puts the widget filter settings back in-sync with the dashboard (meaning if the user has selectively toggled off Dashboard filter inheritance at the widget level, that will revert back to the defaults). This is a really quick and easy method to put users back to square one if they have painted themselves into a corner, so to speak. ... View more

Every day we process our elasticubes and they always process in the same sequence.  Users are able to create dashboards that have widgets from different elasticubes.  However when they select to send the dashboard by email on "Every Elasticube Update" this sends after the first of the elasticubes has processed, rather than waiting until all of them have updated.  This means users are emailed dashboards that have some data correct, and some that is old. I think the solution would be an option to send after all of the elasticubes in the dashboard have updated, or to select a specific one, if the elasticubes generally build in a particular order. It would be good if this could be considered for enhancement as users wouldn't want to receive partially correct dashboards in this situation. Thanks, James ... 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

Currently the Analytics screen displays available dashboards in a "list" view or a "tile" view.  The "tile" view includes columns "Name", "Owner", "Data Sources", "Last Published", "Last Modified", "Total Viewers", "No. of Widgets".   This is a request to add a new column "Source Folder".  This would be helpful for users with a large quantity of dashboards as they could sort by the "Source Folder".  In the future, the list view functionality could be expanded to allow grouping by this column which would further consolidate the view. Thank you! ... View more

We need a view that shows us which dashboards are dependent on which table in the datamodel. We want to remove some tables, but because we have many dashboards we don't know where exactly that table data is being used so it's very risky to change/delete tables. The depedency granularity of the data model is good but not enough. ... View more

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