ccoelho
Cloud Apps
Joined 3 years ago
User Profile
User Widgets
Contributions
Re: Overwrite filters in report manager
Hi DRay I had a look at the post. However, that is a feedback request to hide the "Apply custom filter" option in the report manager UI and its a different use case. In our case, we are looking more to enhance the "Apply custom filter" option , to display some user friendly interface where users can overwrite/change the filters in the dashboard rather than doing it via JAQL code, which many users may not be familiar with.197Views1like0CommentsOverwrite filters in report manager
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.Estimate/notify the result size before execution of the query in the dashboard
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.Ability to create seasonal report schedules in report manager
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.Enhance table widget page controls
The page controls to change the pages are currently within the widget and its functionality is limited: Thus, if the number of rows to be displayed are increased to 50 or so, the widget window would get expanded and user will have to scroll to the bottom of the dashboard to see the page controls or change the widget page. This can be avoided by placing the page controls at the bottom of the widget window and not limiting it to the size of rows. So the widget window size stays fixed and the user can scroll through the data within the table widget. This also helps view the dashboard in the page without having the need to scroll down at the bottom of the dashboard. Additionally, also allow the viewer to increase the number of rows to be viewed in the widget. Example, a user should be able to increase the number of rows for a table widget to fixed numbers as 50 or 100.Filtering by column in table widget
To filter any data we need to add the filter on the right panel. Though this is possible only for a desinger and if a viewer wants to filter any other columns in the widget after the result set is displayed, they will need to download the table and filter in csv/excel. It will be really nice to be able to further filter the result set by viewer after the data is processed/displayed by having this option visible on every column header. Currently, clicking the column header only sorts the data, keeping a filter option on every column can allow the user to narrow down the results before downloading the file. Using this option, the viewers can filter any of their columns in table widget without having the need to download and analyze the results outside sisense.Add indicator for downloading a widget
While downloading a large csv/excel file (over several hundreds mb file) from the widget, there would be a long delay of couple minutes before the browser indicates the file has been downloaded. During this time, the user has no indication if the request to download is in process or has failed. It would be good to have an indicator to show the download of the file is in progress, so user would not click the download multiple times thus causing multiple queries to hit the backend.Optimize data model for improving performance
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?Disable recipient email id suggestions from Report manager
In report manager, when trying to add recipients for email, we receive sisense user email id suggestions based on keyword entered. This can be confusing to users, as our end users send emails to external recipients(non sisense) and that email id suggestion is sisense internal user email. It will be really helpful if we can have a functionality to disable these email id suggestions from popping up in report manager, and avoid confusion to users.