Widow/orphan control in Pivot tables that have subtotals

dougnewton · ‎01-15-2024

Similar to widow-orphan control of Paragraph page breaks in MS Word... it would be nice to have this in pivot tables too. That is, let's say the existing rows/subtotals in a pivot table take up 20 out of the "rows per page" value of 25. If the next sub-section to display is going to take 3 rows, great, show that section. But if the next sub-section is going to show 10 items, it means the subsection/subtotal will be split across two pages. This is hard to remembe/digest/use when interacting with the dashboard. With widow-orphan control, it would do a page break "early" before showing that next subsection of 10 items.

DRay · ‎10-12-2023

We have a use case where we need a Viewer role to have the ability to import and share dashboards. The problem is that those elements are set to canBeOverridden: false. Please change share and import to canBeOverridden: true for the roles API.

mitratechonprem · ‎05-02-2023

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.

ndewinkle · ‎05-01-2023

To ensure security and compliance for HIPAA, we need to know when users export data. Specifically, we want to know how many rows were exported so we can check for malicious use.

ScheurK · ‎04-24-2023

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

SamAlbertCSM · ‎10-04-2023

Under an Admin Account and User Mgmt. it is not easily possible to sort the user role (ascending/decending) like it is with other columns. License utilization is one thing, but being able to easily filter roles and reassign as needed would be a huge help

qamardinpal · ‎10-04-2023

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.

filski · ‎05-01-2024

Hi - Is it possible or planned to allow Sisense Narratives to connect to a different LLM provider? We are hosted in AWS and have restrictions around data transmission, so would need to use an internally available provider such as Bedrock instead of Arria for NLG.

smccartney09 · ‎05-01-2024

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); });

Community_Admin · ‎04-17-2023

**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

jonbrier · ‎09-29-2023

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

soporteparaptx · ‎09-26-2023

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

Gannon · ‎09-14-2023

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.

wallingfordce · ‎09-08-2023

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.

ABFocke · ‎04-19-2024

we have data with timestamp from our IOT Device up to ms. we created the data model with our data and when we create a dashboard we can put a date range filter. but this filter work for year month and day. because we receive many data, we would like to be able to filter per hours and minutes like 10 Minutes or 2 hours. thanks, Alexandre

Edues · ‎04-17-2024

Currently, whenever a user starts a build in a cube, either everything is updated or only the changes that were made. It would be incredibly helpful to have the cube refresh only certain tables as indicated by the end user.

fschleich · ‎05-26-2023

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

mgkirsch · ‎08-22-2023

have JTD simply use include all for grand totals and pass the relevant include all for sub totals

Suryakant · ‎04-10-2024

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

mitratechonprem · ‎12-04-2023

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

Sisense Community

Widow/orphan control in Pivot tables that have subtotals

Enhance Roles customization

Ability to use landscape format when using the email preview feature

Log number of rows exported when exporting to CSV.

Filter by both the dimension and break by on the dashboard

Easily Sort User Roles in User Mgmt.

Filtered Perspectives

Sisense Narratives to connect to different LLM

Ability to add key/value metadata to widgets

Apply case-insensitivity option across all custom queries

Retaining formatting when exporting to Excel

Build monitor

Allow Button Colour To Differ from Main Colour

Allow forecast boundary limits to be calculated

date range filter with time

Enable cube refresh on specific tables only

Report Manager - Email notification - Customization of the text in the email body

Option to enable Jump to Dashboard on Grand Totals and Sub Totals

shared formulas while exporting dashboards

Shared dashboard indicator