Dynamic Buckets

Comments

13 comments

  • Avatar
    Cassandra

    Great feature, however I can not get the filtering ability to work.  When you click on a bar a page filter should appear to filter for that group.( i.e in your example if you click on the 25k-50k bar a page filter should appear for Revenue between 25k and 50k).  However, what I have happen is a general page filter that does not do anything ( i.e in your example it would be a filter for Include All Clients) . How do I get the filtering to work?

  • Avatar
    Alon Ahronberg

    Hi Cassandra,

    The plugin was updated to allow filtering from a bucket. Please check the revised version:

    • Replace the previous files with the updated ones
    • Follow the above instructions

    Best

  • Avatar
    Matt

    Does the plugin allow for secondary categories on the X-axis (for example, quarters in date)?  I tried adding a second category, but the widget broke and the browser page became unresponsive.

  • Avatar
    Alon Ahronberg

    Hi Matt,

    Plugin supports 1 category.

     

     

  • Avatar
    Cassandra

    HI Alon

    Thanks for the update.  Is it possible to have the filter show the  revenue instead.  For example instead of clicking on a column in the chart selects the specific members that make up the bucket have it show you the range it is in.  So in our example above, clicking on the column for Customers > $40k, it will set a filter on the revnue dimension and set the selection to each revenue amount that falls within this bucket.

     

    Thanks;

    Cassandra

  • Avatar
    Alon Ahronberg

    Hi Cassandra,

     

    The plugin will filter the field you have in the categories. 

    Usually revenue is not a dimension but an aggregated value that calculated across many rows. 

    If in your case a revenue is an attribute of a client, place it as a category.

     

    Hope i understood your question correctly, 

    Alon

  • Avatar
    Cassandra

    Hi Alon 

    What we were hoping for is that when you click on a bucket you would get a range filter based on the revenue.  The issue we are running into is that, lets say you have 1000+ clients with a revenue of $10k - $20k.   When you click on that bucket the filter shows all 1000+ clients individually which takes a long time to load. 

    Cassandra

  • Avatar
    Alon Ahronberg

    Hi Cassandra,

     

    Unfortunately dashboard filters based on measures are not yet available, i think its a great idea, please post it in our Feature Request Forum at: https://support.sisense.com/forums/21642234-Feature-Requests. Our team frequently visits this forum to consider functionality changes and feature requests from our online community.

     

    In addition, I have another idea that you might find useful. In version 5.8 (our latest version) by using a compound filter, you can create separate chart / pivot for you customer's groups.

    - Example attached - 

     

    Alon




    Buckets.dash
  • Avatar
    Scott Vickers

    When exporting a dashboard to pdf that has a widget with this plugin I get an error.  Exporting an individual widget to png works fine.  Any workaround ideas?

    - Error: undefined is not a constructor (evaluating 'Math.log10(unroundedTickSize)') at calculateBucketsAuto (http://localhost:8081/plugins/reporting.js:493:31) at http://localhost:8081/plugins/reporting.js:348:35 at http://localhost:8081/js/common.js?g=goeoAodAAfi:57:1851 at forEach ([native code]) at trigger (http://localhost:8081/js/common.js?g=goeoAodAAfi:57:1831) at v (http://localhost:8081/js/app-reporting.js?g=goeoAodAAfi:123:9866) at http://localhost:8081/js/app-reporting.js?g=goeoAodAAfi:123:11481 at u (http://localhost:8081/js/common.js?g=goeoAodAAfi:32:29623) at http://localhost:8081/js/common.js?g=goeoAodAAfi:32:29795 at $eval (http://localhost:8081/js/common.js?g=goeoAodAAfi:33:5603) at $digest (http://localhost:8081/js/common.js?g=goeoAodAAfi:33:4039) at $apply (http://localhost:8081/js/common.js?g=goeoAodAAfi:33:5890) at a (http://localhost:8081/js/common.js?g=goeoAodAAfi:32:13986) at m (http://localhost:8081/js/common.js?g=goeoAodAAfi:32:15576) at onload (http://localhost:8081/js/common.js?g=goeoAodAAfi:32:16116)

     

  • Avatar
    Tim Coppola

    Filtering still doesn't work.

  • Avatar
    Artem Yevtushenko (Edited )

    Instead of seeing each dynamic bucket's value range, you may want to see the bucket as a percentage.

    Here's a widget script you can use for 10 buckets:

    const percentiles = ['10%', '20%', '30%', '40%', '50%', '60%', '70%', '80%', '90%','100%'];

    widget.on('domready', () => {
    var labels = $('g.highcharts-xaxis-labels text', element);
    labels.each((i, v)=> {
    $(v).text(percentiles[i]);
    })
    });
  • Avatar
    Simon Tuson

    Hi,

    Not sure if it is me but I am seeing a discrepancy between auto bucket generation and manual bucket generation.

    I have 10 buckets between 0 and 100%, 0 to 10, 10 to 20 ...... and so on.

    The discrepancy occurs at the bucket boundaries. On the auto generate the final bucket 90-100 excludes the value 100.

    The manual bucket generation gives me what I need for now.

  • Avatar
    Jordy Finkers

    Hi Simon,

     

    We had a similar kind of issue. After some time we got a test version from support for this plugin with a fix.

    That one seems to work. Support should be able to provide you a version.

Please sign in to leave a comment.