Month to Date (MTD) and Year to Date (YTD) calculations provide us results of activity in the time between the beginning of a date (can be a month or year in our example) and the beginning of the current month or year. This in turn allows data analys...
Browsing our site, speaking to our team, or reading about us in analyst reviews, you might have noticed that we dig technology here at Sisense. That’s why when clients and prospects desire to push the limits, both in terms of data complexity and quan...
Analytical Need You want to display a value for a selected member (i.e. Salesperson) vs the min/max of all non-selected members. This can be achieved using modeling techniques but this solutions describes how to do it purely in the front end. Solutio...
Analytical Need For a metric, I need to calculate the month difference between the min and max date of purchase for each brand in my dataset. I want the dates to be dynamic in respect to filtering, etc. I am using the attached .ecdata and .dash files...
This article will show how to set conditional formatting on a specific value based on another one that doesn’t directly relate to it. For example, when one wants to show a total of revenue in a specific region and set its color to green in case the m...
Analytical Need Pareto analysis is a technique based on the Pareto Principle which states that 80 percent of problems or effects are produced by 20 percent of causes. This type of analysis can be useful in the stage of decision making, to identify th...
This page is intended to keep a focus on Dashboard design in terms of: Planning Implementation User experience and functionality Dashboard training for end users Dashboard PlanningDashboard planning goes hand in hand with project planning, and will e...
Introduction:The below article will provide a BloX template that will help you create a dropdown filterThe ‘Dynamic Dropdown’ snippet allows you to populate your dropdown list with a list of values from a specific field (for example, list of Brands)....
Analytical Need Attached below is a BloX template.A common request is to have a 'From To' input at the top of the dashboard to affect a calendar range selection of dates.To achieve this need we can utilize BloX's form capabilities.Picking a date rang...
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, requirements or issues. In...
Analytical Need Aggregation functions are used to group a set of values to perform calculations that return a single value. SUM(), MEDIAN(), and COUNT() functions are some of the most common aggregation functions examples. Simple aggregation function...
IntroductionThe following enables to change the value in pivot tables to specific strings, while allowing the use of conditional coloring as normal.Step 1 - Add The Following Script To Your Pivot's Edit Scriptwidget.on('ready', function(){ $('td[clas...
In this post you can learn how to automatically 'Restore Dashboard' on each page refresh or opening, this setting will always restore the dashboards initial published state for your viewers and designers.This can be used for cases where you would lik...
After publishing a widget, we can access it's attributes to further modify it to our requirements.Step 1 - Find the Widget titleNamed 'widgettitle' from the browser's console, by adding a 'debugger' to the this.initializing of the dashboard. In the t...
Below gives a solution on how to compare this year results up to today with previous year until the same parallel day.Solution: If you want to compare this year and the previous year you can add a widget filter where you will choose the current day (...
Recommended quick links to assist you in optimizing your community experience:
Need additional support?:
