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 values Define RGB shade magnitudes ...
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 expression...
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 - Sept...
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 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...
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 ImplementationPreparation Duplicate the Break By ...
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:
