Liliia_DevX
Sisense Employee
Joined 3 years ago
User Profile
User Widgets
Contributions
Re: JumpToDashboard - Troubleshooting the most common configuration issues
Hi Astroraf! Please try to use resetDashFilterAfterJTD to reset filters on your JTD dashboards after jumping to them. It might be a spelling issue. If it's not, please raise a support ticket providing parent and drill dashboards examples along with the JumpToDashboard configuration for us to review :)Translating Widget Descriptions Using Metadata Plugin (Linux)
Translating Widget Descriptions Using Metadata Plugin (Linux) This article explains how to translate the description section of widgets within a Sisense dashboard using the metadata translations plugin. This functionality allows users to customize descriptions based on language preferences, making dashboards more accessible to a global audience. [ALT Text: Dashboard with two gauges: left shows total revenue at 14.48M, right shows total units sold at 32,386. Blue tones and numeric indicators.] Step-by-Step Guide The metadata translations plugin enables translation of various metadata, but translating widget descriptions requires an additional logic. The example code snippet is provided below: const config = { "en-US": { "datasourceAliasing": { "tables": {}, "formulas": {}, "columns": {}, "widgets": {}, "descriptions": { "Custom Widget description": "Custom Widget description", "Some other description": "Some description" } } }, "fr-FR": { "datasourceAliasing": { "tables": {}, "formulas": {}, "columns": {}, "widgets": {}, "descriptions": { "Custom Widget description": "Description du widget personnalisé", "Some test": "Quelques essais" } } } }; function getDescriptionMapping() { // get current user language const currentUserLanguage = $$get(prism, 'user.preferences.language') || $$get(prism, 'user.preferences.localeId') // get descriptions from config for this currentUserLanguage // return mapping } function translateDescription(descriptions, widget) { widget.desc = widget.desc.replaceAll(desc, descriptions[desc]); } prism.on("dashboardloaded", function(e, args) { const descriptionMapping = getDescriptionMapping(); // iterate all widgets and translate descriptions that match the ones from the config args.dashboard.widgets.$$widgets.forEach(function(w) { translateDescription(descriptionMapping, w) }); }) Adjust the code snippet as necessary to fit specific needs or languages. Due to variability in user setups, slight modifications may be necessary. Please find the implementation example attached to this article along with the dashboard based on the sample ElastiCube. Conclusion Translating widget descriptions enhances the usability of dashboards by catering to users' language preferences. Users can implement a translation mechanism using the metadata translations plugin following the steps provided. References/ Related Content Sisense Community: Metadata Plugin Grouping Provider Example Sisense Documentation: Metadata Translations Plugin Guide Disclaimer: This post outlines a potential custom workaround for a specific use case or provides instructions regarding a specific task. The solution may not work in all scenarios or Sisense versions, so we strongly recommend testing it in your environment before deployment. If you need further assistance with this, please let us know.Dynamically Updating Widget Titles Based on Filter Selections in Sisense (Linux)
Dynamically Updating Widget Titles Based on Filter Selections in Sisense (Linux) Introduction This article guides how to dynamically change the title of a Sisense widget based on the filter selection. While this is an advanced solution and not natively supported by Sisense functionality, a custom script can be used to achieve this effect. Please proceed with caution, as this is a custom implementation. [ALT Text: A dashboard display titled "Europe, USA (by Region)" showing a gauge indicating an "Actual Margin" of 0.22. The gauge ranges from -0.25 to 0.25. A sidebar lists regions: Europe, N/A, and USA, with checkboxes next to each.] Step-by-Step Guide Navigate to the desired dashboard in Sisense and select the widget you want to change the title dynamically. Open the widget's settings and access the script editor under the 3 dots menu > Edit Script. Copy and paste the following code into the widget's script editor: widget.on("render", function () { let title = "by Region"; // Set a default title // Find the specific filter by its column name let filterUsed = dashboard.filters.$$items.find( (filter) => filter.jaql.column === "Region" ); // Determine the filter text or set default let filterText = filterUsed && filterUsed.jaql.filter.members?.length ? filterUsed.jaql.filter.members.join(", ") : "All Regions"; // Flag to prevent multiple updates let isModified = false; if (!isModified) { widget.title = filterText + ' ' + title; isModified = true; } }); Adjust the filter.jaql.column value instead of "Region" in the script to match the actual filter you intend to use. Update the default title instead of "by Region". Modify the "All Regions" value to be displayed for the “Include All” filter. Save the changes in the script editor. Apply different filter selections on your dashboard to verify that the widget title updates according to the chosen filters. Troubleshooting and Limitations: Ensure that the filter column specified in the script matches an existing filter on the dashboard. The script works only for filters of include type. For excluding filters the additional logic should be implemented. Conclusion By following the steps outlined above, you can set up your Sisense widget titles to dynamically update based on filter selections. While this approach offers flexibility, it involves a custom script and requires careful handling, as modifications made this way are outside Sisense's standard support. Disclaimer: This post outlines a potential custom workaround for a specific use case or provides instructions regarding a specific task. The solution may not work in all scenarios or Sisense versions, so we strongly recommend testing it in your environment before deployment. If you need further assistance with this please let us know.Re: How to hide the "Switch to view mode" button based on a role
Hi, I'd like to share 2 additional scripts that might help to hide the "Switch to view mode" and "Share" buttons on the L2025.1 version: let hidden = false dashboard.on('widgetinitialized', () => { if(!hidden){ $('button.btn--switch-mode').remove() hidden = true } }) let hidden = false dashboard.on('widgetinitialized', () => { if(!hidden){ $('button.js--btn-dashboard-share').remove() hidden = true } }) Hope that will be helpful 😊 Regards, Lily
