Knowledge
cancel
Showing results for 
Search instead for 
Did you mean: 

Knowledge Base Articles

Divergent/Negative Bar Chart

Sometimes you may want to compare two values alongside each other to measure impact of one vs the other but without stacking them or having them side by side.This is often called a divergent bar chart.This can be done in Sisense with just a little bi...

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

Cohort Analysis

Data PreparationOrange: Borrowed from another table via lookup() Blue: Custom columnIf the first visit date is available in the dimension: Lookup the user’s First Visit Date from the dimension table in a custom column of the fact table based on the u...

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

Hide Values After Sorting In Column/Bar/Line Charts

Works With Any Chart Widget That Allows Right/Y2 Axis.CHALLENGE:As a dashboard designer you might want to sort the X axis of a chart based on some aggregated values but want to show another aggregation. For example:In the below widget we would like t...

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

Using BloX To Dynamically Change A Dimension

The goal is to allow users to dynamically choose a dimension. The below script will work with a table or a pivot table, but it can be modified to work with other widget types as well. Step 1Create a BloX widget with the below script. It will consist ...

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

BloX Button To Add/Remove Break By

This article details the process of creating a BloX button that applies/removes Break By on one or more widgets. Step 1Create the widget(s) including the Break By field. We will need to retrieve the JAQL for the Break By field and add it later via a ...

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

Creating A Dynamic Rank Button With BloX

This post details how to create a 'rank' button to filter a widget based on user input. Ex: if the user inputs a 5, the widget will show the top 5 records by the measure of choice. Step 1Create the desired widget (it does not have to be a table) incl...

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

Change X Axis Interval

In the example above, the interval was set to 7.This will work for any data type.Widget Script:widget.on('processresult', function(a,b){ b.result.xAxis.tickInterval = 7 })

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

How to hide the element at the page

Question: Is there a way to hide, for example, the version in the user menu of the dashboard? Solution: You can develop a plugin to remove the element: $('.menu-version-item').remove()

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

Jump To Dashboard (JTD) BloX Close Button

Closing the modal window of a Jump to Dashboard can only be done be clicking outside of the window. This post details how to use BloX to create a button that resides within the window, which allows users to close it. STEP 1Create a BloX widget in the...

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

Automatically Sort Values Into Ranges Of Known Size

If you know the size your range/bucket will increment by, this quick method will help you automatically sort your values into their respective range.This is useful when you cannot create or maintain ranges using a CASE statement. In the below example...

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

Convert Quad Decimal IP Addresses To IP Integers

This expression will convert IP addresses in the quad decimal format of 'www.xxx.yyy.zzz' to integers that can be used for further analysis (eg. cross referenced to a geo-location).For example, it would convert the string '66.249.66.1' to the integer...

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

Cheat Sheet - Detecting Incorrect Data

Data is a beautiful mess. As data heroes, we spot the mess and get rid of it to highlight the beauty. Here are a couple useful tricks to detect incorrect data. We will assume a table that describes the number of meows made by each cat in each box, on...

intapiuser by Community Team Member
  • 168 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 [email protected]

Share this page: