Allow updating filters in Edit Chart page

pausan-gh · ‎09-22-2023

When I'm editing or creating a new chart in SQL (chart being part of a bigger dashboard), I often find myself having to go in and out to change filters, or to just hardcoding values than later I have to change because inside the Edit Charts page I have no option of updating the filters. It would be great if there was a way of updating them inside that page. For example, imagine I'm creating a new chart page that requires a long query. I want to set it up so that it accepts certain filters. Good so far. Now imagine on the general dashboard the filter has "All dates" selected (just as an example). Then my query will take forever to run, and maybe, since I'm developing the query it would be nice for me to just select a smaller date range. There are more complex examples where the need of this becomes more clear. Imagine my query has multiple with clauses and/or joins with extra filters, etc... and I want everything to stay consistent. Then, if I have to go out and edit the filter, it might take a while for the dashboard to get all the data. For me, the ideal scenario would be to have a filter (e.g same as the dashboard where a chart is embedded on, or just based on the [name=value] attributes in the query) that is displayed in the edit area itself, so that I can select my parameters easily without having to hardcode those values only to remember to re-enable them again later, and I don't have to go in and out the chart to change the filters either. This feature would save me a lot of time and annoyance. Let me know if you need more real-world examples. But I found myself annoyed by this more than once. I think you have a great product, but it can be even better.

pausan-gh · ‎09-22-2023

I use Chrome browser. I keep multiple tabs of sisense opened. When the session expires, it expires on ALL the tabs (which makes total sense). The problem is that all those tabs get redirected to the login page and I need to login on each and every one of them. It does not detect I've logged in in another tab, neither if I hit the browser Refresh button it will detect the login and redirect me to the page I was in before I got logged out. This is annoying because I have to either login again, or open a new window and search for the dashboard I had open. Ideal expected behaviour (preferred, but probably harder): Once I'm logged out on several tabs, logging in one of them should make the others notice and log me in automatically. Good-enough behaviour ("easier"): Once I'm logged out on several tabs, logging in one of them should allow me to go to other opened tabs, which are showing the login windows, and refresh them (e.g using Ctrl+R) so that itwill automatically detect my session and redirect to the page I was before I was logged out. This will save me a lot of time and make sisense less annoying.

yklam28 · ‎09-22-2023

The default color scheme for the sunburst chart is defined per ring, while it should be per category. For example, category 1 has the red color, category 2 has green, and category 3 has blue color scheme

yklam28 · ‎09-22-2023

we want larger area to edit and view widget description

smorebs · ‎09-21-2023

A while back the JTD didn't pick up measured values properly and we configured our dashboards so that the measured value filters were not relevant to the jump. We have some situations where there are conflicting filters with-in the measure (e.g. comparing different things as a numerator and denominator). Can you add a widget config option to ignore measured value filters? It would require adding an item in config and then adding an if statement to the filtersHelperService.js in the getMeasuredValueFilters like if(config.ignoreMeasureFilter) return [] ; around line 560. This would greatly help us out as we do have fairly complex filters running and much more often than not want to only consider dashboard and widget filters in the Jump.

leonardocelisIM · ‎09-18-2023

Currently in version 0.9 /datasources/{title} is used for cancel all queries but also return a datasource. It is the only way to get a datasource by title. The other alternative is use the get datasources endpoint but the filtering does not work to filter by title. It would be really good to have an endpoint to get the datasource by title.

rimms-gladstone · ‎09-18-2023

The Sunburst chart is a great way to view multilayered data and obtain high level values and percentages from the source. Surprisingly, this visualisation does not support Jump to Dashboard (JTD) functionality which I would like to request. The ability to drill into the data is vital and provides users with an understanding of what sits beneath the chart should they require the detail.

fschleich · ‎09-15-2023

Hello, How about having a better control over queries parallelism ? My use case : Elasticubes using 2 connections : DB1 / DB2 Currently, the parameter BaseTableMaxThreads (sets to 2 for us) controls how many queries can run in parallel, whatever the connection. During build, we frequently see situations where we have 1 query on DB1 and another one on DB2. Reducing the level of parallelism was necessary to limit contention on one connection but it would be fine to have 2 queries on DB1 and 2 queries on DB2 at the same time. My proposal is the following : having a parameters to controls the level of parallelism per connection and not per build. Thank you.

Gannon · ‎09-14-2023

When utilising the Fiscal Year functionality, it is frustrating that there is no option to display the calendar year as a formatting option. We are based in Australia and our Fiscal Year starts in July, so our 2023/2024 Fiscal Year (called 2024) runs from July 2023 to June 2024. If I create a simple pivot with our Date, Year (Calendar Year formula) and Fiscal Year (formula in format YYYY/YYYY), then you can see that the date is actually distorted. There is no way to display that this date actually falls in 2023, which is the case for the first two records in the below pivot. Applying a filter with a date range handles this correctly, but it is confusing for our Finance department as to what date this is referring to. I've connected with Sisense support and they've provided a solution for a Date Display Field (thanks @AssafHanina) which does solve the issue, but then we need to have complicated rules for dashboard designers to use X field on their Dashboards but Y fields on filters, etc. I feel like an additional date format of "cy" for Calendar Year would solve this issue from the display side and make things much simpler. Some logic already exists for "yp" for the previous year, this would be very useful for our designers to have this additional option and to keep the date as one field rather than needing a second. Has anyone else encountered this issue or would find this useful?

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.

Gannon · ‎09-14-2023

Utilising custom fonts is great to accompany branding/styling guidelines, but a lot of font platforms (such as https://fontwerk.com) don't even provide TTF files anymore and are moving to other formats such as OTF. FontShop.com also refers specifically to this and that you have to download a type, not a font collection. The FAQs from Fontwerk refer specifically to the fact that they are moving beyond TTF ... But I really need TTF, SVG, EOT, WOFF fonts! No, you really don’t. From experience, we know that this sort of requirement often stems from an old habit or in a case where the old file formats are required because of old hardware. If this is the case or if you are unable to put old habits to rest, we will of course still be happy to produce the formats on request, but for a fee. https://fontwerk.com/en/faq It would be great if Sisense could support font formats in some of the more recent formats.

Bastien_Admo · ‎09-14-2023

Hi Team, In Support Portal we can have a lot of tickets raised and some of them are in Sisense side and some on our side. Will it be possible to retrieve the info if a ticket is waiting from us or from Sisense directly in a list view ? Thanks Bastien

wszewczyk · ‎09-14-2023

Hi. It would be cool to have a possibility do use external RabbitMQ instead one provided with Sisense Provisioner and hosted in Kubernetes cluster as StatefulSet. We would like to use managed rabbit cluster from AWS. The same case could be for MongoDB with AWS Document DB.

wizsoft · ‎09-13-2023

working with the plugin ExtenedPivotOnPDF shows the header of the Pivot only on the first page, doesn’t show starting form the second page. Please add header of table on all the pages.

Precisio · ‎09-12-2023

Currently, it appears that Shared Formulas are displayed in the selection dialog based on the order they were created. It would be great if they can be arranged logically, or at least sorted alphabetically, otherwise the list can grow to become disorganized and difficult to use.

Silutions · ‎09-12-2023

I have a client that has SSO users and non-SSO users. On Sisense advice, we have created a separate tenant for the non-SSO users. We expect that those users would have all user email features of users as if SSO did not exist on the system. We are finding that the new user invitation email is not enabled for these users (among other email functions). Therefore, these users are not able to set their passwords when they are created. As a result, we are using a common password for 600+ users. This is obviously not satisfactory. Those tenant users can now log in and change their password, but we have no way to enforce that they do this as we would with an invitation email. R&D has told us this is the expected behavior (refer to case #00746676). This behavior is not working well for my client. I would like all user email features enabled for non-SSO tenants.

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.

davidlin · ‎08-31-2023

Currently only user roles can be modified to disable PDF export, but cannot configure user to disable PDF export for specific user. We would like have this function the sooner the better. Thank you! David

dougnewton · ‎08-31-2023

At the moment, you can do row filtering in a Data Model, by applying an enforced filter. This works fine in simple scenarios. In my case, I have 150 different users who each need to be able to see only their own data. So I have to add them one-by-one to the data model's "Data Security" area. Not only that, I have to do this to 10 different cubes, so this will be a lot of manual effort to set up and maintain over time as people come and go. What I'd like to be able to do is define a custom attribute on the User record, like "Location ID". I'd fill it in for that user, entering "12345" for a particular user record. That User is also a member of a group called "My Restricted Group". Then, I could go into the Data Security section, add an entry for the Location ID filter, applied to "My Restricted Group", and reference the "Location ID" number. Then the system would enforce it at runtime -- is the logged in user a member of "My Restricted Group"? If so, apply a fiter on the Location ID field, and fill it in with the value in their User profile. Then I only have to maintain the Location ID value in their user profile once, and only need to apply that Location ID filter once per cube, not 150 times per cube.

fschleich · ‎08-31-2023

Hello, In a multitenancy environment, it would be useful to be able to define different "look and feel" theme for each tenant. Currently, the one define on the system tenant is applied to every tenant. Thank you.

Sisense Community

Allow updating filters in Edit Chart page

Detect I'm already logged in on "login" windows

Better way of assigning color scheme for Sunburst chart

Bigger edit area for widget description

JumpToDashboard ignore measured values

Get datasource by title endpoint

Add JTD functionality to Sunburst chart

Elacticube build - Level of parallelism

Enable Calendar Year Date Formatting (instead of Fiscal Year when set)

Allow Button Colour To Differ from Main Colour

Support OTF fonts

Support Portal - Info to who is working on the ticket

External RabbitMQ/MongoDB for example AWS managed Amazon MQ and DocumentDB

ExtenedPivotOnPDF & show header of pivot starting from page 2

Please allow arranging/sorting Shared Formulas in the selection dialog

Allow new user emails for Tenants that are not SSO users

Allow forecast boundary limits to be calculated

Disable export to PDF function for specific user

Row security (filtering) via attribute on User account

Multitenant - Define one "look and feel" theme per tenantn