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

Comments

111 comments

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

    0
    Comment actions Permalink
  • Avatar
    Carl Larochelle

    I get the same result in Chrome.

    0
    Comment actions Permalink
  • Avatar
    Elliott Herz

    Hey Carl,

    Do you have a widget script on that widget?

     

    Thanks

    0
    Comment actions Permalink
  • Avatar
    Carl Larochelle

    No script.

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

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

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

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

    0
    Comment actions Permalink
  • Avatar
    Admin

    Hey Elliott,

    would it be possible to modify the pop up window so it matches other popups (sharing, etc. ) I mean buttons, header..

    Thanks :) 

    Pawel

    0
    Comment actions Permalink
  • Avatar
    Elliott Herz

    Hi,

    Can you provide a screenshot of another popup as an example? Also there isn't any functionality that I know of in Sisense that has the drag and drop functionality in the popup, so I just created my own styling on those.

    Best,

    Elliott

    0
    Comment actions Permalink
  • Avatar
    Tamir Basin

    Hi Elliot,

    This is what I had in mind:

    Thanks,

    Tamir

    0
    Comment actions Permalink
  • Avatar
    Admin

    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

    0
    Comment actions Permalink
  • Avatar
    Jessica Orlando

    Does this plugin work for 7.1? I renamed the folder and added it to the plugin folder but the functionality does not appear for either a Column or Bar chart. I've hit Apply and Refreshed the page but still don't see anything.

     

    Thanks!

    0
    Comment actions Permalink
  • Avatar
    Elliott Herz

    Thank you everyone for the feedback, I'll take a look through to see what makes sense to change.

     

    Hey Jessica, 

    Yes this works in 7.1.  Do you see the plugin on the plugin page under admin? Make sure the plugin is in that list and on. Also what browser are you on?

    Best,

    Elliott

    0
    Comment actions Permalink
  • Avatar
    Elliott Herz

    V2.1.0 just dropped!

    Rebuilt the custom sorting popup to have a cleaner and more consistent styling. Also added 3 buttons in the popup: Save Config, Cancel, Reset Config.

    Enjoy =D

    0
    Comment actions Permalink
  • Avatar
    Brian Wilson

    Hi Elliott,

     

    Running into a bug on this one -- on 7.1.3, opening the widget sidebar pops up a blank modal. See attached

     

    0
    Comment actions Permalink
  • Avatar
    Brian Wilson

    ** v2.0.2 works fine

    0
    Comment actions Permalink
  • Avatar
    Elliott Herz

    Hey Brian,

     

    Have you tried V2.1.0? If you are on Edge, you might need to clear your browser Cache to get the correct updates.

     

    Best,

    Elliott

    0
    Comment actions Permalink
  • Avatar
    Brian Wilson

    Hi Elliott,

    This is on 2.1.0 -- Chrome. I rolled back to 2.0.2 and it works fine again.

    0
    Comment actions Permalink
  • Avatar
    Elliott Herz

    Hey Brian,

    It looks like a cached page, some of that text in your picture no longer exists in the plugin, so it must be coming from a cached page on your local browser. I would still recommend V2.1.0 as it is a bit of a cleaner look, but up to you!

    Best,

    Elliott

    0
    Comment actions Permalink
  • Avatar
    Brian Wilson

    Hey Elliott -- Okay, it worked in incognito and then clearing the cache fixed it. Thanks.

    0
    Comment actions Permalink
  • Avatar
    Megan Moss

    Elliott, 

    Thank you! You rock! Just what I was looking for :) 

    0
    Comment actions Permalink
  • Avatar
    Elliott Herz

    V2.2.1 just dropped!

    The widget will no longer automatically save configurations, instead the user has to click the apply button on the widget. So if the user refreshes the page or hits the cancel button, none of the configuration changes will apply. This also goes for that popup reset button. If you hit reset, the changes won't officially be applied until you hit apply or click away from the popup (it used to apply immediately even if you then hit the cancel button). Also that button is no longer red during hover effect. I also did some general code cleanup.

    Hope you all enjoy!  =D

    0
    Comment actions Permalink
  • Avatar
    Elliott Herz

    V2.3.0 just dropped!

    1) Converted the code to ES6 syntax.
    2) Added a linter to the project.
    3) Cleaned up all of the code.
    4) Added some comments.
    5) Fixed the Custom Break By Reset Button, it always sorts correctly regardless if a date field.
    6) Fixed the Custom Break By Reverse option, wasn't working all the time with dates.
    7) Added a new option for totalYAxisPercentSpacing (can be added to a script).

    Hope you all enjoy!  =D
    0
    Comment actions Permalink
  • Avatar
    Elliott Herz

    V2.4.0 just dropped!

    Plugin now takes effect immediately when switching chart types (including the initial creation of the widget). Sometimes the Reverse Option doesn't take effect for both Categories + BreakBys. Page refresh solves the issue, but this needs further investigation.

    Hope you all enjoy!  =D

    0
    Comment actions Permalink
  • Avatar
    Elliott Herz

    V2.4.1 just dropped!

    Fixed the Reverse Sort for both Breakby + Categories. The issue was when you create a chart for the first time and try to apply the custom sorting immediately, the customization was taking effect twice, so a reverse of a reverse is the original order.

    Hope you all enjoy!  =D

    0
    Comment actions Permalink
  • Avatar
    Brian Wilson

    Hi Elliott,

    Continue to really like the plugin and find new uses for it.

    Could the position/size/transparency of the custom sorting popup be altered? When I'm trying to sort items on the fly, it obstructs the graph, so I kind of have to guess what items to move and then save and check and then go back and fix, then save, etc. It's not a big deal when there are 5 bars, but once it's a dozen or more, it can be a lot of back and forth.

    Maybe a thinner box off to one side?

    0
    Comment actions Permalink
  • Avatar
    Elliott Herz

    Hey Brian, That is a great suggestion! I'll think about it some more and see if I can make that part more intuitive (so you can see your changes in action).

     

    V2.4.2 just dropped!

    Added an extra option for a widget script to add extra spacing (padding) for the total line/dots. Also a little bit of code cleanup.

    Hope you enjoy!  =D

    0
    Comment actions Permalink

Please sign in to leave a comment.