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

BloX Template: Indicators With Sparkline

IntroductionIn many use cases, the most current state of your KPI is as important as the trend of that KPI over time (for example, the trend of stock price, impressions or reach of your social media campaigns, etc), so you want to show both an indica...

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

Add Non-Repeating Header To List Of Items

Question: How to add a main header row that contains the column title of each row of data?Solution: You can solve it with a widget script, please follow these steps:1. Add a class to your "title", or the part that you only want to repeat once (in our...

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

Get Elasticube from Process ID

Question:I would like to be able to track memory consumption of my Elasticubes, but I can't find an easy way to link the process ID of my Elasticube to the cube name.Solution:If you open the Task Manager, go to the Details tab and right-click on one ...

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

Blox Data Input To Keep The Entered Value

Question: I want to use the Date picker for filtering, however, the dates selected are not getting preserved by the date picker and might be confusing for the end users whether the date is selected or not.Solution: You can use the script to keep the ...

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

Using SQL Coalesce To Handle Null Values

Question:SQL NULL is not technically a value, but rather a state. Fields are not equal or not equal to null, they are or are not null. As such, null fields can get a little tricky when attempting different kinds of transformations.For example, mathem...

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

Creating A Filter From A Text Box

The information in a blox text box can be used to create a filter.I ran into a use case wherein the client wanted to create a filter based on a list of values in csv file. The filter dimension has thousands of options and users would often need to se...

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

Flattening JSON Objects In SQL Server

Question: In instances where tables within SQL Server contain JSON objects within a column you can use the import sql query editor feature in Sisense to flatten these objects into individual fields.For example:Can be turned into:Solution:To accomplis...

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

Highlight Selected BloX Filter Button

1. Apply this widget script (found in the widget menu) to the BloX widget:var ChooseYourHighlightColor = '#00cee6'; widget.on('ready',function(widget, args){ var filterToFind = widget.metadata.panels[0].items[0].jaql.dim; var dashboardFilters = widge...

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

BloX Filter Buttons For Trailing X Months

Use this Date Offset Filter Buttons template to add buttons to your dashboards that allow your users to filter the dashboard by a month offset.After importing the template, you can modify the JAQL in the Editor section to provide the table and column...

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

Use Blox Script In PDF

Question: When applying the script in Blox - the change is not applied in PDF.The example of the script:This looks fine in the Blox editor, Dashboard and PDF preview:But the script is not applied to the exported PDF:Solution: Replacing the arrow func...

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

Removing Leading Zeros

Question: What is the best way to remove leading zeros? I have a field that is alphanumeric values (JONESBJ001, SMITH KC02, 0000012345, 0000555213.Solution: If all of your data with leading zeros will always be some sort of numerical string (ie there...

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

Filtering On Multiple Tags In A Single Row

Question: A relatively common database design strategy is to have a tag column with an arbitrary number of tagsHere is an example in which we look at numbers between 1 and 10 and tag them as even, odd, perfect, or parts of the Fibonacci sequence:Now ...

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

Custom Script For Blox Panel Name

Question: Is there a way to tie a default filter (set to "all") so that instead of Blox just displaying the top name in from the data, it triggers a custom phrase instead (like "Aggregate")?Solution: Here's a simple way to do something of the kind! T...

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

Fixed Table Layout (For Displaying Individual Values/Formulae)

I had a requirement to generate a fixed layout of tables, where the values in each cell were calculations (much like an excel worksheet) as opposed to aggregations grouped by a dimension (typically how we use pivot tables).Using Blox we created some ...

intapiuser by Community Team Member
  • 314 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