Hi, I want to show in my dashboard the values of the last 12 months period. As I do not want to select the month every month manually, it should be dynamically taking always the last 12 months. So far I am using the advanced settings in the filter: { "last": { "count": 12, "offset": 0 }, "custom": true } The issue is, that my available data is not always up to date. Therefore, I want to select the last 12 months counting the offset back 2 months from the selected month in the filter. As far as I understood is that the offset counts back from the current date disregarding the filters settings. I would need something like thi: { "last": { "count": 12, "offset": 2 (counting from date selected in "sale date" filter) }, "custom": true } ... View more

For now, dimensions are displayed to the dashboard designer in the alphabetic orders of the tables / columns names. I would like the datamodel designer to have the control over sorting / grouping the dimensions. Ex : 3 tables Address Number Street City City Zip code Country Country Currently : the list of dimension will contain 3 groups: Address / City / Country The columns in each will also be sorted by alphabetic order.  Expected : the datamodel designer will choose how he want these columns to be displayed, for instance, under one single group : Address Number Street Zip code City Country     ... View more

Currently, when using the Usage Analytics EC you do not have the ability to audit for everything you need when it comes to what your users are downloading.  Right now all we can audit for is PDF, Image, and CSV.  I would like the ability to be able to audit for Excel, PPT and any download options that are made available. Management wants to know who is downloading what, but right now we can only give data for some items and only for 30 days.   I would like to be able to have a larger selection of items to audit that utilize a customizable timeframe for how long to retain history for a select data point. If we are to audit for a pattern of downloads 30 days does not meet our needs.  Currently, if we want to audit for more than 30 days, we would need to get the data in a format that can then be loaded into an external DB that can then be reincorporated back into an EC for reporting.  This seems to be a waste of time and resources when this should be able to happen in the source system. ... View more

Sisense ElastiCubes are the biggest consumer of our snowflake credits because we have to build our cubes every 30 mins to keep data fresh in Sisense. It would be useful to have time of the day level control on scheduling the build. Like Build daily at an interval only between the hours of x and y or other cron based scheduling. cron scheduling would be great since it allows us to set build windows, not build as frequently on weekends, etc. This would immensely help with cost saving. How quickly is it possible to have such a feature? ... View more

Hi Team,  When we import a lot of files (CSV for example), we have to select each file one by one. Could it be possible to select a lot of files with one click ?  Best    ... View more

Is there any way to show all the values in millions even if data is in thousands, the default million formattings will show the values less that a million in the regular format         ... View more

Hi Team, we are trying to format my currency value only with M (Million) format. Sisense gives a full number when the value is less than 1 M. Is there any way we can bring the values to 0.01 M. Thanks, Nazeer ... View more

I have previously worked with Periscope and found the SQL Snippets tool to be very helpful (https://dtdocs.sisense.com/article/snippets#:~:text=To%20create%20a%20SQL%20snippet,button%20and%20name%20the%20snippet.&text=Snippets%20with%20these%20characters%20included,the%20box%20and%20click%20save.) Now my team use Sisense Fusion and we still have a need for this tool, despite it not being a feature in Fusion. We hope to have it available in the future.  ... View more

Regex is of course supported when querying through the import MySQL query, but custom Sisense tables do not support regular expressions. It would be useful to have regex functionality in custom tables and custom columns as well. ... View more

Current State: As of now Sisense supports adding of pulse alerts only for select chart types, like, Indicator, Area, Line, Bar and Column. Expected State: Sisense shall allow rest of the chart types as well to add pulse alerts. It is observed in other competitive products to be available for all the chart types. Customers like us (Blackline) have many use cases of tabular widgets and end users expect alert to be added to these widget types.  ... View more

Current state - You can only use color conditional formatting on numerics in the value section of a pivot table.  But it would be nice if you could also apply color formatting on text.   An example of this would be green on the value 'Confident', orange on the word 'At Risk' and red on the word 'Not Possible'. This text would be values existing in our database, not something created within Sisense.  ... View more

Add the ability to adjust the BaseTableMaxThreads at the Data Group level. This will allow for "right sizing" memory allocation that is consumed during the build process.  For example, I have low priority elasticubes residing in the default data group. High priority elasticubes reside in a "High Priority" data group with custom settings for "Stop When Idle", RAM, etc. Currently, our environment is configured to load 3 base tables concurrently (BaseTableMaxThreads  = 3). This setting impacts both high and low priority data groups. I want to be able to set my low priority data group to only load one table at a time (BaseTableMaxThreads  = 1) to reduce memory consumption on the server during builds. I want my high priority data group to continue loading 3 tables at a time. The trade off is the default data group will load data slower but will consume less memory/CPU during builds, freeing up resources for the high priority data group. ... View more

Currently the way the Sisense creates its query for dashboards, is it creates a common table expression for each entity created in the data model. Then applies the date filter after the join between the CTE.  During this process, it looks like its scanning the entire table of the CTE, which can be problematic if the underlying table used in the CTE is really large.  It will be better if the filter for dates can be applied within the CTE for such large tables, thus avoiding large table scans and help load the report faster. Is there a way this can be achieved by altering the design of the data model? or are there any plugins to support it? ... View more

Hi, We have two cloud servers in Sisense: one for development (staging) and one for production. The staging server connects to our staging database. The production server connects to our production database. All cubes and dashboards are identical except for database connection strings and names. Our Git branching strategy follows these steps: Create a feature branch from staging. Make changes and push them to the feature branch. Open a pull request from the feature branch to staging. Test changes in staging. If approved, merge staging into master (production) to deploy changes. The Issue Git integration tracks database connection names, meaning both servers must either run on staging data or production data—this is not feasible for us. Proposed Solution We suggest implementing a decentralized environmental variable for storing database connections. For example: Use {database-server-name} as a placeholder in configurations. Set database-server-name = db_server_staging on staging. Set database-server-name = db_server_production on production. This would allow the same codebase to dynamically connect to the appropriate database without manual adjustments. Would love to hear your thoughts on this! ... View more

Hi all, Can there please be a way to export and import the "Look and Feel" themes in Sisense? At the moment, I've got a dev and prod instances for Sisense and 50+ clients who we aim to have custom themes based on their company branding and colour schemes. After making and testing one out in Dev, I'd love to be able to just copy a theme over from Dev to Prod when promoting a dashboard up instead of the current process of going through each individual settings and copying each colour one by one. Kind regards, Shams     ... View more

When using Starred Filters, end uses can create their own filter and save the selection for repeat use. However, any Starred Filter created will be visible to all users regardless of their Group or Parameter assignment. This is because these items are stored in the Data Browser as additional elements linked only to the data source and not to a user or group. As a result, this causes confusion, lack of control where one end users Starred Filters can be removed by another and concerns about data security. Appreciate utilising multitenancy would be a solution, however, this is not possible in all circumstances and requires a significant amount of additional administration.  I am recommending a functionality change to control / limit the visibility of Starred Filters to the User or Group that created them.  ... View more

It looks like the sorting on compose SDK charts is very limited.  You cannot pass a predicate (callback function) to define your own sorting, you can only specify ascending or descending. So, if that's the case, anytime we need to be able to sort a column by another column, we'll have to use the queryService and sort it ourselves. ... View more

We would love the option to limit User Creation by Admins to only specific @mycompany.com This would improve security without SSO login - as SSO doesn't fit to our workflow. ... View more

Suggestion for improving subscribed dashboards: Include the date/time of the last cube build in subscribed dashboard emails.  Currently, we see the date/time per the settings configured in the subscription. We'd like to also see the date/time that shows when the data was pulled, or the "as-of". If there is a discrepancy in data, or if/when we need to trace back and review platform data changes, or if changes are made after the subscribed reports that may be important to call out to shared dashboard subscription recipients.  Thank you! ... View more