Build Analytics
cancel
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

"Where" Function

Can the "where" function be used in a lookup formula to limit the rows looked at to only result in values that are not null or only a specific value or partial value? I am attempting to use a lookup formula, where the value being used to look up appe...

Lookup Limited to Rows without a Null Value

Is there a method or formula to use a lookup, but only obtain the first instance that has a real value, and not a null (n/a) value? In addition, is there an explanation manual available of formulas which a person with no IT skills can use to understa...

Lookup Formulas referencing one table

Lookup([RaaS_CurrentStaffingReport 1],[Last Hire Date],[Sisense Employee Number],[Employee Number]) Is it possible to use a lookup formula to find and show data within the same table? If not, what would the correct formula be? The above shows no data...

JUMP TO PIVOT CELL COLOR FORMAT

I have the following code that formats the pivot table seen below: widget.on("ready",function(w, args) { var headerBgColor = '#a90a40'; //Header background var headerFontColor = '#F2F3F2'; //Header Font Color var footBgColor = '#44546A'; // Pivot Foo...

cartercjb_0-1653074419912.png

Formula not producing correct results

I am attempting to replace a value of N/A with another field in a table. I continue to receive the value of "N/A" which is in the "Working Title" field with the formula below. Is this the appropriate formula? The actual value that appears in the work...

BLOX EQUAL & DYNAMIC SPACING

I have the following BLOX widget: Which is generated via this BLOX code: { "style": "", "titleStyle": [ { "display": "none" } ], "script": "[].slice.call( document.getElementsByClassName('blox-date') ).forEach(function ( div ) { div.innerHTML = new D...

cartercjb_0-1652810819890.png

Resolved! PREVENT EXPORTS

I have two questions after searching through the community: HOW DO YOU PREVENT A WIDGET FROM BEING DOWNLOADED? HOW DO YOU PREVENT USERS FROM EXPORTING AN ENTIRE DASHBOARD TO PDF?

cartercjb_0-1652723644237.png cartercjb_2-1652723716527.png

Resolved! BLOX DROPDOWN - FILTER OPTIONS

I referenced this KB article to create a BLOX dropdown list as a filter. Here is a screenshot of my dashboard: The BLOX code I used to create the dropdown is at the bottom of this post. I want to filter the available drop down options to only show th...

cartercjb_0-1650468280370.png cartercjb_1-1650468638659.png

Resolved! Arranging Layers of Chart Values Without Disrupting Format

Does anyone have suggestions on how to change the layers in which the values are plotted? I have this chart where the data label shape for RUNNING 14-D AVG. is behind the Column: I tried re-arranging the Values, which does fix the layering problem, b...

cartercjb_0-1649774062662.png cartercjb_1-1649774138388.png

FILTERED JTD BASED ON LIST ROW ITEM

I have the following blox widget based on this code: { "style": ".blox-slides:not(:first-child) .blox-pivot-title{display:none} .blox-slides .blox-pivot-title{margin-bottom:2px;font-weight:bold; color:black}", "titleStyle": [ { "display": "none" } ],...

cartercjb_0-1649743044067.png

Geo Map GL Widget Plugin

Hi Sisense Community. I have used the Geo Map GL plugin to create a map that shows the sales amount per state in only the US and Canada. However, when I hover over the map, there is no value label. I can't find much documentation on Geo Map GL online...

amelia by 10 - ETL
  • 2325 Views
  • 2 replies
  • 0 kudos

Default Selections - Multiple Tabbers

I am trying to make two dynamically related tabbers that behave like this: TABBER 1: has 5 tabs with FINANCIAL as the default selection. This works without any issues. Tabber 2: I am trying to incorporate a 2nd tabber that is dependent on the CASELOA...

cartercjb_0-1649096129917.png cartercjb_1-1649096129676.png

Resolved! Non Repeating Blox Header

Hi Community! I have the following blox widget based on this code: { "style": ".blox-slides:not(:first-child) .blox-pivot-title{display:none} .blox-slides .blox-pivot-title{margin-bottom:10px; font-weight:bold; color:black; font-size:1em}", "titleSty...

cartercjb_1-1649095612143.png