Analytical NeedFact tables may include multiple dates per record. For instance, a record can have an open date, a closed date, an updated date etc. Modeling Challenge We need one time dimension since we don’t want the user to use multiple date fields...
Analytical Need We have multiple sources 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 tables s...
Analytical Need There are cases where we want to analyze our measures as a comparison between periods of time. For instance, ee want to know how did our measures behave on January this year vs. previous year. This means that we have to put down in ou...
Analytical Need A common requirement in data analysis is to be able to view and compare slices of data from different time periods to current date. Business applications for this vary, from identifying trends to predicting future behavior, requiremen...
Analytical Need In a dashboard, we wish to analyze how our entities (sales, inventory, tickets etc.) behave and break them by several categories. However, not all entities share the same categories. We wish to avoid a situation in which selecting a v...
Analytical Need The data is stored in a certain currency and you would like to present it in the dashboard converted to different currencies. Modeling Challenge As a designer, I would like to have a dashboard filter of currencies in order to switch b...
If you want each date to “belong” to its “actual year” you can use the ISO way to calculate the week number.For example, if 1/1/2016 is on Wednesday and you want the 1th ,2nd and 3rd to belong to the first week of 2016 and the 4th to belong to the se...
Analytical Need I have historical transactional data starting from 2012. Some are recorded in USD, others in EUR. I need to convert these values to USD based on the exchange rate on the date of the transaction. My Elasticube is built on a daily basis...
There are situations when your data needs to represent a many to many relationships such that your dimension members are at a lower grain than related facts; aka multivalued dimension. In these cases, a single fact record should relate to multiple di...
Overview:Many times, we'd like to analyze workload over time. The following article describes a modeling solution approach to an often asked question: "How many active items are there per day?" Analytical Need:Counting the number of open tickets per ...
OverviewThis post offers food for thought in regards to how R can be used to retrieve the real-time datetime with the RDouble function. It shows how to run date comparisons using the R syntax. ChallengeNormally if you want to compare a datetime to "n...
DescriptionA common visualization is a comparison between personal KPIs and the rest of the team KPI averages. The main challenge is when applying a security configuration, the other users’ data is filtered out Example A typical Elasticube for sales ...
You might want to compare MoM on a daily average, which means to take the daily average of the current month (even if the month isn’t over yet), and compare it with the previous month’s daily average. You might also want to do the same for QoQ, meani...
Analytical Need Sisense comes with a function called Median() to calculate the median of a set of values. However, this function works with one assumption: we have all the values stored in one column and each row in the table represents one occurrenc...
Data PreparationOrange: Borrowed from another table via lookup() Blue: Custom columnIf the first visit date is available in the dimension: Lookup the user’s First Visit Date from the dimension table in a custom column of the fact table based on the u...
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:
