Users could sometimes want to compare performance on a particular time period vs the immediately preceding period. Sometimes those periods are not of a common size like months or quarters. It could be a campaign that lasts a few days, or an arbitrar...
How to Calculate Absolute Sum We have a table with data and we are going to calculate the absolute SUM for [sum] column. We divide this into two parts. First of all, we SUM all positive values with the formula ([Total sum],[sum1]) Th...
Requirement In this article, we will look to create a personalized dashboard navigation landing page that shows: The logged user's most popular dashboards.Most popular dashboards on the company level. Consider further enhancing the logic present...
How to Change the Pivot Header Row Style with TransformPivot This solution is based on Pivot 2.0 API supported in Sisense version L8.2.1 or later (not supported in Sisense for Windows). For this solution, we shall use cellStyle from Pivot 2.0 API. T...
If you are using a gauge indicator in your dashboard and want to make the gauge reflect a percentage like shown below (elasticube is Sample Retail) - Follow the steps below - Steps:1. Create an indicator widget and add a value you want to review. In ...
Please note this article is useful for Windows users and users who use older Linux versions that pre-date the Analytical Engine. Control charts are a common way to show a trend line of some metric, as compared to an upper and lower boundary. This...
Sisense has the capability to share a local file (excel, word, pdf etc.) with dashboard users. Note: The file must be saved on the server in the following path: %programfiles%\Sisense\PrismWeb. You can create a new folder or save it under 'Resour...
CaveatsIf you have windows, the only way to do this in a way that will show up in exports is to create a string representation of the date in the elasticube and use that. There are limitations. If these are significant, look at a move to Linux. This ...
Many times we’d like to be able to compare a few items out of a large set to see how they relatively behave. For example, how a certain period did compared to any other period, or how a certain country’s sales or sales representative achieved compar...
In this post we will cover two scenarios:Legend-Based Color: conditionally format the elements in order that they appear in the legend (alphanumerically)Value-Based Color: conditionally format the elements by their total sum (or an aggregation of you...
IntroductionThis article describes how to dynamically color the Data Bars within a pivot table based on the cell values. Presented here are two methods:Use stock gradients to provide different colors based on cell valuesDefine RGB shade magnitudes ba...
IntroductionThere is no OOTB option to roll up a date by the day of the week.Use this simple trick to achieve this with a simple custom field which will display and sort as a calendar day without any additional script.InstructionsCreate an expressio...
IntroductionQuick functions are a great way to perform comparative analysis based on time periods. However there is no easy way to do a comparison to date. e.g. YTD vs YTD Last Year. e.g. If today is Sep 27, 2018 then we want to compare Jan 01 - Sep...
IntroductionUsing line markers can be a great way to compare data whether it be over time or across a category. However, creating a marker requires using the Javascript API to hide the line. The steps below outline how to remove the line from a serie...
IntroductionThe purpose of this article is to show you how to use a bar chart as an indicator to provide an overview and allow you to make selections.Bar charts are normally used to provide quantitative visualizations across wide sets of data. Howeve...
The purpose of this post is to provide the instructions to use a bar or column chart to create a widget where you can compare a value such as revenue to multiple goal levels. In order to do this I had to add a slight modification in the Elasticube. T...
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...
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 contributio...
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...
