**Please note this idea was migrated to the Product Feedback Forum from older submission areas** The Data Designer, when modeling an Elasticube or Live model isn’t able to define the default aggregation method. When adding a measure to a widget, an aggregation method is automatically applied. The Dashboard Designer can choose the aggregation method via a menu, but a regular click will always choose a predetermined system-wide defauilt (distinct count or sum). In some cases, the aggregation applied is not relevant and could lead to invalid results. I would like to see a feature that allows a Data Designer, when designing the data model, to define the default aggregation for a column. A Data Designer has the knowledge of the data model and what aggregation is best used for it. This ability would assist Dashboard Designers in correctly using the model. ... 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

As the platform has users across the globe, the timezone chosen for reporting must get aligned with the logged-in user's locale. SiSense already displays the ElastiCube's last build time in the logged-in user's timezone. In similar lines, whenever a widgets reports intra-day transactions / volumes, an option to display the data in logged in user's timezone should be made available by default in the SiSense platform. ... View more

My team was adding scripts to widgets to add attributes to the embedded widget and noticed an opportunity to expand what metadata we can use in the scripts. Currently, we're using the widget description (`desc` field) to set a testid attribute, but by default that description is viewable in the embedded widget.  I'd love the ability for designers to add key/value pairs to the Widget class metadata that are accessible in the widget script. widget.on('domready', function(w) { const { oid, customMetadata } = w; // customMetadata is the new (optional) property on a Widget const testId = customMetadata['testId']; // a key/value pair added by designer const selectorString = `[widgetid='${oid}']`; const widgetElement = $(selectorString); widgetElement[0].setAttribute('testid', testId); });   ... View more

We have a client who really wants to leverage email preview (rather than or in addition attached PDF) to send important metrics to their leadership team.  However, most of their reports do not fully display because the preview only uses portrait mode. Request the ability to either specify portrait/landscape mode when setting up the schedule, or just naturally follow the format that best fits the dashboard. ... 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

Hi all, Repost of my question in the community forum: Let's say I have a bar chart in my dashboard displaying number of customers over time with customer segments (small, regular, top) in the break by field. When I turn on 'widget affects dashboard filters' I noticed that the dashboard filters are not affected by whatever is in the break by field. I would like an option where I can filter the dashboard by both. From a user perspective it also makes sense. E.g., when a user clicks on the top segment in february 2022 then all other widgets in the dashboard show the values for top customers in february 2022. Kind regards, Kevin ... 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

Our clients always have limited inventory to sell. What they sell is constantly changing. When forecasting future results, the prediction frequently projects results beyond the saleable inventory. Our clients a neighbor indicator widget showing the maximum capacity for the given product, and then edit the forecast hardcoding the value into boundary maximum limit. However, this prevents the widget from respecting dashboard filter changes that switch between products. Instead, it would be most helpful if the boundary limitations could also be configured as calculated values from the data. ... View more

Sisense currently supports Shared formulas to be moved as a part of data Models only. However not all Designers have access to edit/view data models So, they can't move shared formulas from one environment to another via data models Shared Formulas should be exported along-with Dashboards also   ... 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

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 create a basic set of pre-built dashboards that we publish, where business users can view but not modify.  We also have two-tiers of analytics offering for business users (standard and premium).  On our common, pre-built dashboards, which are available to both standard and premium, we would like the ability to expose Simply Ask to only those users of premium (hiding it from those who are standard).   While this may be achievable via a 2-model, 2-dashbaord set approach, we desire to manage a single set of dashbaords and model to simplify deployment overhead and maintenance. ... View more

It's the standard in our industry that products are on sale only for a limited time. For example, tickets being sold for an event aren't sold after the event has occurred. But there's not way to forecast future sales and prevent the forecast from predicting sales after the event has passed and no sales can possibly happen. Instead, customers have to edit every forecast that is currently predicting beyond its event date, every day, to predict only the correct number of future periods.  We'd like a way to predict N future periods, but not past a point in time at which inventory is scheduled to be no longer available. ... View more

**Please note this idea was migrated to the Product Feedback Forum from older submission areas** Custom queries are case sensitive by default. There are workarounds possible, but are just not productive. Every custom query requires something similar to the following: LEFT JOIN [MedStorageUsers] mu ON upper(mu.UserID) = upper(c.UpdatedBy) I want a global option in Sisense to automatically add tags that makes all custom queries case-insensitive ... View more

When a widget returns no data and is displayed in column format - it would be nice to have an option to show the column headers only to give users a reference point as to what data will be shown. Thanks ... View more

It would be better to have more control options over exactly when the email report for a dashboard is triggered out to users. Currently we use the option "Every Elasticube update. No more than 1 emails per day" but that has issues: 1) We would only like the email to send if the Elasticube update is successful, rather than every update (including build failures). Otherwise we send a report out with missing data. 2) The rule of "No more than 1 emails per day" doesn't seem to be working properly. Meaning if we refresh the Elasticube more than once per day, users are receiving duplicate reports. ... View more

Currently Notebooks provide a powerful opportunity to access and visualize data utilizing SQL and to add these to fusion dashboards.  Fusion's primary analytics environment allows for powerful dashboard-wide filters.   Currently dashboard filters do not apply to charts or tables which are created through notebooks even if the notebook is pointed to the exact same data table and column as other dashboard widgets.   Please develop the ability for dashboard filters to filter both fusion dashboard widgets and also notebook-based widgets.   ... View more

When using Sisense Live Models, the lowest level of granularity when visualizing date-time data is “Round to 15 min”, not at the minute level. Versus, when using Elasticubes, the most granular option is every minute. It would be incredible helpful for us to have granularity at least to 5 minutes for Live Models because we are working with IoT data that we want to visualize. ... View more