Default Break By behavior should be Rows instead of Columns

wallingfordce · ‎08-08-2024

Create a pivot widget of RSUM( [Total Quantity] ) over time (rows) and break by (columns) age range. Scanning down each column, over rows, the numbers only increase. Now change it to a line widget. The break by defaults from an RSUM within columns in the pivot to an RSUM within rows in the line chart. This is the same as not having an RSUM and doing a stacked area. Our clients expect the line chart the results from changing the pivot to a line chart, to reflect the same output as the source pivot. As it stands now, they are surprised to see negative curvature in their RSUM, think something is broken, and open a support ticket. The default behavior should be to render Break by Columns instead of Rows. As an aside, I'm having trouble coming up with, and would be interested in hearing, use cases for charts with break by set to rows.

bminehart · ‎08-08-2024

Our customers want to use the same data field twice within a filter. For example, within the field primary impression we want to include "seizure" and exclude the value "pyschiatric/behavioral problem". Is this kind of functionality on the roadmap, or can we have it added?

bminehart · ‎08-07-2024

The content/formatting/text contained in the various Sisense-generated/automated emails is currently static. I went through a long dialog with support and determined that it's not customizable by customers. I would like it if we could modify these emails, and I'd especially like to have access to dynamic variables that we can insert in the email body (or subject). User's first name or last name were specific for my use case, but having access to a variety of variable could be helpful.

Olek · ‎08-06-2024

Hello, I would like to suggest adding custom number of characters for the search bar on left panel when search is performed. For example, search will start after typing 3 letters. It would also be great if that search would be asynchronous instead of stopping everything. Currently search is run after 1 character and with a big number of dashboards freezes whole application, sometimes causing browser to show alert that page is unresponsive.

Tim · ‎08-04-2024

"Analyse SQL" helped me understand some widget measure formulas and filters. I wanted to then experiment with it in Sisense's "SQL Runner", but that didn't work: the query is too large, and it uses strange names for tables and columns (aFactXwAaSaleXwAaorders for the table Fact_Sale_orders, and aCountryCode for the CountryCode column). It'd be helpful if you modified SQL Runner and/or Analyse SQL so that I can paste results, edit, and run them. The purpose to help me investigate questions such as "How does this filter affect my measure?" or "What does my colleague's horribly convoluted measure formula mean, why is it wrong, and how might I fix it?" or "Is my widget doing unexpected joins?". I'd like this as a tool for myself and to recommend to colleagues.

gwolfe · ‎08-02-2024

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?

btrevizan · ‎08-01-2024

Currently, builds can only be scheduled in the UTC timezone. This is confusing for someone not in UTC and when you have to coordinate with external processes. The user should have the ability to schedule builds on their own timezone.

AlanaCummins · ‎07-18-2024

It would be cool if our end users could receive a Digest Email that is sent out on a frequent basis from Sisense. This email would be most relevant if it was based on the groups a user is assigned to already. This would ensure relevant communication, as well as ensure there is control over the reports included in the digest that the user would already have access to them. We would not want the digest email to included recommended reports the user doesn't already have access to. If it was a feature the Admin could turn on/off at the group level that would be our preference. The feature would allow the Admin to select how often the digest went out (weekly, monthly, etc). The feature would allow the Admin to select what content was included: For example: Changes, Top Used/Popular in the Users Groups (i.e. Org), and then for us I think Newly Published Reports would be ideal. This would allow an organization to choose whether every time a new dashboard is released the user is notified, for us we would prefer a section in the digest that has these 3 dashboards were released to your group(s). Other BI tools do already offer this-- Attached is an example of the Power BI digest, as reference. Thanks!

fschleich · ‎07-18-2024

Hello, It would be good to be able to export data to Excel from the Dashboard menu. Currently, one dashboard containing 3 widget requires to go to each widget and export to Excel, resulting in 3 diffrente Excel spreadsheets. Users are requesting to be able to export every widget data into one single Excel file / each data widget in one seperated tab. This features exists in ReportManager, so it is difficult to understand why it is not available from the dashboard view. Thank you and regards, Franck

Astroraf · ‎07-17-2024

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.

bminehart · ‎07-17-2024

The only way non-Owners of Dashboards become aware of a Dashboard being republished is if (a) they happen to notice changes in the Dashboard design since the last time they viewed the Dashboard, or (b) if the Dashboard Owner (outside of Sisense) proactively notifies Viewers that they have republished the Dashboard. I would like to see a feature where there is a visual indicator to non-Owners that informs them that "This Dashboard has been republished by the Owner since the last time you viewed the Dashboard." An Even Better If would be to allow the Owner to add notes when they republish, and these notes could be visible to non-Owners the next time they open the Dashboard.

pb_si · ‎07-15-2024

The behaviour of the From/To date component appears to be causing a lot of confusion new users - we have had multiple reports mis-selecting dates and/or thinking this is a problem with Sisense. The problem appears to stem from the way the focus is automatically shifted to speed up input of the 'To' date. This is not expected by new users and causes confusion. When a date is selected in the 'From' box... If no date set in the 'To' box, move focus to 'To' box and allow the user to immediately select the 'To' Date If date already set in 'To' box, do nothing. So, the first time you set the date range the first click sets the 'From' date, and you can immediately set a 'To' date with a second click. This is handy, but at the same time confusing if you don't realise what it's doing, and in practice is causing complaints.

fschleich · ‎07-12-2024

Currently, the aggregation function depends on the type of the dimension : - Text or date => Distinct count - Numeric => Sum In our use case, this default assignation is not always accurate as it is sometime required to use Distinct Count with numeric fields. It would be good to hauve the default aggregation function to be choosed by the cube designer, when developping the metadata layer (ElastiCube or Live cube). This way, the dashboard designer will be proposed the accurate function without need to change it. This is particlary interesting with a users population that don't have analytics background and for which choosing the correct agregation function is not obvious. Thank you

DRay · ‎07-09-2024

We are trying to investigate how we can trigger a Sisense data model (schema) refresh from the API. This call would be made after a data pipeline schema change. We’ll need the calls to make to "Refresh Schema" how it is done in the UI. Original Community Post by @haarishussain : https://community.sisense.com/t5/help-and-how-to/sisense-api-model-refresh/td-p/21719

cjakerle · ‎06-27-2024

Currently the Usage cube has a dimUsers table that has User Name but it is the email address. It can be tough to know just from an email address, who the person is. It would be nice to have the First name and Last name of the user available. Certainly I could try to make a connector into the mongoDB and lookup the First/Last based on the user id. But a) I don't want to modify the out of the box usage cube and b) that seems like a lot of work for something that could be added as part of the out of the box usage cube. Thanks, Chris

reporting-mryum · ‎06-23-2024

We currently have SSO enabled for our product development but we also have internal users who need to reset their password once in a while for personal or security reasons. But the current behaviour is "if you have SSO enabled, users won't receive an email when they click forget password and only admins can reset their password instead". This is very troublesome and if you have a large organisations with hundreds of internal users, it is very difficult for the admins to manage that expectation. Would really like to get some help from the dev team and allow "forget password" even when SSO is enabled!

Tim · ‎06-23-2024

Two problems: Datamodels store old connection information without the user being aware. That increases the chance of accidentally exposing credentials to a different security context. Sisense R&D said that the reason is to show Recent Sources. When you change a dataset, you can end up with two copies of the dataset, which is confusing. Ideas for improvements (take some or all): Sisense could track the Recent Sources separately. Then Sisense could automatically remove empty datasets. Sisense could show empty datasets under Data Sources in the data model editor UI, and give the user a delete button for them. The Data Model editor could have a drag-and-drop to move tables between data sources. When you click export, there could be a checkbox "Remove data source connection information". More detail about the problems here: https://community.sisense.com/t5/support-portal/bd-p/SupportPortal?page=casedetails&caseId=500Pk00000Es4PyIAJ and here:https://community.sisense.com/t5/help-and-how-to/models-have-empty-datasets/m-p/20632#M222

wallingfordce · ‎06-21-2024

When filtering on a numeric field and using a Value type filter, I often want to filter on a dynamic value. As the Ranking type filter can take a formula, I would make good use of a Value type filter that also allowed for a formula.

wallingfordce · ‎06-21-2024

It takes 5-10 seconds to load the Manage Cases page in the Support Portal. It takes even longer to open a specific case. A case can only be opened in the same window as the Manage Cases page. To go to another case requires going back to the Manage Cases page first and waiting for it to load again. Please allow cases to be open in a new tab so that the Manage Cases page doesn't have to be reloaded so frequently, and many cases can be open and loaded concurrently rather than one at a time. Thanks for considering.

DrewGillow · ‎06-20-2024

Goal Enable dynamic alerting based on history using formulas Enable reuse of conditional coloring rules for pulse threshold Background Pulse allows you to trigger off of a threshold (e.g. > 10,000, <= 10) Conditional Coloring of widget values allows for functions (e.g. Min([Months in Date], [# of unique Transactions]) Perhaps the Automatic anomaly detection does this, but we have no visibility into what is results in an anomaly. Also not sure if you have to wait for the anomaly detection to learn. e.g. the cube has been built every day for years and has years of data, but the widget was only created a couple weeks ago and the pulse alert was added yesterday. Will it detect anomalies or out of bound conditions that we could write with a formula Desired Functionality Enable use of functions in Pulse thresholds similar to Conditional Coloring of widget values Ideally enable reference to the Conditional coloring options for the widget. The dashboard designer already built it into the dashboard. The user just wants a pulse alert when the widget turns RED. Provide means of selecting from existing conditional coloring rules (Whether they are static values or forumlas) when building/editing the Pulse tile.

Sisense Community

Default Break By behavior should be Rows instead of Columns

ability to use the same column twice in a filter

customize automated email templates

Dashboard search - custom behaviour

SQL Editor to run output of Analyse SQL

Cubes hold sorting when navigating away and coming back

Ability to change timezone for build schedules

Email Digest for end users

Every widget data exported into Excel

Custom Code for Multi-Tenant Environments

notification to Viewers after Dashboard is republished

Date picker UX is confusing for new users

Defining the default aggregation function per dimension

Refresh Schema via API

Provide User Name in addition to email address in Usage cube

Allow user to "receive forget password email"/"reset their own password" when SSO is enabled

Datasets UI

Allow Value type filters to use formulas rather than just hardcoded values

Allow opening support cases in a new tab

Allow Functions and reuse of conditional coloring rules in Pulse Thresholds