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

Knowledge Base Articles

Enabling Timezone by User

Analytical Need Often times, you would have the need to support user across the globe that are digesting data from your dashboards. At these scenarios, the timestamp that was recorded and stored in the DB could be different for the users based on the...

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

Formulas Creating "Random Paths" Between Dimensions

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 betwee...

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

Elasticube Modeling With Data Security: Best Practices

Adding Data Security to an existing Elasticube Model can have little to great effect on the performance of the system. It is important to already have planned the Elasticube Model with the intention to apply Data Security in the future. This article ...

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

Unit conversion between Metric and Imperial (US)

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 on t...

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

Switch Between Metrics

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 time...

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

Data Accumulation Guide

Data accumulation is SiSense's method for building ElastiCube data without completely refreshing a table. This post describes the data accumulation functionality and gives a user the ability to customize and optimize their ElastiCube build process.Th...

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

Forecasting using Macro Trend and Seasonality

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...

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

Creating Timeline from Start and End Dates Columns

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...

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

Creating Custom Time Buckets in Elasticube

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, 3...

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

Key Table: Store data relationships between primary key values

Analytical Need A key table (click the link to download a demo Data Model) is a central table that stores all the relationships between the primary key values. Modeling Challenge The main advantages of using Key Table: It helps to tidy up a schema th...

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

Add 'Week of' to Custom Hierarchy

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 Da...

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

Trend Analysis

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...

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

Data Transpose Guide

Source data that is flattened may require some or all of the columns of a source table to be transposed, in order to work seamlessly with SiSense’s functionality. This post will outline the cause and two possible solutions to this issue. The first so...

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