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

Comments

111 comments

  • 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

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

    0
    Comment actions Permalink
  • Avatar
    Brian Wilson

    Sure thing!

    I ran across this today:

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

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

    0
    Comment actions Permalink
  • Avatar
    Brian Wilson

    Hey Elliott -- Perfect. Instantly useful.

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

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

    0
    Comment actions Permalink
  • Avatar
    Admin

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

    Thanks,

    Pawel

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

     

     

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

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

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

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

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

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

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

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

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

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

    0
    Comment actions Permalink

Please sign in to leave a comment.