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

Comments

74 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

  • 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 :)

  • Avatar
    Korey Martin

    This is awesome - thank you, Elliott!

     

  • Avatar
    Joshua Collins

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

  • 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!

  • 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

  • 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

  • Avatar
    Brian Wilson

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

  • 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
    Christian Lira

    Nice innovative work Elliott Herz and thank you for sharing.

  • 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
    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

  • 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

  • Avatar
    Brian Wilson

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

  • Avatar
    Artem Yevtushenko (Edited )

    Nice!

  • 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.

  • 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

  • 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.

     

  • 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!

  • Avatar
    Carl Larochelle

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

  • Avatar
    Elliott Herz

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

    Thanks!

  • 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.

     

  • Avatar
    Elliott Herz

    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

  • Avatar
    Carl Larochelle

    I get the same result in Chrome.

  • Avatar
    Elliott Herz

    Hey Carl,

    Do you have a widget script on that widget?

     

    Thanks

  • Avatar
    Carl Larochelle

    No script.

  • Avatar
    Elliott Herz

    V2.0.1 just dropped!

    Fix for the custom configuration popup in Edge browser. Also better styling + popup auto height updates.

    Enjoy =D

  • Avatar
    Tamir Basin

    Hi Elliot,

    Great plugin!

    • Can we customize the location of the "Total"? it is a bit too close to the top.
    • Can we customize it to show % and values in the breakdown parts? 

    Thanks,

    Tamir

  • Avatar
    Elliott Herz

    V2.0.2 just dropped!

    Fixed Custom Category Sorting on date fields. Fixed the category reset button, to always be sorted correctly. Updated popup styling.

    Enjoy =D

  • Avatar
    Elliott Herz

    Hey Tamir,

    1) How would you like the total to be displayed? I can probably add a configuration to give more space at the top if you think that is needed?

    2) Can you elaborate on this a bit more? Maybe a quick sketch of what you want?

    Thanks,

    Ellliott 

Please sign in to leave a comment.