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

Sisense Performance: A Billion Records in a Single Server

Browsing our site, speaking to our team, or reading about us in analyst reviews, you might have noticed that we dig technology here at Sisense. That’s why when clients and prospects desire to push the limits, both in terms of data complexity and quan...

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

Calculate and compare selected member to non-selected members

Analytical Need You want to display a value for a selected member (i.e. Salesperson) vs the min/max of all non-selected members. This can be achieved using modeling techniques but this solutions describes how to do it purely in the front end. Solutio...

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

Pareto Analysis

Analytical Need Pareto analysis is a technique based on the Pareto Principle which states that 80 percent of problems or effects are produced by 20 percent of causes. This type of analysis can be useful in the stage of decision making, to identify th...

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

Dashboard Planning and Implementation

This page is intended to keep a focus on Dashboard design in terms of: Planning Implementation User experience and functionality Dashboard training for end users Dashboard PlanningDashboard planning goes hand in hand with project planning, and will e...

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

BloX - Dropdown list as a dashboard filter

Introduction:The below article will provide a BloX template that will help you create a dropdown filterThe ‘Dynamic Dropdown’ snippet allows you to populate your dropdown list with a list of values from a specific field (for example, list of Brands)....

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

Creating 'From-To' Date using BloX

Analytical Need Attached below is a BloX template.A common request is to have a 'From To' input at the top of the dashboard to affect a calendar range selection of dates.To achieve this need we can utilize BloX's form capabilities.Picking a date rang...

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

MTD, QTD, YTD: Working with Data Sets Webinar

A common requirement in data analysis is to be able to view and compare slices of data from different time periods to current date. Business applications for this vary, from identifying trends to predicting future behavior, requirements or issues. In...

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

Conditional Filtering on Measured Values

Analytical Need Aggregation functions are used to group a set of values to perform calculations that return a single value. SUM(), MEDIAN(), and COUNT() functions are some of the most common aggregation functions examples. Simple aggregation function...

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

Replace Values with Text - Pivot Table Widget

IntroductionThe following enables to change the value in pivot tables to specific strings, while allowing the use of conditional coloring as normal.Step 1 - Add The Following Script To Your Pivot's Edit Scriptwidget.on('ready', function(){ $('td[clas...

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

Restoring dashboards default settings automatically

In this post you can learn how to automatically 'Restore Dashboard' on each page refresh or opening, this setting will always restore the dashboards initial published state for your viewers and designers.This can be used for cases where you would lik...

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

Changing published widgets' attributes

After publishing a widget, we can access it's attributes to further modify it to our requirements.Step 1 - Find the Widget titleNamed 'widgettitle' from the browser's console, by adding a 'debugger' to the this.initializing of the dashboard. In the t...

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

YTD function reference

Below gives a solution on how to compare this year results up to today with previous year until the same parallel day.Solution: If you want to compare this year and the previous year you can add a widget filter where you will choose the current day (...

intapiuser by Community Team Member
  • 39 Views
  • 0 comments
  • 0 kudos
Community Toolbox

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

Need additional support?:

Community Support Request