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

Knowledge Base Articles

Calculate Running Sum

Analytical Need There are cases where you wish to know for a certain point in time, how much you have accumulated up until now.This is called Running Sum.Although it is possible to use this in the dashboard, we may need to have the running sum on eac...

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

Blox Dropdown Placeholder

By default, BloX will use the first element in your dropdown as the default text in the dropdown box.Instead of this value, the following method adds a different default non-selectable value.Steps For Implementation Add the addPlaceholder class to yo...

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

REST API - Adding Data Level Security

When building code to automate the process of adding users (or groups), it may be beneficial to add security around those users. Follow the steps below to learn how to add data level security through the REST API: Step 1 From your SiSense home page, ...

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

Calculating Weighted Average

Analytical Need Weighted average refers to the mathematical practice of adjusting the components of an average to reflect the importance of certain characteristics. This practice can be useful in different scenarios, a few examples: In economics, thi...

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

Time Dimension

Analytical Need Many times we would like to deep dive into our data and view it in a more granular fashion to conclude from it. Certain business needs might require us to use date-time hierarchies to help us understand performance trends such as Sale...

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

Dynamic Dimension/Value Chart

Version: 1.1 Download the plugin attached Introduction This article explains how to install and configure the Dynamic Dim/Value Chart plugin as seen below. The Dynamic Dim/Value chart allow Dashboard designers to predefine multiple dimension and/or v...

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

SisenseJs Custom Filter Samples

Gitlab Link: https://gitlab.com/SisenseJS/filter-samples This project was created to show several ways to integrate 3rd party components with Sisense.js. Many web apps that leverage Sisense.js for embedding do so because they already have a consisten...

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

Color Heatmap

Version: 1.4 DisclaimerUse the download Link for L2023.7 or newer. For older versions of Sisense, use the other attached version of the ColorHeatmap pluginIntroductionThis article explains how to install and configure the Color Heatmap widget as seen...

intapiuser by Community Team Member
  • 1096 Views
  • 2 comments
  • 1 kudos

Pivot2. How to set up styles with the scripts?

Currently, in Linux installation, you can face widget [Pivot2]. This is a new realization of the widget [Pivot]. This means that it has new styles, new classes, etc. Almost all the scripts to change styles of the resulting table used DOM selectors to...

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

Quickbooks Online: Customizing Table Schemas

Connecting to Quickbooks online. Begin with downloading the connector. Create an app in Quickbooks online environment Creating an AppYou can follow the steps below to create an app and obtain the OAuth client credentials, the consumer key and consume...

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

Weighted Vs Unweighted Averages

When summarizing statistics across multiple categories, analysts often have to decide between using weighted and unweighted averages. An unweighted average is essentially your familiar method of taking the mean. Let's say 0% of users logged into my s...

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

Test For Normal Distribution Of Data With Python

One of the first steps in exploratory data analysis is to identify the characteristics of the data, importantly including a test for distribution patterns. In this example, learn how to check if your data is normally distributed in Python with a visu...

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

Get Yesterday's Date

Often times, we want to analyze data with the date from yesterday. How do we auto-populate yesterday's date? There are a few formats that we can use! The syntax below lets us get yesterday's date with timestamp:select dateadd(day,-1,getdate()) To onl...

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

Pivoting And Melting Dataframes

Here's the scenario: you just used SQL and have an output that shows the results you want, but it isn't optimally displayed. Instead of writing cumbersome case when statements, unions/union alls, we can quickly use a few short functions in Python or ...

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

Gantt Chart For Team Workflows

Gantt charts are a great way to show which projects and tasks different teams are working on at a given time. This chart type is heavily used by Project Managers, Task Managers, and anyone else managing multiple workflows.Using Periscope Data's Pytho...

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