L2023.3 Release Notes DateDiff Functions with Now() as a Parameter A dashboard designer can calculate the difference between a value of a date dimension and the query execution time (according to the Sisense server). Now() can be used as the <end time> parameter in the following formulas: {DateLevel} Difference. See the description of each of these formulas in Dashboard Functions Reference. It can also be used as the <start time> based on testing though the documentation explicitly only mentions <end time>. However, if you try to populate the function with a <time field> you'll receive a syntax error. The syntax is listed as  DDiff(NOW(), <start time>) To use the NOW() function as a value filter Dashboard Functions Reference #NOW_Function The syntax is listed as ((<numeric field>), NOW(<time field>)) Attempting to exclude the <time field> results in a formula error.  We and our clients find it confusing that the <time field> is required in one case and explicitly not allowed in the other. ... View more

"Reminder: Your Feedback is Important!" However, it's really hard to know which of my support tickets I'm rating. Tickets are sometimes closed hours or days after I comment that they're resolved. Other times they're closed without my saying so. I don't want to rate the assistance I received based on the wrong ticket. The Sisense Case number is provided at the end of the email, however, given that it's a time-consuming experience to visit and interact with the Support Portal: Allow opening support cases in a new tab - Sisense Community And assuming Support Portal performance is a big challenge, maybe providing the support case title in the survey is more achievable.   ... View more

Currently line graphs allow for selections to be made on the graph which then propagate to the dashboard filters. This is showcased in this link: https://docs.sisense.com/main/SisenseLinux/making-selections-in-a-widget.htm It would be nice for a widget to have the option for the selection to be either for the dashboard filter or that specific widget's filters. For example if I had a single widget that used a specific column of a table as that widget's filter then I want to select and add it there instead of having it appear as a new dashboard filter. That way a new filter won't appear as if it affects the whole dashboard when it only affects a singular widget. ... View more

Add Support for OR condition between dimensions in Custom Row Level Security Plugin   Plugin Home Page - https://www.sisense.com/marketplace/add-on/custom-row-level-security/   Example:   {     "rules": [         {             "dim": "[employee.gender]",             "members": [                 "Male",                 "Female"             ]         },         {             "dim": "[employee.country]",             "members": [                 "Russia",                 "India"             ]         }     ], "includeAll": false, "excludeAll": false }   currently evaluates to   employee.gender in ("Male","Female") AND employee.country in ("Russia","India")   We request to add a new feature in the plugin that supports evalation of OR condition between 2 or more dimensions; or in more complex scenarios a mix of AND and OR conditions.   Example Psuedocode:   employee.gender in ("Male","Female") OR employee.country in ("Russia","India")   The JSON format can be something like below:   Example 1 (OR): {     "rules": [         {             "condition": "OR",             "dimensions": [ { "dim": "[employee.gender]", "members": [ "Male", "Female" ] }, { "dim": "[employee.country]", "members": [ "Russia", "India" ] } ]         }     ], "includeAll": false, "excludeAll": false }   Example 2 (mix of AND and OR): {     "rules": [         {             "condition": "AND",             "dimensions": [ { "dim": "[employee.age]", "members": [ "20", "30", "40", "50" ] }, { "condition": "OR", "dimensions": [ { "dim": "[employee.gender]", "members": [ "Male", "Female" ] }, { "dim": "[employee.country]", "members": [ "Russia", "India" ] } ] } ]         }     ], "includeAll": false, "excludeAll": false } ... View more

Sisense´s metadata-translations plugin currently supports the translation of texts used in the different types of widgets. This is not the case for Blox and Tabber elements. If you use translations of the dashboards to different languages, it is essential that ALL elements are translated. Therefore, it would be great to have all texts in all widget types to be translated using this plug-in. ... View more

Hi, Related about multitenants, we are unable to: - Execute Custom Code in an EC inside a Tenant - Acces the file system from an EC in a tenant so refer with BloX to assets is a nightmare (image icons etc.). - GIT - Look&Feel And more There are other kind of limitations that makes the multi tenancy a nightmare. If you are going to continue providing this feature to customers, we expect to add functions you make it usable to end user.  Best ... View more

Some of our users asked for "lock the top widget (with scrolling the rest widgets)" functionality. Is it possible to add it in Sisense in near future?  ... View more

Currently we cannot granularly control the label names or remove them when using the export modification plugin. The refresh time label is aligned with Sisense data refresh time instead of our internal refresh time. This changes the value that users are expecting to see in that field. Can we update the plugin to allow us to toggle that label off? ... View more

Currently , If we have to create a schedule using report manager, we need to save a copy of the dashboard with the filters applied and then schedule that particular saved copy. Thus, if for a single report i want to create multiple schedules, i have to create a separate dashboard copy and point the schedule to that copy. It will be much better if we can create the schedule directly on the dashboard and add filters specific to that schedule. The only option i see is to overwrite the dashboard filters using the 'Apply custom filters' option. However, this brings up a JAQL script which the end user may not be familiar with.  Thus, to enhance report manager, it will be better to add the below options: 1) Allow user to create a schedule in report manager from the dashboards page, instead of going to the report manager plugin. 2)Add some form of UI when adding custom filters instead of displaying JAQL code, so end user would be able to easily overwrite the filters in the same dashboard by creating multiple schedules instead of multiple dashboards.   Note: It is possible through a third party plugin, but would be better to incorporate this in the existing report manager plugin. ... View more

Current Functionality: The fiscal start year for an Elasticube can be set independently. Ex. in the elasticube fiscal year start is set as October. When a dashboard is connected to the Elasticube, the dates correspond to the Fiscal Year (FY) starting October. However, perspectives linked to this Elasticube default to a January fiscal year start. And there is no way to change the fiscal start year at the perspective level. Desired Functionality: When a dashboard is connected to the perspective, the dates should ideally correspond to the Fiscal Year (FY) in alignment with the parent Elasticube's settings or there should be an option to configure the fiscal start year exclusively for the perspective. Importance: This enhancement is significant as perspectives are being explored to enhance data and analytics implementations using Sisense.    ... View more

It would very helpful to be able to see the columns of a table in the Table Query section of the MySQL query build. Currently it just list the tables and you have to open another table then preview the table and scroll sideways to see the available column. You could create this in a tree view like SQL Sever does. This would help query writers by being able to see what columns belong to the tables, I included what SQL Server does for reference.   ... View more

While using the date picker for the column definition in the report if the column is defined at a years level Date picker still shows all other options for date formatting including quarters, days, time e.t.c, but if you switch to those they have no effect at all, since it goes off of column definition. Maybe those options should be greyed out, besides the one that can format data at the same level as defined in the column, to make it less confusing for the users, or as an alternative, if a different level of formatting is selected, to automatically switch column to that level of definition. ... View more

We have reports/dashboards based on a large underlying table. Thus, when a user tries to run a dashboard for a long date range which would result in many rows being processed, the dashboard may take time to load. It will be helpful, if there is a way to get the size of result set that will be executed using the query plan. Using that estimated size, we can compare the size to a threshold size defined for the dashboard and if the estimated size is greater than the threshold, the user can get a popup message which will indicate the result size being too large will impact the dashboard load time. Thus, in this case, the user can alter the filters to reduce the result size if it wants the results sooner or else will be expecting the results to take time due to its size. ... View more

Hubspot is widely used application for data ingestion and CRM data. I highly suggest that Hubspot become a native JDBC connector within Sisense because it is widely asked for among many users within Sisense. ... View more

Request: Provide a standard way for supporting multi-currency support. Use Case: Enable end users to create widget and dashboards where they can switch between multiple currencies. Background: There are various posts on how to implement multi-currency by adding an exchange rate dimension and using a formula similar to Local Amount = (Amount Field) * (Exchange Rate) and using a filter to select the desired currency (E.g. USD, EUR, GBP). This process works well when you have dashboard designers, but it doesn't work well if you want end users to create their own reports.  If they do things wrong the Amount may be multiplied by the number of currencies supported. They are required to enter a formula instead of simply selecting a field to report. Recommended Solution: Add ability to add Formula fields to the data Model.  The data designer would create a standard field with the formula.  The formula would be evaluated within the dashboard not during cube build.  Note: there are probably other uses cases for data model defined Formulas that are evaluated within the dashboard. Add ability for automatically adding the Currency filter when the data source is used. ... View more

Each time I want to share my dashboard, I click the Share button and make sure the person I want to share the dashboard with has the right permissions, and then I have to copy the url, making sure I covered it in fully. Instead, I suggest to have a "copy link" button in the form, which I can simply click and know that I now have in the clipboard the dashboard's url to share. Another option would be to have a "copy link" button that is revealed when I hover on top of the dashboard's name, to allow easy copying of the shareable link, even without opening the "share" form. ... View more

Sisense maps are running on Mapbox. Mapbox supports localisation, i.e. showing the map objects like countries, cities etc in a chosen language, see https://docs.mapbox.com/help/troubleshooting/change-language/. I would be great if Sisense could support translation of maps by e.g. giving the user's preferred language as localisation parameter to Mapbox. ... View more

We have a use case where a report schedule is supposed to run daily/weekly only during certain months of the year(seasonal reports). This could be done using the time frame section in report manager, however, at the end of the season, we will need to manually update each of the schedule's start and end date, which may not be feasible when there are over 100s of schedules as such. It will be really helpful to be have this ability in the schedules, so schedules can run only certain months in the years. ... View more

Hello, We recently had an AI demo meeting where we were shown some of the AI capabilities of Sisense. However, the LLM providers that are currently being supported do not align with the AWS eco system we are currently using in house. Would it be possible to support AWS Bedrock as an LLM provider? At the moment this is the only road block on our end from trying your LLM supported AI features within Sisense. ... View more