Help and How-To
Your place to get help using Sisense to meet your business needs
cancel
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

Invert 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 ...

cglowe by 9 - Travel Pro
  • 66 Views
  • 3 replies
  • 1 kudos

Filtering on a specific range of hours

I have a colleague who needs to filter a dashboard on a very specific time period - from 08:00 yesterday morning to 08:00 this morning.They don't need/want all of yesterday before 08:00 or any of today after 08:00.I've tried playing about with the cu...

Resolved! Tooltip for Pie Charts

Hello @DRay @Liliia_DevX  @harikm007 ,I saw @harikm007 other post about adding tooltip information to bar chart, column chart, etc, but I was wondering if there was code out there to add it to a pie chart (https://community.sisense.com/t5/build-analy...

Astroraf by 11 - Data Pipeline
  • 91 Views
  • 2 replies
  • 0 kudos

Drill To Buttons

our userss have complained that having to teach people how to right click and find the drill feature, they'd instead like a button at the top of the visual where they can click and it applies the drill function. i'm sure there is a jaql query or impl...

liamcameron_1-1716351221988.png

Blanks in Pivot Widget

Hi all,Wondering if I'm missing something when it comes to using a Pivot. Is there a reason why the last column is always blank here? It doesn't matter which order I rearrange these values, the last one is always blank. I've created another pivot usi...

Shams_0-1741788141999.png Shams_1-1741788183450.png
Shams by 8 - Cloud Apps
  • 100 Views
  • 2 replies
  • 0 kudos

Blox TextBlock - Remove Filters for Value

I am attempting to add a textblock to my Blox KPI with a calculated value. The objective is for the total value to stay the same as a point of comparison, while the user applies filters.In this example, the count changes as the user applies filters. ...

HQ_Dev_Prod_0-1741713416547.png

Resolved! 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 r...

HQ_Dev_Prod_1-1741880927964.png HQ_Dev_Prod_0-1741880917654.png

How to Have Break By Switchable Dimensions Update Title

I am trying to have the Break By Update the title of the Switchable Dimension rather than dimension.My script goes as follows.  prism.registerSwitchDimension({ widget: widget, widgetTitleTemplate: "{{val}} By {{dim}}", // Dynamically updates ...

Astroraf by 11 - Data Pipeline
  • 200 Views
  • 6 replies
  • 0 kudos

Resolved! How to show 2 colors for 1 legend item?

I am building a bar chart show actual vs target number. And in my actual number, I am using a conditional color if it is over the target then show yellow if not show blue here. After I added the conditional color on the "Actual sale" value, the legen...

DXC_1-1736988684777.png DXC_0-1736988662577.png
DXC by 8 - Cloud Apps
  • 553 Views
  • 6 replies
  • 0 kudos

Resolved! Date Granularity Affecting Title Widget

I am using this solution from @intapiuser: https://community.sisense.com/t5/knowledge-base/change-date-granularity-of-a-widget-using-blox/ta-p/8916 to try and get a widget that this BloX affects to update the title of the widget. Attached is the imag...

Screenshot 2025-03-13 at 15.27.30.png
Astroraf by 11 - Data Pipeline
  • 155 Views
  • 5 replies
  • 0 kudos

Dashboard - Passing Filter Values Using URL Parameters

A customer may want to pass a filter value using the URL (as a parameter). A common case could be when an external system launches a dashboard and wants it to default to a specific value.The following script allows you to parse the parameters receive...

Ophir_Buchman_0-1654805158204.png 83227784_3726975083979609_8570336295451099136_n[1].jpg

Widget Filters - condition across multiple fields

Working as a dashboard designer without access to the back end data. I am trying to filter with an 'or' condition across a number of fields.I can only see how to apply a single field filter on the front end, which would equate to an and condition acr...

AlexW by 8 - Cloud Apps
  • 235 Views
  • 9 replies
  • 0 kudos

Resolved! Comparing String Values Across fields

I have a colleague who needs the ability to compare string values across two fields to assess whether or not they're identical (simple example in excel below). I've not been able to find any documentation on this & would be grateful for assistance. 

Regular Expressions

Does anybody know if regex is an option in Sisense custom tables? Can't find any documentation and it's not listed in available functions. I know I can use it in MySQL tables, but having it in custom tables will be very useful.We are using Sisense Cl...

Check out our Software Developer Communities!