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

Knowledge Base Articles

Advanced Forecasting With R

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

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

Ordering My Pie Chart From Largest Percentage To Smallest

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

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

Using "Now" In A Dashboard Function Date Comparison With R

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

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

Filter For Last Working Day

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

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

Maintain Percentage Contribution Using ALL Function

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

intapiuser by Community Team Member
  • 2161 Views
  • 0 comments
  • 1 kudos

Divergent/Negative Bar Chart

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

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

Cohort Analysis

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

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

Hide Values After Sorting In Column/Bar/Line Charts

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

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

Using BloX To Dynamically Change A Dimension

The goal is to allow users to dynamically choose a dimension. The below script will work with a table or a pivot table, but it can be modified to work with other widget types as well. Step 1Create a BloX widget with the below script. It will consist ...

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