Custom Bar/Column Chart Plugin (Show Totals, Sort Categories, Sort Breakbys)

Steps to install (Current Version is V2.8.2):

Download from my GitHub
Download a ZIP of the project, Unzip the folder customBarColumnChart-master, add it to your plugin folder, and rename the folder customBarColumnChart

Description:

When you add a breakby to a bar or column chart, you lose the ability to see the total value for the bar/column, you lose the ability to sort the category based on the total amount in each bar/column, and you never had the ability to sort the breakby. This plugin allows you to do all 3 in an easy to use way. In addition, you can also sort a column/bar chart in any custom predefined configuration.

Example Usage:

Put plugin in /plugins folder and make sure the folder is called: customBarColumnChart
Create/Edit column/bar chart
Activate "CUSTOMIZE CHART" option on the Design Panel.
Play around with a few options
EASY SUCCESS! =D

Here you can see the new menu option in the bottom right of the screen outlined in red:

I easily turned on the CUSTOMIZE CHART option, and decided that this chart would be more useful if I could show totals for each column, sort the categories descending, and sort inside the breakby so that the most recent dates are at the top of the column instead of at the bottom.

You can easily click between the various options to see what works best for your usecase! It works on both Column Charts + Bar Charts, and you can play around with all 3 Types (Classic, Stacked, Stack 100). This also supports slice/highlight filtering, drilling, jumping, and even PDF reporting.

Here is another chart that demonstrates a non-stacked bar chart:

In this second example, you can see how the categories are sorted ascending based on the total bar value, as well as how the breakby is now sorted from largest to smallest based on the totals. You can see breakby (legend) is in the same order as the category sorting on the above chart (Bikes was the largest total, Cables & Housing was the smallest total).

Did I mention it supports Column/Bar charts that have multiple series but no breakby as well!

You can even configure your own custom sorts:

This bar chart now has the categories sorted where the countries starting with M and N are at the top. The breakby can be sorted the same way. All you have to do is drag and drop items based on your liking. As soon as you click off to the side of the popup or click Save, the configuration will save. If you don't like the updates you made, just click cancel. If you ever want to you can reset the configuration as well.

There is also functionality to configure the Show Totals:

Here is the widget script for the left chart:

widget.on('processresult', function(w, args) {
 //args.widget.custom.barcolumnchart.totalLabelEnabled = false; 
 args.widget.custom.barcolumnchart.totalSeriesName = 'Total (YOU CAN NAME THIS SERIES)';
 args.widget.custom.barcolumnchart.totalPointColor = 'green';
 args.widget.custom.barcolumnchart.totalPointFontSize = '20px';
 args.widget.custom.barcolumnchart.totalPointSize = '7';
 args.widget.custom.barcolumnchart.totalAsLine = true;
 args.widget.custom.barcolumnchart.totalPointFontFamily = 'Times New Roman';
 args.widget.custom.barcolumnchart.totalYAxisPercentSpacing = 100;
 args.widget.custom.barcolumnchart.totalLabelPadding = 100;
});

Here is the widget script for the right chart:

widget.on('processresult', function(w, args) {
 args.widget.custom.barcolumnchart.totalPointColor = '#19b9c9';
 args.widget.custom.barcolumnchart.totalPointFontSize = '13px';
 args.widget.custom.barcolumnchart.totalPointSize = '0';
 args.widget.custom.barcolumnchart.totalAsLine = false;
 args.widget.custom.barcolumnchart.totalPointFontFamily = 'Times New Roman';
});

Overall this plugin should be a huge nice to have for most! I hope you enjoy and I’d love to get your feedback! =D

Special Thanks to Artem Yevtushenko for his sorting breakby script. Very big thank you to Jason Sears for teaching me how to make the plugin more responsive and PDFable. Very big thank you to Shani Adani for showing me how to make the plugin responsive even when you change the chart types, and for helping me clean up the code.

Elliott Herz January 02, 2019 23:23

Thank you! I really appreciated the feedback throughout the creation as well Brian! =D

Brian Wilson January 03, 2019 14:40

Sure thing!

I ran across this today:

Any thoughts on an option to sort by individual value inside of each category?

Elliott Herz January 03, 2019 15:02

Hey Brian,

It's a good idea and I've had a few people ask me already. Based on initial investigations it didn't seem possible, as Highcharts officially said they don't support such a feature, but after more investigation this morning, it looks like someone was able to override some of the highchart rendering functions to accomplish it. I am not sure if I can access/override these settings in Sisense though. So let me play around and I'll let you know if possible.

Best,

Elliott

Elliott Herz January 04, 2019 20:42

V2.8.0 just dropped!

New breakby sorts for Asc/Desc per Category. This allows you to sort each categories breakby indepedently.

Hope you enjoy! =D

Brian Wilson January 07, 2019 17:44

Hey Elliott -- Perfect. Instantly useful.

One bug: negative values are sorted as if they are ABS().

Elliott Herz January 14, 2019 15:39

V2.8.2 just dropped over the weekend!

Fixed the BreakBy Asc/Desc per Category Sort with negative values. When there are negative numbers, both stacked charts are a bit confusing...expected behavior is debateable.

I noticed that there can be an issue with showing totals when there are negative numbers in a column/bar as well, so currently working on fixing that.

Custom Bar/Column Chart Plugin (Show Totals, Sort Categories, Sort Breakbys)

Comments

Didn't find what you were looking for?