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

Comments

103 comments

  • 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
    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
    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
  • Avatar
    Elvin Alvarillo

    Hi Elliot,

    I am on version 7.1.3, and it doesn't show in the Design Panel.  As instructed in the documentation, I renamed the folder and added it to the plugin folder, created a Column/Bar chart, hit apply and refreshed the page several times but still don't see anything.  Does this work for this version?

    Thanks!

    0
    Comment actions Permalink
  • Avatar
    Elliott Herz

    Hey Elvin,

    Just tested on 7.1.3.11003. Works as expected. Can you try removing the plugin completely, and re-adding it. In addition, please try clearing your browser cache, I've noticed that it can keep previous parts of the plugin. Also, the plugin now works instantly when you create a widget, so there shouldn't be any need to refresh the page.

    Let me know if you still can't get it to work.

    Best,

    Elliott

    0
    Comment actions Permalink
  • Avatar
    Elliott Herz

    V2.5.0 just dropped!

    Remade the custom sort popup to be off to the side, also when you move items around in the list, you can see the effects immediately on the chart. Also some more code clean-up.

    Hope you enjoy!  =D

    0
    Comment actions Permalink
  • Avatar
    Elliott Herz

    V2.5.1 just dropped!

    In the custom sort popup, when you drag an item in the list, it refreshes the chart at the same time, so you have a very responsive sort. I also added some additional error handling.

    Hope you enjoy!  =D

    0
    Comment actions Permalink
  • Avatar
    Elliott Herz

    V2.5.2 just dropped!

    Just a bit of code cleanup.

    Hope you enjoy!  =D

    0
    Comment actions Permalink
  • Avatar
    Elliott Herz

    V2.5.3 just dropped!

    Added a toggle in the custom sort so that the chart doesn't update on every change. Charts with lots of categories or break bys can take awhile to redraw, and therefore toggling this feature on and off is necessary.

    Hope you enjoy!  =D

    0
    Comment actions Permalink
  • Avatar
    Brian Wilson

    Hey Elliott,

    The sidebar is great. Really nice solution.

    Some follow ups -- Once in a while the sidebar and the preview can be misaligned after shuffling a few items around. See below. Not a huge deal, but figured you'd want to know.

    Second, the animation when moving items highlights a target box in green -- to me this isn't super precise. Innately, I feel like that highlighting means "swap" or "replace". Could the animation highlight the border between the other listings, like when you're moving a column in Excel?

    Third, on the live sorting, I've got three options -- Save, Cancel and Revert. Save obviously saves. Revert seems to completely remove all sorting and return the list to alphabetical. What does Cancel do? I would assume that it should cancel anything that I've done in the current sidebar session and return the sort to what existed prior to opening the custom sort configuration, but it seems like it just closes the window and leaves the sort with however it has been updated, which is the exact behavior of Save.

     

    Thanks for your hard work on this Elliott!

    0
    Comment actions Permalink
  • Avatar
    Elliott Herz

    Hey Brian,

    THANK YOU FOR TELLING ME!! I didn't realize that there are a few minor bugs with the most recent commits. Let me investigate further, and I'll probably release a new version in the next few days. Also I'll consider point 2 further.

    Happy Holidays!

    Best,

    Elliott

    0
    Comment actions Permalink
  • Avatar
    Elliott Herz

    V2.6.0 just dropped!

    Made the code even cleaner! Fixed the bug where in the custom sort popup sometimes the list it out of sync with the chart. Also fixed the cancel button. In addition I gave the ability to name the Total series whatever you want in a widget script. Still working on the styling of the custom sort page.

    Happy Holidays  =D

    0
    Comment actions Permalink
  • Avatar
    Brian Wilson

    Thanks Elliott -- the sort-sync issue and the cancel button both seem fixed on my side.

    0
    Comment actions Permalink
  • Avatar
    Elliott Herz

    Hey Brian,

    Thank you for testing again! Everything should be working as expected. The live sort is still a bit interesting, and I do want to fix it up more, as well as the look of the drag and drop, making it more intuitive. Let me know if you have any other recommendations/suggestions.

    Best,

    Elliott

    0
    Comment actions Permalink
  • Avatar
    Elliott Herz

    V2.6.1 just dropped!

    Better styling + hover effects on the custom sorting list popup. Still a minor styling issue when you grab a list item towards the top of the cell, and then drag upwards (work in progress).

    Hope you enjoy!  =D

    0
    Comment actions Permalink
  • Avatar
    Elliott Herz

    V2.7.0 just dropped!

    Rebuilt the drag and drop functionality of the custom sort popup. This also includes an animation when the user drops the list item.

    Hope you enjoy, and Happy New Years!  =D

    0
    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

Please sign in to leave a comment.