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

Comments

102 comments

  • Avatar
    Admin

    Hi Ravid,

    the plugin looks great however, I think this should not be a plugin but a standard functionality built into the product .

    Thanks,


    Pawel

    4
    Comment actions Permalink
  • Avatar
    Brian Wilson

    I'm sure I've barely scratched the surface, but just the ease of sorting grouped columns is ... well, I won't say life-changing, but it's at least really nice :)

    1
    Comment actions Permalink
  • Avatar
    Korey Martin

    This is awesome - thank you, Elliott!

     

    1
    Comment actions Permalink
  • Avatar
    Joshua Collins

    This is awesome! Very useful. Can't wait to start seeing this implemented in users' instances!

    1
    Comment actions Permalink
  • Avatar
    Megan Moss (Edited )

    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!

    1
    Comment actions Permalink
  • Avatar
    Elliott Herz

    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

    1
    Comment actions Permalink
  • Avatar
    Elliott Herz

    V2.7.1 just dropped!

    Fixed the issue where the Total line was appearing within the downloaded PDF even when 'custom.barcolumnchart.totalAsLine' was set to false. Thank you Tim Friesen for the easy fix!

    Hope you enjoy!  =D

    1
    Comment actions Permalink
  • Avatar
    Brian Wilson

    Hey Elliott -- Drag and Drop animation is great. Nice job.

    1
    Comment actions Permalink
  • 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

    1
    Comment actions Permalink
  • Avatar
    Christian Lira

    Nice innovative work Elliott Herz and thank you for sharing.

    1
    Comment actions Permalink
  • 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

    1
    Comment actions Permalink
  • 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
    1
    Comment actions Permalink
  • 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

    1
    Comment actions Permalink
  • 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

    1
    Comment actions Permalink
  • 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 

    1
    Comment actions Permalink
  • Avatar
    Tim Friesen

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

    1
    Comment actions Permalink
  • 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

    1
    Comment actions Permalink
  • 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.

    1
    Comment actions Permalink
  • Avatar
    Aaron Warnke (Edited )

    Great Job on this Elliott!

    Thank you!

    1
    Comment actions Permalink
  • Avatar
    Ravid Paldi

    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

    0
    Comment actions Permalink
  • Avatar
    Elliott Herz (Edited )

    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

    0
    Comment actions Permalink
  • Avatar
    Brian Wilson

    Thanks Elliott -- so excited to try this one out. A highly-requested functionality.

    0
    Comment actions Permalink
  • Avatar
    Artem Yevtushenko (Edited )

    Nice!

    0
    Comment actions Permalink
  • Avatar
    Carl Larochelle (Edited )

    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.

    0
    Comment actions Permalink
  • Avatar
    Elliott Herz

    Hey Carl,

    Are you using Edge as your browser? V2.0.0 is extremely new, so I haven't had the time yet to debug across all browsers for the custom sort. Have you tried chrome/firefox?


    Best,

    Elliott

    0
    Comment actions Permalink
  • Avatar
    Carl Larochelle

    Was testing in IE11 (don't judge me, default browser at work :P)

    The custom reordering works well in chrome, but "none" still yields the same result.

     

    0
    Comment actions Permalink
  • Avatar
    Elliott Herz

    Hey Carl,

     

    There currently is a minor bug in the product that can be causing your issue. Can you add a screenshot of the behavior you are experiencing? Also have you tried going to the dashboard and doing a page refresh (same results?).

     

    Thanks for the feedback!

    0
    Comment actions Permalink
  • Avatar
    Carl Larochelle

    The issue in IE or the one with "none"?

    0
    Comment actions Permalink
  • Avatar
    Elliott Herz

    The one with the None. I was already aware of the IE11 + Edge issues.

    Thanks!

    0
    Comment actions Permalink
  • Avatar
    Carl Larochelle

    Reverse gives this :

    None gives this :

    I would expect none to give this (which is what I get with your plugin disabled) :

    And yes I tried refreshes, but same result.

     

    0
    Comment actions Permalink

Please sign in to leave a comment.