How-Tos & FAQs
cancel
Showing results for 
Search instead for 
Did you mean: 

Knowledge Base Articles

Hide vertical lines on the Pivot widget (Linux)

Hide vertical lines on the Pivot widget To test this solution, you must create a dashboard based on any cube and create any Pivot widget. Once it is done - please go to the widget editor, click three dots select Edit Script, then paste the following ...

ILLIA_0-1738603735617.png
ILLIA by Sisense Team Member
  • 195 Views
  • 0 comments
  • 1 kudos

Auto zoom Area Map widget to a specific country on load (Linux)

Auto zoom Area Map widget to a specific country on loadTo test this solution, you must create a dashboard based on Sample ECommerce and an Area Map widget based on a Country column. Once it is done - please go to the widget editor, click three dots s...

ILLIA_0-1738602991196.png
ILLIA by Sisense Team Member
  • 420 Views
  • 0 comments
  • 1 kudos

Disabling the "Custom Filter" Feature for End-Users

Disabling the "Custom Filter" Feature for End-Users This article provides a solution for administrators who wish to disable the "Custom Filter" feature in their applications to prevent confusion among end-users. Instructions The "Custom Filter" feat...

How to Calculate YTD by Month in a pivot table?

Question How to Calculate YTD by Month in a Pivot Table? Answer If you want to show YTD by Month next to your monthly amount you can utilize the "Running Sum" Quick Calculation. If you want to show this next to the monthly amount, just bring in th...

DRay_0-1713991552654.png DRay_1-1713991552810.png
DRay by Community Team Leader
  • 1036 Views
  • 0 comments
  • 1 kudos

Turning zeroes to blanks/empty cell when Zero

Symptoms Sometimes with a pivot table full of many columns with zero and only a few non-zero values, you want the zeroes to display as empty-string.  That way the nonzero values really stand out. (This is the opposite of this:  Solved: nulls to 0 in...

DRay by Community Team Leader
  • 482 Views
  • 0 comments
  • 1 kudos

Embedding Custom Visualizations Within A Widget

Introduction This document outlines the process for overriding an existing chart with a Highcharts Donut Pie chart.  For a more robust solution, it is recommended to create a custom plugin as that would allow non-technical users to create charts wi...

intapiuser by Community Team Member
  • 1939 Views
  • 0 comments
  • 2 kudos

Conditionally Colored X-Axis Labels On Bar Chart

Introduction The code below allows you to color the x axis labels for each category of a bar chart based on the color of a secondary series. It also then hides the secondary series from being plotted. Steps STEP 1 The first step is to create a bar c...

intapiuser by Community Team Member
  • 634 Views
  • 0 comments
  • 0 kudos

How To Order A Stacked Column Chart Using A BreakBy

Introduction   When adding a break by field to an ordered column chart, the order does not exist anymore.We have created this post in order to workaround this problem. StepsIn order to use the script, you need to follow the next steps:   1. Edit the...

intapiuser by Community Team Member
  • 1965 Views
  • 0 comments
  • 1 kudos