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...
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...
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...
IntroductionSometimes when your analyzing sales you may want to look at products that are not being sold. Or maybe for a service provider you may want to see territories where you have no subscriptions. Unfortunately, data typically does not contain ...
IntroductionThis Post Explains how to create a new column that will calculate the week number of a Quarter.Business CaseIn many cases Business Analyst would like to track trends over time aggregated by quarters but broken down to the week within each...
Analytical NeedFact tables may include a wide date range. For instance, a table can have historical dates without any transaction of the current year,The Need : filter the dashboard based on the latest year in the data Modeling Challenge We need to f...
For general information on types of data relationships, potential complications and how to resolve them, see the following articles: Data Relationships: Introduction to Many-to-Many Data Relationships: Check Type of relationship Data Relationships: O...
Analytical Need In many use-cases, there’s a need to measure entities throughout their life cycle which spans from their ‘Start’ date to ‘End’ date. For example insurance company wants to count how many active policies there are on any given day. The...
For general information on types of data relationships, potential complications and how to resolve them, see the following articles: Data Relationships: Introduction to Many-to-Many Data Relationships: Check Type of relationship Data Relationships: O...
Analytical NeedCohort is a group of items who share common characteristic over a certain period of time. The Cohort analysis helps us identify the relationship between their characteristic and their behavior along relative periods of time. Modeling C...
Introduction Surrogate Keys are mainly used for creating a single identifier for multiple dimensions, mainly when building a Key Table. A text key can be easily generated by concatenating the text and delimiters, however, text can become very long an...
**Please refer to the following article for extended functionality: Performing a Front End Left Join ** This article presents a data modeling based solution that may allow you to create a simple Left join within one certain widget. Custom SQL Table"J...
Analytical NeedData security is implemented when there is a need to prevent the users from seeing the entire set of data. Each user only needs to see a data set based on permissions that is defined in Sisense Web. Here we will discuss how to solve a ...
Analytical Need When we want to measure the service level we provide our customers we can do that using many different KPIs. These differentiate between industries and management decisions. This modeling use case is focused on employees in stores - m...
Analytical Need Calculate the time difference between two events in a fact table.In the example, we want to measure how many days it took to complete each task in a shipment process. Modeling Challenge Orders fact table has 3 fields: Order ID, Status...
Recommended quick links to assist you in optimizing your community experience:
Developers Group:
Product Feedback Forum:
Need additional support?:
The Legal Stuff
Have a question about the Sisense Community?
Email [email protected]
Share this page:
