This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Cookie Policy. Click Preferences to customize your cookie settings.
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...
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 ...
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...
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...
In the example above, the interval was set to 7.This will work for any data type.Widget Script:widget.on('processresult', function(a,b){ b.result.xAxis.tickInterval = 7 })
Notice how Denmark's data above is significantly lower than the other country's.In spite of not falling into the selected top 10 range, it will still show on the chart for comparison purposes.Steps To ImplementationPreparationDuplicate the Break By D...
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 ...
Analytical Need Gauges are types of widgets that are very helpful in presenting progress or whether a KPI is met such as current state vs. expected state based on previous calculated value.At times, we might be interested to show a target that needs...
Analytical Need When designing our dashboards and widgets, we should always consider the visuals and UI to convey the message of our widgets and help our users to consume the data easily, and take actionable business decisions based on it.Many times...
Recommended Quick Links
Developers:
Product Feedback Forum:
Need additional support?:
The Legal Stuff
Have a question about the Sisense Community?
Email [email protected]
