Today, we can use plugins, dashboard and widget scripts to customize dashboard and widgets for scheduled emails as well as desktop. Same should be available for Pulse scripts which allow to modification of alert JAQL on the desktop, but the same script is not executed when sending alerts/notifications. This causes discrepancy between what the user sees on the desktop and what they receive in email. ... View more

Add the ability to programmatically export a Widget with specific filters and/or to export it as a certain user using the /dashboard/{id}/widgets{id}/ endpoint. User Story#1 As an admin I want to make api calls to the widget pdf export endpoint and include userid and custom filters so that I can download an export on behalf of another user in the system and specify the filters  Acceptance Criteria I can pass 2 properties to the export endpoint: User Id and filters Both parameters are optional and can be used separately from each other If a user Id parameter is provided, the Widget is exported on behalf of the provided user including the current filters applied and data security rules. If a custom filters parameter is provided, the Widget is exported with the custom filters. There is no merge between the existing Widget filters and the custom filters parameter.  The is an option to provide an empty custom filters parameter, in this case, no filters are applied to the dashboard.  User story #2 As a user (not admin) I want to make api calls to the Widget pdf export endpoint and include custom filters so that I can download an export with custom filters  Acceptance Criteria I can pass a custom filters parameter to the export to the Export endpoint The custom filters parameter is a jaql query that will replace the current dashboard filters The custom filters will respect my data security  I can provide an empty custom filters parameter that will remove all filters from the report. ... View more

Hi, Working on a dashboard containing 3 pivot tables. Each have a lot of columns. (see print screen attached). In order to have a proper PDF, I need to turn the page format to A0 / landscape When exporting to PDF at the Dashboard level (from the pdf button top right), I access to a PDF setup, where I can choose the layout (landscape) and the paper format (A0), so that all the columns appears properly. In this screen, there is a Save button so that the PDF setup is saved for next time (see print screen) When exporting to pdf at a widget level, the same setup otions are available (landscape and A0), BUT THERE IS NO SAVE BUTTON. I have to redo this setup each time (see print screen). Could we have the the Save button on the widget / PDF option page, same as we have ar the dashboard / pdf option page please ? Thank you ... View more

This is a request to enhance this feature in community thread of the same title. This is useful because it allows users to see all the available dimension for a particular list of filters even if there are no facts for it. I understand that we can also use this community thread; however, this is only limited to 1 dimension. However, right now, it does not work when [Columns] field are added into pivot table. We would like to add a date/day [Columns]. Ideally for us, the left outer join should only be by the [Row] and allow data to be broken into [Columns]. ... View more

Currently, any report having a table widget is missing IDs in<td> and <tr> elements of the <table>. We are writing automation testing scripts for which we need to have unique ids for each cell. This is seen in Campaign tables but not for Reports 2.0 dashboards. Cell id, where each cell would have some unique identifier for entire table. ... View more

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

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

This is an "add on" request to this product request. Our customers need to be able to filter on datetime columns using a combination of both the date and the time. I'd like to see this added as a capability of filtering. For example, I'd like to filter records from "0800 yesterday to 0800 today". Or "0800 on Monday to 1700 Wednesday". Or "0800 4/1/23 to 0800 4/5/23". ... View more

When viewing a Dashboard, it is impossible to determine whether there are filters being applied at the widget level without opening each widget individually and reviewing whether (a) the inheriting of Dashboard-level filters has been disabled and/or (b) if additional and/or conflicting filters have been applied at the widget-level. This makes troubleshooting and/or viewing Dashboards very cumbersome. I'd like to see a simple visual flag from the Dashboard view indicating that "there is a filter applied within this widget". It doesn't need to display what that filter is -- only that there is (or is not) a filter within the widget. ... View more

When the sisense user is deleted the email of this user is still in the recipients list for a report in the Report Manager. If the report Manager is configured to send the reports to external customers, the user who is no longer with the company will be receiving the reports with dashboard data as the reports for the external users are generated using the owner or an additional user. Thanks. ... View more

The email schedules have a limitation when the file used in attachment is large in size. Most email servers have a 25mb max limit.  It would be really helpful, if there was an option to include a downloadable link in the email. When a user schedules an email, with the link option, the attachment is downloaded to a temporary path and the link to that path is provided in the email. Clicking on the link should download the file from the temporary path which can be an s3 bucket or from some server. We can keep a retention policy of few days for the files. ... View more

When we are building pivot tables, sometimes there is a need to sort things by the columns. If I want to show a pivot table with a Team Lead as the rows, Total Spend and Total Volume as the values, and Weeks as the the columns, I have no way to sort this to show the date in descending order and keep the table structure the way I want to see it. I think it would be helpful to have this option. ... View more

When using dependent filters and selecting new filter values this automatically resets all filter values already chosen.  Whilst this is desirable from a security perspective, not all models have security applied.  The proposition here is to have a toggle or similar that the designer/owner of the dashboard can use to turn this behavior on/off.  Thus the reset reasoning behind this can be maintained if required for that model or use case and the behavior can be turned off if non resetting is optimal for the use case needed. ... 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

NOTE: This is based on a post I made in the "Help & How To" forum. It was recommended to me to make a post here, in the Product Feedback forum, about it. There should be a way for Sisense to display the currently-selected filter values directly on the dashboard. I know that users can see this by expanding the right-hand sidebar to see the Dashboard Filters, and it's also a display option when you export to PDF. However, these aren't always obvious or available to the intended audience for the dashboard. For example, if I have a dashboard that's setup with a dashboard-level filter for "Work Group", it would be nice if I could display - directly on the dashboard itself - what work group is currently being filtered down to. Also, some of the values can be unclear, especially for date filters that use colloquial language such as "This Year" or "Last Quarter". There should be some way of displaying the exact date ranges that are being filtered for. For example, if today is November 13th 2024, then the "Last Quarter" filter value would mean dates from July 1st 2024 through September 30th 2024. But after the new year, if I were to check the dashboard again on January 6th 2025, then the date range would instead be from October 1st 2024 through December 31st 2024. Currently, in both cases, it'll just still how as "Last Quarter" and it's up to the user to figure out what that means (which can be difficult if they're looking at a static printout from some unknown time in the past). Other time periods can also be ambiguous or prone to misunderstanding. For instance, it's common to see people assume "Last Week" means a rolling time period covering the last 7 days, rather than the prior calendar week. Or assuming "Last 2 months" means the same as "this and last month", rather than the prior two calendar months not including the current month.  ... View more

Hi, I have issue with setting two date dimensions in dashboard. The goal I want to achieve is to have a history of records, which are also have it's own date dimension. You can download model and dashboard. I would like to have difference in growth ower selected period for defined dates. For example 2 days ago I sold a car for 1000, and yesterday the proce have changed to 1500. The sale date is for today. So the growth over 2 days is 1500, and for 1 day 500. Additionally i would like to compare those values to previous year, and go back with both date dimensions. Tricky part is also, that if there is not sale for this year, PastYear() wont count prior year. I tried to play around with filtered measure plugin, however it doesn't give me exactly what i want. Do you have any suggestions how can I approach such data and 2 date dimensions? Thanks 🙂 ... View more

The helm chart supplied with Sisense allows global annotation of all service accounts within the sisense namespace. For example I can annotate an AWS role that is able to be assumed by pods: helm upgrade sisense ${sisense_chart} --namespace sisense \ --reuse-values \ --set global.serviceAccountAnnotations."eks\.amazonaws\.com/role-arn"=${pod_role_arn} While this covers most of the pods by updating all the sisense-* service accounts in kubernetes the ec-build pod (the one that actually builds the elasticube) only uses the default service account in the sisense namespace. A workaround is to annotate the default service account: kubectl annotate serviceaccount default eks.amazonaws.com/role-arn=${pod_role_arn} --namespace sisense But it seems odd that the pod would a) assume the default service account when all other pods have service accounts explicitly defined for them and b) despite having gone to the trouble of wiring up global service account annotations in helm for them not to be applied at the final step of elasticube building. This specific use case is for supplying web identity tokens to a JDBC driver so that you can interact with AWS by using a specific OIDC assumed pod role, rather than using an EC2 role or worse, static credentials in a file or connection string. Even more specifically using CData JDBC parquet driver with S3.   ... View more

Hi, Whenever an user with owner access is deleted, all the dasboard created by him are getting deleted. Also, those dashboards shared with others are also deleted. This looks like a critical issue, since the dashboard will be shared among other users, they won't be able to see any dashboard if the user gets deleted. Atleast the dashboard shared with other users should be retained.   Thank You, Deviprasad ... View more