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

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
  • 161 Views
  • 9 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

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
  • 13 Views
  • 0 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

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

Resolved! Selectively change Markers on a Line Graph

I have a stakeholder who would like to selectively turn off the markers on line graphs for certain lines.As in the attached image, they want to remove the markers on the dashed lines, but keep them for the solid line. I can't find anything in the doc...

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
  • 100 Views
  • 4 replies
  • 0 kudos

Delete a custom column from a custom table

I did a custom table with two "original" columns - Date and weekday_number - and previously i added a bigint custom column, but now i want to delete this bigint column and i cant find where to do this

giovanna by 7 - Data Storage
  • 130 Views
  • 2 replies
  • 0 kudos

Break by sorting in stacked column chart

Please can you guide how we can sort by break by like here 1st chart 'in' should be shown as bottom in stacked then in with risk,out with upside and then out currently it is showing reversely.Also in 2nd chart how do we sort by stages to show qualifi...

Highlighting a row in a widget table

Working in a widget table that is producing a data table with multiple columns.  Need a way to highlight rows depending on the value of a specific column.  A generic example of a table is attached.  Anyone have an idea how to do this?

Capturetest.JPG
galos11 by 7 - Data Storage
  • 113 Views
  • 2 replies
  • 0 kudos

Resolved! How to limit use of a Blox Button based on a user

I am working with a dashboard that uses multiple JTD BloX widgets, where I want one of these JTD BloX Widgets to hide based on a user who is accessing it. This will be set for multiple users, but I wanted to see if there are any solutions out there. ...

Astroraf by 11 - Data Pipeline
  • 272 Views
  • 7 replies
  • 0 kudos

Resolved! Advanced Filtering to use AND & OR on a single field

I'm attempting to assist a colleague who has been asked to perform multiple filters on a single text field. While it is simple to use the text filters to create a single 'Starts With' & 'Ends With'. However, they've been asked to expand the filter to...

Screenshot 2025-03-06 164926.png
Check out our Software Developer Communities!