ContributionsMost RecentNewest TopicsMost LikesSolutionsInvert text color when over dark highlight Is it possible to have color text invert based on cell highlight color? We have conditional formatting on some cells that create a rather dark highlight and makes the default dark text unreadable. We would like the text color to invert based on cell background color. We see the same issue on some bar/column charts where the text is over a bar with a dark color and can't be read. Is there not a system setting or anything that will automatically invert colors? SolvedRe: Disable single slice of pie chart Hari's script achieved what I was looking for. There are small quirks with it, where you can't click the pie slice to unfilter, but it's close enough. Disable single slice of pie chart On a pie chart, where the 'Others' slice is enabled, is there a way disable the click action for only the 'Others' slice? We have some instances where the Others slice contains several hundred members and can crash the page. Ideally, we'd like the user to still be able to click other slices to filter their dashboard, but not be able to click the Others slice. SolvedReturn members from dashboard script My goal is to have a dashboard filter be dynamically hidden based on number of values in an elasticube table that a user has access to. Specifically, if [Tenant].[Tenant Name] returns more than one value, the dashboard filter should be visible. Less than two and it should be hidden. I'm able to hide/unhide the dashboard filter via dashboard script, but am not sure how to retrieve number of Tenant Names without creating a new widget and also making it hidden. Is it possible to return table.column members in a dashboard script? Re: Live connection - slow initial load times DRay We are using the official Sisense Redshift connector. Live connection - slow initial load times I'm wanting to move from building an elasticube to using a live model. I'm noticing that initial load times across all widgets/dashboards are very slow on the first load, even when the query is quite small. Once cached, load times of course are quick. If I take the exact query and run it in a query editor, it completes in under 1s, so I would expect similar results from Sisense. Looking at the Chrome dev log, the bottleneck is 'waiting for server response'. We are connecting to a Redshift DB. Are there any configuration settings we should be looking at to reduce Waiting/TTFB? Re: Track Dashboard Usage With Google Analytics For anyone still looking at this plug-in, it uses a deprecated Google Analytics version (UA) which no longer sends data to Google. You can replace the code in main.js with the following to update the plug-in with the current Google version, GA4 (replace 'G-TAG' with your tracking tag): prism.run(["$filter", function($filter) { (function(w,d,s,l,i){w[l]=w[l]||[];w[l].push({'gtm.start': new Date().getTime(),event:'gtm.js'});var f=d.getElementsByTagName(s)[0], j=d.createElement(s),dl=l!='dataLayer'?'&l='+l:'';j.async=true;j.src= 'https://www.googletagmanager.com/gtm.js?id='+i+dl;f.parentNode.insertBefore(j,f); })(window,document,'script','dataLayer','G-TAG'); prism.on("apploaded", function (e, args) { window.dataLayer = window.dataLayer || []; function gtag(){dataLayer.push(arguments);} gtag('js', new Date()); gtag('config', 'G-TAG'); }); }]); Implementing WalkMe? Curious if anyone has implemented WalkMe functionality to their self hosted Sisense environment? Our product team would like to deploy WalkMe to Sisense, but this seemingly requires a code snippet be added to the <head> of the main html file, which Sisense is highly suggesting we do not do. SolvedExclude one group from viewing dashboards We have a list of dashboards which are published to 'everyone'. We have a few new dashboards that are being setup for a specific group of users - these users should not have visibility to the existing dashboards that are published to 'everyone'. Is there a way to exclude a group from seeing certain dashboards? We could setup a new group that everyone gets put into (except the one set of users) and publish our existing dashboards to that group, but are trying to avoid the maintenance involved with that. Unwanted Join Path I'm facing an m2m error on one of my widgets. From the Analyze Widget JAQL view, I can see the issue is that inventory.tenant_id and vendor.tenant_id are not connected directly to tenant.id. The problem is that they are joined directly in the elasticube model. Is there a trick to force the inventory and vendor tenant_ids to the tenant table? Curiously, if I remove EITHER the vendor fields or cost center fields from the widget, the error goes away...