Knowledge
Note: We are actively completing a knowledge migration process. This space will grow over the next few months as this work is completed.
cancel
Showing results for 
Search instead for 
Did you mean: 

Knowledge Base Articles

LAG / LEAD Functions

Question: LAG & LEAD Functions are functions that give access to multiple rows within a table, without the need for a self-join. The LAG function is used to access data from a previous row, while the LEAD function is used to return data from rows fur...

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

BloX Auto Slider

ObjectiveWhen using actions in BloX, it is possible to use user input values in actions' payloads.Unfortunately, the slider element is not considered an input field, and its values cannot be used in actions payloads.In this post, I will provide a met...

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

Filter selections in Blox widget

Question: How to show the values selected in the dashboard filter as a Blox widget?Solution:Our example uses a filter / field called "Fake Names" First, in your BloX widget's Editor tab: 1. Set "showCarousel" to "true", but add the following option t...

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

Split A Delimited Field Into Rows

Question: A data source in your ElastiCube contains a field with multiple values in it delimited by a particular character (i.e - comma, semicolon, space, etc.). You need to parse that field and create a table with a record for every value in the del...

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

Supporting Updates And Deletions In DB When Building Accumulate

Question: When using "Accumulate By" builds (see below), Sisense will only import "new" records based on a selected INT or DATETIME index field - if values in the source DB exceed the maximum value of that index as of the previous ElastiCube build, t...

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

LOOKUP WITH TWO CONDITIONS

Question: How to do a lookup using two conditions (i.e., pulling project number on a unique equipment for a specific day)?Solution: You can only use one field as the key field in Lookup function. So, it is better to create a combined key (using conca...

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

Relative Date Filter in Blox

Part 1: Preparation And Setup Download the BloX Template Here Import the Template into BloX (tutorial here) Create an action called "RelativeDate" Add the code below to the action and save it.if (payload.text == "Year" ) { prism.activeDashboard.filte...

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

JS Charting Gauge in Blox

Question: How can I create a Charting Gauge in BloxSolution: You will need 5 items; A field for indicating the pointer-value. In the example the number in the middle and the yellow marker Gauge minimum Gauge maximum One and Two indicate the chart int...

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

BloX Sort Values Action

Challenge:When making a BloX widget, there is no UI element that you can use to sort the widget.Solution:This custom BloX action allows you to trigger a sort for any widgets including itself.Steps To Implement:STEP 1A: CREATING THE ACTIONCreate the a...

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

Force Start A Sisense Service From Windows PowerShell

Question: Sisense Service hangs and I try to start them in Windows Services, but the usual net stop & net start will not restart them. net stop /y will stop all dependencies.Solution: Follow the instructions below to force start a Sisense Service: Lo...

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

Alternating BloX Background Color

Add the following css to the style tag of the main blox property.Modify the widgetid value to match your blox widget ID. The ID is the text after /widgets/ in the URL bar.Modify the color to be whatever color you'd like to alternate between.widget[wi...

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

Creating A Quiz In Blox

Today we will create a quiz widget in Blox that will looks something like this:This is a blox exercise to show a simple use case for custom actions.The first step is creating a data source file.You can create some csv with have some questions answers...

intapiuser by Community Team Member
  • 94 Views
  • 0 comments
  • 0 kudos
Labels
Community Toolbox

Recommended quick links to assist you in optimizing your community experience:

Developers Group:

Product Feedback Forum:

Need additional support?:

Submit a Support Request

The Legal Stuff

Have a question about the Sisense Community?

Email community@sisense.com