Note: We are actively completing a knowledge migration process. This space will grow over the next few months as this work is completed.
Showing results for 
Search instead for 
Did you mean: 

Knowledge Base Articles

Calculate Average Time Between Transactions

Introduction Calculating transaction frequency for a given dimension is a common requirement across many verticals. e.g. Average Time Between Purchases by a Customer. Average Time between support tickets etc. While this can be calculated in SQL it ca...

Calculating Values For The Most Recent Date

The point of this article is to provide a method to a value associated with the most recent data in a date selection. Implementation Step 1: in the Elasticube, create a field transforming the date field into an integer using the formula below. Then r...

Community_Admin_0-1634681408782.png Community_Admin_1-1634681408855.png Community_Admin_2-1634681408858.png Community_Admin_3-1634681408852.png

Fiscal Year Adjustments

Analytical Need Customer's fiscal year does not comply with the Georgian 12-month calendar and starts on a different date than January 1st. Example: Customer’s fiscal year is from April 1st to March 31. This means that April should be flagged as the ...

Market Basket Analysis

Analytical Need Market Basket Analysis is a data mining technique that is widely used to identify consumer patterns, such as which items are purchased together, or how the purchase of one item affects the likelihood of another item being purchased. O...

Community_Admin_0-1634556348041.png Community_Admin_1-1634556348058.png Community_Admin_2-1634556348016.png Community_Admin_3-1634556348055.png

Data Relationships: Introduction to a Many-to-Many

A relationship between tables specifies the field/s which the 2 tables have in common. In Sisense, we create relationships between tables in the ElastiCube. Poorly modeled data relationships can lead to one or more of the following: Complex data sets...


Date Dimension File

Analytical Need Analyzing information by date can be very useful, but not every source data set provides enough information to do this kind of analysis. Modeling Challenge We will need to import a date table, which will act as a reference for all tim...

Represent Time in Widgets

As Sisense currently supports daily data, in the following article we will demonstrate how to include time in Sisense Web widgets that is present in DateTime fields. In order to display time format along with date we would Represent DateTime field as...


What is UAT? After the dashboard is completely developed and has been approved in QA tests, the final stage, before releasing a dashboard, will be to request a key end-user to perform User Acceptance Test. The approval of the dashboard will give the ...

BI Solution: High Level Design

Based on the business requirements summary you've created in the previous step, you can now design the high-level overview of your BI Solution. This step aims to translate the business strategy into operational terms and associate it with the require...

Community_Admin_0-1634555300987.png Community_Admin_1-1634555301027.png Community_Admin_2-1634555301053.png

Business Requirements Gathering

The Business requirements gathering step aims to identify the end-users' key business requirements and KPI's to build customized dashboards that meet their needs. Well-defined requirements are the foundation for a clear, comprehensible dashboard, tha...

Calculating Business Days Difference Between Two Dates

Introduction This article demonstrates how to avoid counting weekends and holidays when calculating the difference between two dates. Example - Average Shipping Time in Business Days Steps In order to ‘subtract’ two dates and avoid counting the weeke...

Community_Admin_0-1634478483204.png Community_Admin_1-1634478483202.png Community_Admin_2-1634478540282.png Community_Admin_3-1634478586686.png

Days, Hours, Minutes, and Seconds Drill Down

Introduction In this post we'll learn how to create a drill down hierarchy for Days-->Hours-->Minutes-->Seconds. A general quick solution, in case you need the drill mostly for pivot table visualizations, would be to use the ElastiCube to model addit...

Community_Admin_0-1634474210778.png Community_Admin_1-1634474210744.png Community_Admin_2-1634474210740.png Community_Admin_3-1634474210670.png

Benefits of JSON support in Postgres

The promise of Postgres JSON JSON support is the most interesting new Postgres feature of the last few years. It relaxes the primary constraint of SQL databases — the rigid schema structure — by letting you store semi-structured data in your tables a...

Community_Admin_0-1634046323380.png Community_Admin_1-1634046323350.png Community_Admin_2-1634046323260.png Community_Admin_3-1634046323396.png
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?