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

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! 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
  • 326 Views
  • 3 replies
  • 1 kudos

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
  • 283 Views
  • 2 replies
  • 0 kudos

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
  • 174 Views
  • 2 replies
  • 0 kudos

Resolved! 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
  • 343 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
  • 920 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
  • 345 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

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

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

Community Content Spotlight

Great content you missed that you never planned on reading

Updated: April 9th
  1. Blog: Empowering Women in Tech: A Q&A with Aysha, CIO & CISO of Treasure Data
  2. KB Doc: Limiting Date Filters to Datasource Date Range
  3. Sisense Academy: Advanced Dashboards with Plug-ins and Scripts
  4. Sisense Docs: Dashboard Design Best Practices: Creating Effective Visualizations
Check out our Software Developer Communities!