Custom Bar/Column Chart Plugin (Show Totals, Sort Categories, Sort Breakbys)
Featured
NEWEST UPDATES:
**Now includes custom sorting on both categories + breakbys**
**Rebuilt the Custom Sort Popup**
Steps to install (Current Version is V2.2.1):
- 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. You can also now sort a column/bar chart in any predefined configuration.
Example Usage:
- Put plugin in /plugins folder and make sure the folder is called: customBarColumnChart
- Create column/bar chart and hit apply
- Edit widget and on the Design Panel activate "CUSTOMIZE CHART" option
- 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 (NOTE: if you switch the chart type while editing, you won’t be able to see the options taking affect in the edit mode until you hit apply and then refresh the dashboard). If something isn’t working, first try to hit apply and then refresh the dashboard, if it still isn’t working, please respond in this post.
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).
Here is a similar example but with a stacked 100 (NOTE: This doesn’t support totals as of right now).
In this example you can see that the largest breakby total is on the left compared to the smaller amounts on the right part of the bar.
Did I mention it supports Column/Bar charts that have multiple series but no breakby as well!
Brand New Options for Custom Sorts:
This chart is now sorted where the Countries starting with M and N are at the top. The breakby sort is also set to a custom configuration as well.
Here is the menu to configure the ordering for the custom sorts:
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 Config, 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, this change takes effect immediately, so even if you hit cancel, the configuration is reset.
In V2.2.0 I added the functionality to configure the Show Totals (I'm considering adding a popup for these format customizations, but not sure if that is overkill at the moment):
Here is the widget script for the left chart:
widget.on('processresult', function(w, args) {
args.widget.custom.barcolumnchart.totalPointColor = 'green';
args.widget.custom.barcolumnchart.totalPointFontSize = '15px';
args.widget.custom.barcolumnchart.totalPointSize = '7';
args.widget.custom.barcolumnchart.totalAsLine = true;
args.widget.custom.barcolumnchart.totalPointFontFamily = 'Times New Roman';
});
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';
});
Here is a list of currently known minor issues:
1) Breakby reverse sort can be problematic with dates (due to minor bug in the product). Page refresh solves it.
2) Custom breakby reset button doesn't work well with dates, they will be sorted alphabetically instead of by date equivalent
3) Can't scroll most of the time in the modal popup.
4) Plugin won't take effect when switching chart types (including during the intial creation of the widget). Just hit apply and then refresh.
5) During the export, the total points are connected with a line (this is due to the phantom process being run in IE10).
6) Currently doesn't support more than 1 field in the Categories Section.
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.
-
Hi Elliott! This is a great plugin, thank you! We are finding it very useful!
I had a quick question though, is there a script to customize the font for the totals? We have a use case where we need to make the font larger for visibility sake when we download the widget to use in a powerpoint slide.
EDIT: I figured out how to do this by modifying the plugin itself, but it would be great to have the option to apply custom formatting to the font (size, weight, color, etc) within the plugin!
Thanks for everything you've done!
-
Hey Megan, Thank you for the great feedback!
V2.2.0 just dropped!
Just added the ability to add a quick widget script to customize the Show Totals easily. As of right now this is as an added script, I am considering adding to a popup. Please see above updated documentation as an example.
Hope you all enjoy! =D
-
Hi Elliott,
The plugin looks great, very useful in many cases that we needed to find ad-hoc solution for our clients
With that in mind, I'm wondering whether to replace the current workaround/hacks that we've done to achieve some of the functionality described in this widget to some of my clients.
Do you consider this one as a stable plugin that will be maintained in the future alongside new versions of Sisense?
Thanks,
Ravid -
Hi Ravid,
Thank you for the feedback! As of right now, the plugin is considered an un-supported Sisense plugin. I did go through a decent amount of testing, and the plugin does seem very stable. For the time being, I'm going to be personally supporting this one, so if you find any issues, please let me know so I can fix them. If this plugin gets a lot of traction, it is possible that it can become an officially supported one.
So overall, I recommend that you use the plugin at your own risk as it is "unsupported".
Best,
Elliott
-
Hi Elliott.
One little issue : when "none" is selected I get this :
While reverse gives this :
Side note, I find "none" to be misleading/imprecise... Maybe consider Default or Asc?
Also, in the custom ordering of my break by, when I move a category it disappears. Haven't really been able to get the results I was aiming for in my tests, but you definitely are on the right track with this option.
I will definitely keep an eye on this. Keep up the good work.
-
Hey Carl,
So I tested this out and I can't quite replicate. I'm actually a bit surprised that None gives different results than when the plugin is disabled. Are you testing in IE11 or a different browser?
As a note, I do know that there is a minor bug in the product that can cause None and Reverse to show up incorrectly, but that is because the data is already coming back non-alphabetically sometimes.
Again, very much appreciate the feedback!
Best,
Elliott -
Hi Elliott,
Yes sure, this looks much cleaner, generally standard Sisense popup window would look better and more consistent J also, as you can see, there is a little drag and drop, not sure if you can utilize that, maybe some styling of the fields to follow the same idea? Btw. Don’t look at the colours, we modified them slightly.
Thanks,
Pawel
Please sign in to leave a comment.
Comments
40 comments