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

Comments

88 comments

  • Avatar
    Elliott Herz

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

  • Avatar
    Brian Wilson

    Sure thing!

    I ran across this today:

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

  • Avatar
    Elliott Herz

    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

  • Avatar
    Elliott Herz

    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

  • Avatar
    Brian Wilson

    Hey Elliott -- Perfect. Instantly useful.

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

  • Avatar
    Elliott Herz

    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.

    Hope you enjoy!  =D

  • Avatar
    Christian Lira

    Nice innovative work Elliott Herz and thank you for sharing.

  • Avatar
    Admin

    Hi, I have found a bug, when using multiple categories, under some circumstances rendering of the chart breaks.

    Thanks,

    Pawel

  • Avatar
    Jim Thomas

    Hey Elliott,

    Great work.  This should go into the product.  Addresses a lot of needs.

    I just upgraded to v7.3.0.12008 this morning and I'm not seeing the Option Toggle for it in the Design Panel.   So far I've tried:

       - clearing caches and incognito mode in browser
       - disabling and reenabling plugins
       - pulling all the plugins out of the plugin folder and restoring them
       - IISReset
       - rebooting the server

    Is is not working in v7.3?  If so, is there anything else I should try?

    Regards, Jim

     

     

  • Avatar
    Elliott Herz

    Hey Jim,

    I just tested on v7.3.0.12008 and it works exactly as expected (I upgraded my environment this morning).

    You could also try restarting the Sisense.Plugins service in the task manager. Also is the plugin named correctly? Maybe when you re-added the plugins the customBarColumnChart was renamed (does it have a -master at the end of the folder? The folder needs to be called customBarColumnChart).

    Let me know if it still doesn't work.

    Best, Elliott

  • Avatar
    Jim Thomas

    Elliott,

    I restarted the Plugin service and checked the folder name.  The plugin is enabled.  I created a new column chart, but the Customize menu still doesn't appear.  This is on a customer's system running v 7.2.1.10226.  This is working for me on another customer's system running v7.2.  It must be something I'm doing or not doing.  Any ideas?

    Regards, Elliott

  • Avatar
    Jim Thomas

    Elliott,

    Found the issue.  The download folder was named "customBarColumnChart-master".  I removed master and all is good.  When I checked before, I looked at the name on the plugin admin page.  Duh!

    Thanks, Jim

  • Avatar
    Elliott Herz

    Hey Jim,

    Glad you got it working! I tested the plugin on all versions post 7.1.3. I did see an error on a 7.1.2 instance today. Let me know if you have any issues with it and I hope you get some good use out of it!

    Best, Elliott

  • Avatar
    Jim Thomas

    Hey Elliott,

    A customer just found that the sort order is not picked up by the PDF export.  The export shows the original alphabetical order.  Any chance of an update for that?

    Regards, Jim

  • Avatar
    Elliott Herz

    Hey Jim,

    Thank you for pointing this out! I just upgraded to V7.4 today and noticed the same. It'll take me a bit to investigate, but will try to update soon. It's interesting because this was working in previous versions, so it could be a conflict with a different plugin.

     

    Best, Elliott

  • Avatar
    Guy Shina

    The plug in does not seem to work on newest version

    Version: 7.4.1.10044
     
    The plug in does not seem to do anything - the setup shows and works the same but categories are not sorted
  • Avatar
    Jim Thomas

    Hey Elliott,

    Any luck on getting this working on v7.4.1?  I have a customer waiting to upgrade until this is fixed.

    Regards, Jim

  • Avatar
    Sven Willenberger

    7.4.1 user here and having same issue, Break by categories are not "Custom" sorting -- the order can be drag-dropped changed in the config panel, but it has no affect on the ordering of the break-by categories.

  • Avatar
    Elliott Herz

    Hey Guys,

    I'm gonna be investigating this further this week. Will update once I have an update. For some of this, it might be out of my control, so I'll try my best to fix what's not working, and give a timeline for other features that might not be working. Might need to wait for a future version of Sisense after syncing with R&D.

    Best, Elliott

  • Avatar
    Elliott Herz

    Hey Guys,

    After further investigation yesterday I understand why most of the sort breakby options aren't working in V7.4.0 to V7.4.2. The main reason is that some of the functionality that this plugin provides is making its way officially into the product in some of these most recent versions. Because of this push, some features have changed a little. As an example, breakby's are supposed to be sorted by a field called sortData, but unfortunately this is not the case in 7.4, and they seem to be sorted based on just the name of the field. I am actively working with R&D who made this change, so I suspect I'll have a fix for V7.4.3 or V7.4.4. Once that is tested and fixed I'll see what's going on with the PDF Export as well.

    By the way, minor releases are supposed to be every 3-4 weeks going forward. So hopefully this shouldn't take too much time.

    Best, Elliott 

  • Avatar
    Tim Friesen

    Thanks Elliott! We appreciate the work you put into this!

  • Avatar
    Elliott Herz

    V2.8.3 just dropped!

    Fixed most of the breakby sorts for V7.4. Still working on PDF reporting and the Breakby sort by category doesn't work correctly when filtering.

    Hope you enjoy!  =D

  • Avatar
    Elliott Herz

    Hey Guys,

    After further testing of the PDF export, I realized that everything is actually working correctly in the PDF export. There is another plugin that is conflicting with the PDF export, and was causing it not to work in my V7.4.2 environment. I disabled most of my plugins, and now everything works amazing in the PDF again:

     

    If PDF export isn't working for you, I'd recommend turning of plugins until it works, and then let us know which plugin is breaking the PDF Export. I remember there was issues with older versions of the JAQline plugin.

     

    Best, Elliott

  • Avatar
    Sven Willenberger

    I can confirm that the custom sorting (of the data) is now functioning as a custom break-by; my next question is how to get the legend to follow the same ordering. Case and point, I have break-bys done as %-ile buckets, namely (0, 0-25, 25-50, 50-75, 75-100, 100). While I can now sort the data points so that the bar chart orders them correctly, the legend is still out of whack with an order of 100, 0,50-75, 75-100, 0-25 (which I assume is the natural order the elasticube calculates. Without having to change the plugin itself, do you know offhand what the variable names are so I can just script a sort function (unless you are up for adding "sort the legends" feature).

  • Avatar
    Elliott Herz

    Hey Sven,

    This part of the plugin was also working back in V7.3. There is a new variable that R&D is using for the labels that is called a legendIndex (this dictates the sort order of the labels in the legend as well). I need to also add the legendIndex concept into my plugin as well.

    Give me a few days and hopefully I'll release a new version that fixes this.

    Best, Elliott

  • Avatar
    Elliott Herz

    V2.8.4 just dropped!

    Fixed the legend labels to also be sorted based on the breakby ordering.

    Hope you enjoy!  =D

  • Avatar
    Sven Willenberger

    Works like a charm! Thanks for keeping this plugin so up to date, esp. with the changes that R&D make to the underlying widgets.

  • Avatar
    Jim Thomas

    Hey Elliott,

    Great to meet you at the Masters Class.  I downloaded your latest and will test. 

    One comment:  I wasn't able to find this plugin on the Plugins list page:  https://support.sisense.com/hc/en-us/articles/115009313608-Sisense-Plugins-List

    My apologies if I just overlooked it somehow.

    Regards, Jim

Please sign in to leave a comment.