Data Hygiene

7 Topics

Colored labels in table
I'm having an issue with the widget script to color the labels in a table created by harikm007 in a previous post. https://community.sisense.com/t5/build-analytics/colored-labels-in-table-widget/m-p/10780 I have successfully been able to implement the script. However, the color flashes quickly when I load the dashboard then disappears. Any reason why or if I have to change the script?
Solved
HQ_Dev_Prod
05-30-2025 Place Help and How-To
690Views
0likes
7Comments
Filtering within a function
Attempting to create a filtered value by editing the formula. I want to see Count of total people for where risk is high. Field 1: People (All peoples name linked to a risk group) Field 2: Risk Group (High, Medium, Low) COUNT([People], [Risk_Group]) I right click on field [Risk_Group] then I edit the filter for the field as High. But I get a Syntax Error:
Solved
HQ_Dev_Prod
03-17-2025 Place Help and How-To
414Views
0likes
2Comments
Sharing the datacube with multi tenants
Hi Team, I am currently implementing multi-tenancy in Sisense and sharing a single Elasticube across multiple tenants while enforcing Row-Level Security (RLS). The goal is to ensure that each tenant only accesses their respective data while using the same cube. I successfully shared the Elasticube with Tenant1, but when trying to access it, I get the following error: Error Loading Model Unexpected error value: { isOperational: false, message: "Request failed with status code 500", code: undefined, statusCode: 500, method: {some html tags and ids} Contact your system administrator for more information. The error persists even after confirming that: The Elasticube is correctly shared with Tenant1. Tenant1’s users, designers, and admin have access permissions. Multi-Tenancy is enabled in Sisense. Has anyone faced a similar issue when sharing an Elasticube across tenants? Any insights or suggestions would be greatly appreciated! Thanks in advance for your help.
Satya
02-11-2025 Place Help and How-To
378Views
0likes
2Comments
Gradient Conditional Formatting In Pivot Tables
Gradient Conditional Formatting In Pivot Tables I found this article in Sisense Community, and I want to replicate the same for a pivot table as given in the post . But I was informed we can't do this in the latest version of Sisense. Can we somehow still replicate this? Basically, requirement is to highlight max & min values of a particular column. Thanks, Animesh
angupta
01-30-2025 Place Help and How-To
330Views
0likes
1Comment
Filter based on length of string value?
Hello! I'm trying to figure out if it's possible to filter a given field based on the character length of its value. This is for a clean-up project. In my case, I'm trying to find records where the "Matter Name" field is below a certain number of characters. FYI - I do not have access to the backend configuration stuff for the e-cube, so any solution that involves messing with the tables or creating new columns will not be of help to me. I can only do what's available in the front-end UI. Also worth noting: our instance of Sisense is an older Windows version, v8.2.1. So make sure any solution you suggest will work on an older version like that. If it's something that would require us to update our Sisense then I'm out of luck 😞 I was hoping I could use underscores as a single-character wildcard, and then just chain a number of those together with an "equals" operator. However, this doesn't seem to be working as intended. For instance, if I say "equals ___" (three underscores), then it tells me "No Results", even though I know for a fact that some Matter Names are, in fact, exactly three characters long. It seems like this is an issue with the "equals" operator. If I use "contains" instead, then it seems to correctly interpret the underscores, but of course this isn't very useful since doing it that way will ALSO pull in a lot of undesired results. Interestingly, I was able to use this method to identify the opposite: Matter Names that are too long. Our character limit for the field is 250 characters, so saying "contains..." followed by 250 underscores will work just fine. However, if you change it from "contains" to "equals", it immediately says "No Results", even though the prior "contains" logic pulled up many 250-character names without issue. *shrug* How can I filter down to names with a specific number of characters, or less than/more than a certain number of characters? Alternatively, if there's another way to do this outside of the filter UI, perhaps with a widget script, let me know. Thanks! (NOTE: I'm aware that, as a workaround, you could simply export a pivot or table widget, use the LEN formula in Excel, then filter based on that. However, I'd like to find a solution that works within Sisense and doesn't require external steps to get the results you need.)
Solved
Jake_Raz
11-07-2024 Place Help and How-To
1.2KViews
0likes
2Comments
Filter for values that contain line breaks
I'm trying to find records that contain a line break when they shouldn't. The field I'm trying to filter is a text field. How can I do this? To be clear, I'm trying to do this purely in the front-end UI, because we don't have access to the backend admin area (for configuring the e-cube). So any solution that involves modifying tables/columns is out 😞 Is there a way to filter for line breaks using the normal text filters in the front-end UI? I can't just hit the Enter key in the input box because it doesn't treat that as actual input itself. I tried putting things like "\n" but it seems to be interpreting that as a literal, rather than as a newline character. I read in Sisense's documentation that you can use the backslash as an escape character, but searching for "\\n" also doesn't seem to work. Thoughts on how I can achieve this without e-cube modification? Perhaps there's a way to do it via an Advanced filter, or using some kind of widget/dashboard script?
Solved
Jake_Raz
09-26-2024 Place Help and How-To
782Views
0likes
1Comment
Customization of YTD
Hello everyone, I have a question on how to customize the YTD that is available when constructing a widget. I thought this was possible but now I'm not so sure. How would I go about getting the sum of the YTD between April-March versus Jan-Dec?
Solved
mgisp001
07-09-2024 Place Help and How-To
1.3KViews
0likes
3Comments