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

Knowledge Base Articles

Filter For Last Working Day

When a filter based on this custom column is active, the dashboard will reference the last working day.If the dashboard is checked on Monday or Sunday, Friday's data will be shown. If the dashboard is checked on Tuesday - Saturday, the prior day will...

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

Maintain Percentage Contribution Using ALL Function

Analytical Need Even though this requirement sounds fairly simple, a lot of times, this use case gets confusing. If there are 10 stores for a Retail Chain, sometimes the Management would only want to compare 3 stores and split the entire contribution...

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

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
  • 368 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
  • 278 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
  • 375 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
  • 965 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
  • 369 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
  • 424 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
  • 255 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
  • 179 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
  • 480 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
  • 357 Views
  • 0 comments
  • 0 kudos
Labels
Featured Article
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: