Connection Tool - Programmatically Remove Unused Datasource Connections, and List All Connections
Managing connections within your Sisense environment can become complex over time, if there are a large number of connections, and connections are often added, and replace earlier datasource connections. In some scenarios unused connections can accumulate, potentially cluttering the connection manager UI with no longer relevant connections. Although unused connections typically represent minimal direct security risk, it's considered best practice to maintain a clean, organized list of connections, and in some scenarios it can be desired to remove all unused connections. Sisense prevents the deletion of connections actively used in datasources, safeguarding your dashboards and datasources from disruptions. However, inactive or "orphaned" connections remain after datasources are deleted or a connection is replaced, potentially contributing to unnecessary UI complexity in the connection manager UI. Connections can be of any type Sisense supports, common types include various SQL connections, Excel files, and CSV files, as well as many data providers, such as Big Panda. This tool can also be used to list all connections, with no automatic deletion of unused connections.403Views4likes3CommentsHow to update style sheets in the branding folder for dashboards
In this article, we will address the issue of updates made to style sheets within a branding folder not reflecting on dashboards. Users often encounter this problem due to browser caching, which prevents the most updated CSS files from loading. This guide provides solutions to ensure your dashboard reflects the latest version of your style sheets.211Views1like0CommentsLimiting Date Range Filters in Sisense Dashboards
Wide date ranges in Sisense dashboards can lead to performance issues, especially when using live models or querying large datasets. For live data models, large queries increase costs as more data is pulled from the data warehouse. For Elasticubes, this can cause performance bottlenecks. To avoid these issues, here is a quick solution to "limit" the date range users can select, ensuring both cost-efficiency and smooth performance. Read more to find out how!639Views1like0Commentscustom queries in widgets
I have a very simple ask. When I go into widgets I am able to click on the three dots and hit Analyze SQL Query but I don't see a way to edit it. I would like to be able to edit the query, is there a way to do that? I need to create custom calculated fields that sisense can't do, i.e. I need to do some complex window functions so they dynamically update as the user moves around the date range. Thank you in advance1.3KViews0likes2CommentsHorizontal Contribution
Hi Sisense Devs, I'm using a Pivot Table Visual in which Im using employee_name as my rows, phone state as columns (With over 15 categories), phone state duration as values, I converted the values to % using the CONTRIBUTION formula on Sisense, but Im getting the contribution per Column, this is something I don't need at this time, what I actually need is the contribution per row, is there anything I can do using only formulas or would I need a custom code table on the cube? Thank you all.Solved1.5KViews0likes2CommentsDynamic (WTD, prior WTD) based on selected Date Filter
Good Morning Enthusiasts! We have a client requirement to present WTD, MTD, QTD, YTD numbers that would be dynamic depending on the selected/active Date Filter. Example, if current filter is year 2024, they should see the latest: WTD (as of Feb 19) total, MTD (Feb 1-19) total, QTD (Jan 1 - Feb 19) total, YTD (Jan 1 - Feb 19) for now. I'm currently using the Max Date filter measure for these, however, I can't figure out yet how to show the prior WTD, MTD, QTD, YTD numbers. I attempted to use PASTWEEK(), etc. but there should be an active filter for the week itself before it works. Am I missing something? While if I use the This Week, vs Last Week filter, that would only show the current week and prior current week, and is not dynamic if I change the Date Filter. adding a sample here data here for reference, if user filters January 2024, they should see the latest WTD for January, then it will be compared to the previous week total. Any thoughts, suggestions, tips or workaround would be greatly appreciated 🙂806Views0likes1CommentTransferring Grand Total from Pivot when converting widget to Indicator?
Hi all, I am using this formula to flag a 1 for every project that is at or under budget. SUM(CASE WHEN ([Total budget] - [Total amount]) >= 0 THEN 1 ELSE 0 END) This works fine as a pivot table since there is an option to display a grand total. However, this widget needs to be an indicator, and I'm noticing that the grand total does not come through when changing from pivot to indicator. Instead, the Indicator total is displayed as "1". Choosing the option "Running sum by category" also displays a 1. Is there a way around this? ThanksSolved1.7KViews0likes2Commentslooking to create a custom Dashboard filter from a result from another widget (Live Data Model)
Dear Sisense Community, I am looking to see if there is a way through scripting that I can use the values from a Pivot table (one column of text data) to create a custom (Advanced) filter for the Dashboard. By the way, although I'm capable with the Sisense interface (Dashboards, Widgets, formulas, etc.), I am not a coder whatsoever. Please see the link for details: https://vimeo.com/909839916?share=copy Thank you in advance!Solved2.2KViews0likes4CommentsNeed to change the filter colors when something is selected
Hi All, I have several filters in my dashboard, i want to change the colors when something is selected in the filters to distinguish between selected and unselected filters . currently i am using $('.uc-tag').css('background-color','#006ecf'); $('.uc-tag').css('color','white'); as filter colors and backgroundSolved3.2KViews0likes7CommentsTabber Automatic Switching
Hello All, I am creating a dashboard that is displayed on a TV monitor and someone will not be able to manually click between the tabs. Has anyone had success creating a script that would switch between the two tabs automatically every 30 seconds?Solved2.5KViews0likes5Comments