Purpose: To create a product aggregation in Sisense (multiplies all values together, similar to the way a sum function adds all values together). Situation: A financial use case has a table with relative daily gains/losses for certain securities (thi...
ARIMA Model ForecastingARIMA Model Forecasting Mean and Upper 95% LimitOVERVIEWIn this article, we tackle how to produce a robust forecast by using the Sisense and R integration.UNDERSTANDING THE NUANCE OF RFor forecasting functionality, we must cons...
Challenge When you set the Carousel to false the widget will stack new items vertically. When we want the widget to populate itself horizontally we can use this code to change the display to inline-block instead of block. Solution In the widget edito...
Modeling Need:My pie chart is ordering the data in alphabetical order by category. I am looking to order the data from largest to smallest percentage.Solution:I can change the widget type from pie chart to column chart. Then order the values in desce...
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...
When a filter based on this custom column is active, the dashboard will reference the last working day.If the dashboard is checked on Monday or Sunday, Friday's data will be shown. If the dashboard is checked on Tuesday - Saturday, the prior day will...
Analytical Need Even though this requirement sounds fairly simple, a lot of times, this use case gets confusing. If there are 10 stores for a Retail Chain, sometimes the Management would only want to compare 3 stores and split the entire contribution...
Sometimes you may want to compare two values alongside each other to measure impact of one vs the other but without stacking them or having them side by side.This is often called a divergent bar chart.This can be done in Sisense with just a little bi...
Analytical Need It is always a common ask from the business to compare the daily metric of a selected date and then compare it to the last year same period metric. The same period could sometimes be the same day of the same week of last year – for ex...
Analytical Need A lot of business use cases revolve around utilization of resources and their productivity where the resources could be their inventory, machines, carrier or the human resources of an organization i.e., employees. That’s when monitori...
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...
Works With Any Chart Widget That Allows Right/Y2 Axis.CHALLENGE:As a dashboard designer you might want to sort the X axis of a chart based on some aggregated values but want to show another aggregation. For example:In the below widget we would like t...
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:
