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.Customizing the Offset Size of Selected Categories in Sisense Pie Chart Widgets
In Sisense, pie chart widgets, including the various pie chart style options such as donut charts, are a common way to visualize data. By default, when a user selects a category within a pie chart, that slice "pops out" to highlight the selection. This article explains how to customize the offset size of selected categories in Sisense pie chart widgets by leveraging Highcharts settings of the widget using Sisense widget scripting capabilities.UserReplaceTool - Automating Dashboard Ownership Transfers - Useful for Deleting User Accounts
Managing and deleting user accounts in Sisense can create manual processes when users leave an organization or change roles. A frequent issue is the reassignment of dashboard ownership to prevent losing Sisense dashboards when a given user account is deleted, as deleting a Sisense user will delete all dashboards owned by that user. The UserReplaceTool addresses this task by automating the transfer of dashboard ownership of all dashboards owned by a given user, ensuring continuity and data integrity. UserReplaceTool is a Python-based, API-based Tool solution designed to seamlessly transfer the ownership of dashboards and data models from one user to another in Sisense. This tool simplifies and automates this process, allowing organizations to reassign dashboard ownership without manual processes or the risk of losing dashboards and widgets. All components are accomplished by using Sisense API endpoint requests.Exploring the Potential of Sisense Jump to Dashboard Filter Configurations
Sisense Jump to Dashboard offers a powerful way to enhance the user experience and streamline data exploration with the help of different filter configurations. By default, all the filters from the parent dashboard, measured values, and widget filters are passed and replaced in the drill dashboard. This guide explains and provides examples of how you can customize the way filters impact the drill dashboard. We'll delve into multiple filter configuration options and provide a step-by-step guide on how to implement them effectively.The New Sisense Support Portal is Now Live! 🚀
🔑 How to Contact Support To ensure your requests are handled as quickly as possible, please use the following channels: AI Chatbot (Preferred) Available directly on the portal, our new smarter AI assistant provides instant answers. If the chatbot cannot solve your issue, it will automatically convert your conversation into a support ticket, ensuring our team has the full context of your request. The Sisense Support Portal Submit and track requests via https://supportportal.sisense.com/. Why use the portal? Our new smart forms ensure we capture all required technical data immediately, allowing our team to start working on a resolution right away. Support Mailbox You can also report issues by emailing [email protected]. Note: While this automatically creates a ticket, our team may follow up with additional questions to gather environment details that are usually captured in the portal forms. Portal Technical Issues? If you experience any difficulties specifically with the portal (login or navigation issues), please notify us at [email protected]. 🛠️ Navigating Your New Dashboard Once you log in, you’ll notice several new ways to manage your tickets. Click on "Show Filters" to customize your view: View Types: Switch between Table format (default) or Card view depending on your preference. Ticket Counts: Easily toggle between My Tickets (created by you) and All Tickets (created by your organization, according to the privileges granted for your user before). Customization: You can now Sort, Group, and Filter your tickets by Status, Priority, or Created Date. Quick Tip on Attachments: When creating a new ticket, any files you upload will appear under File Attachments. In existing tickets, your uploaded files will be embedded inline within the ticket comments for better context. Additional emails in CC Additional emails in CC is now live for new and existing tickets. Add email one by one by pressing enter after each. What happens to your old tickets? All open tickets have been successfully migrated. You can find your full ticket history and continue tracking active issues directly within the new portal. Thank you for your patience as we build a better support experience for you! — The Sisense Support TeamPivot and Table Widget Scripting for Replacing Values with Colored Arrows
Sisense table and pivot widgets offer extensive customization options for data presentation, allowing developers to tailor widget content to specific needs, as discussed in detail in previous articles. While the Pivot 2.0 API includes a built-in transformPivot function for data transformation, Table widgets typically require direct DOM manipulation. This article provides a step-by-step guide for replacing numeric (or other) values in both widget types with arrow characters via scripting. It also demonstrates how to assign colors or apply conditional logic to these transformations. Examples include the use of Unicode arrow characters, though any other characters or combinations of characters can of course be utilized.
