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 ea...
Rules To Live By When Designing An Elasticube A list of recommendations which should be considered when developing an elasticube. Start Small Build your ElastiCube incrementally. Start with only two tables, create an appropriate relationship betw...
This article demonstrates two methods to count the number of days that passed from one event to the other for a specific category (i.e number of days passed between one sale to another by sale code). The preferred way to do this calculation is in a c...
ProblemAdvanced formulas can sometimes return wrong results (or no results at all) when combining dimension-affiliated calculations** with dashboard or widget filters based on a second dimension.Certain calculations may include backstage joins betwe...
Analytical NeedThis dimension table keeps every change that has been made. The user wishes to see historical data per the dimension and not just the current state.Example: Transactions per organizational hierarchies, price list, historical currency ...
Analytical Need You have an international user base, some who use the Metric system and others who use the Imperial (US) system. You want to display dashboard values and calculations in the units that the user wants, or perhaps pre-defined based o...
Analytical Need There are many cases when we will want to measure a metric by a different angle or definition. For example, in some cases you would like to allow your end users to analyze average duration of a resource utilization in a different t...
Forecasting using a macro trend (moving average) and seasonality (seasonal index) is a common way to forecast data into the future. The two components, seasonal index and moving average, are based on prior historical trends. They come together to for...
IntroductionThis article will demonstrate how to quantify on a date axis the availability \ unavailability of products given only the start and end date of each product's availability (See data format in "ProductData,csv" table below).Business CaseVi...
IntroductionThis article explains how to create a custom field which rounds timestamps (Date-Time) up into time buckets. The buckets outlined in this article include every hour on the hour (10:00 AM, 1:00 PM), every hour on the half hour (11:30 AM, ...
In this post, we show the formula to calculate the shortest distance between two points using Latitude and Longitude.This calculation can be useful when trying to determine the distance for logistical purposes (ie delivery service, flights, distance ...
IntroductionThis Post Explains how to create a widget hierarchy that includes ‘week of’ as a member of the hierarchy. (Calculates first day of that week)Business CaseAs a business Analyst, I would like to drill down in a Bar Chart with Dated Sales ...
Trend analysis enables users to compare actual totals against measures derived from the data. This will enable users to compare actual results against derived amounts, and even project those amounts into the future. This example will use a simple ave...
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...
Analytical NeedIn many cases a hierarchy appears in the data structured as 2 levels - A parent and a child. The business user would like to see the entire hierarchy and analyze the data according to the different levels, but can't do that since they...
Analytical Need For different use cases, it can be relevant to present a timeframe of different business entities and the relations between them. For examples, such use cases can be: Present hotel vacancies by room number or typeAnalyze ticket...
Analytical Need We may encounter a situation in which a table has several fields that together identify each record. Each of them may appear several times but their combination is unique. Modeling Challenge In our data model, we have 2 tables that ...
Analytical Need We have one central source for our measures and multiple sources to slice & dice these measures. Modeling Challenge How do we build a schema that will enable us to perform our needed analysis?We will need to connect all of our table...
Analytical Need There are cases where we need to define an association between two entities. This association is comprised of the entities and not by each of them separately. For example, students & courses. We need to have a list of each student...
Use Case:Sometimes, we would like to create calculations from the fact table and we need to have a continuous range of dates or in other cases, we need to count the number of employees (just as an example) that we have in the company.We strongly reco...
Recommended Quick Links
Developers:
Product Feedback Forum:
Need additional support?:
The Legal Stuff
Have a question about the Sisense Community?
Email community@sisense.com
