The Measure Changer Widget

Comments

47 comments

  • Official comment
    Avatar
    Camille Desrochers

    The Measure/Dimension Changer plug in can also be configured to change dimensions (categories, break by) on a widget.

    To configure the Measure/Dimension Changer after downloading the plug in to the plugins folder:

    Step 1: Create a Dimension Changer Widget.

    Step 2: Add the Categories/Break By Fields that you want to toggle in the affected charts on the Rows panel. Select the widgets affected by the dimension changes under the Design tab and define Panel to Change: Categories or the relevant panel for your chart type.

     

     

    Step 3: The Measure/Dimension changer widget can now change the dimensions of the charts associated with the plug in widget:

     

    Comment actions Permalink
  • Avatar
    Michael Becker

    Hi Inbal,

    a very nice plugin. I've question regarding code modification, on the attached screenshot you can see that the whole widget is offset to the left and this does not look to nice. I had the same problem with Tabber but there you can change that offset. Would it be possible here as well?

    Regards,

    Michał




    1.png
    0
    Comment actions Permalink
  • Avatar
    Inbal

    Hi Michal,

    Thank you for this very helpful comment.

    I have fixed the code and now the Tabber Widget is in place.

    Just download and change the current plugin file with the new one.

    Best,

    Inbal

    0
    Comment actions Permalink
  • Avatar
    Konstantinos

    Hi Inbal,

    great plugin. Thanks a lot!!! How we can modify the script code in order :

    1. Affect more than one widgets.

    2. affect more than one value in the same widget?

    Thanks

    0
    Comment actions Permalink
  • Avatar
    Inbal

    Hi Konstantinos,

    Thank you for your comment.

    Regarding your questions:
    1.The Dimension Changer Widget Plugin can be used in Column Chart, Bar Chart and Line Chart. And you can only choose one. We have a Tabber Plugin that can be used on Different Widgets but you cannot change the value (It switches between existing widgets).

    2. In the current context you cannot use the Measure Changer to affect more than one value

    Beat Regards,

    Inbal

    0
    Comment actions Permalink
  • Avatar
    stephen kearing

    Step 1:

    Download and extract the enclosed folder into the plugins folder:

     

    I do not see the enclosed zip folder.  I can only see: 

    0
    Comment actions Permalink
  • Avatar
    Michael Becker

    Hi Stephen,

    simply extract rar file contents to your plugin folder in SiSense instalaltion folder.

    0
    Comment actions Permalink
  • Avatar
    Michael Becker

    Hi,

    any chances to update it to version 6? Thanks!

    0
    Comment actions Permalink
  • Avatar
    shani adani

    This works on v6. 

    Please make sure that other plugins do not interrupt the measure changer plugin

    0
    Comment actions Permalink
  • Avatar
    Michael Becker

    Hi Shani,

    you're right, my installation was corrupt and reinstalltion helped. Thanks!

    0
    Comment actions Permalink
  • Avatar
    Dan Chalmers

    Hi Inbal, excellent plugin, but could you please clarify Konstantinos' question on affecting more than one widget at a time?

    ie, not the type of widgets, rather how do you add multiple Widget IDs to the script? (assuming the same values are accessible on each of the widgets).

    I would like user to select "Gross Income" or "Net Income" and that switch the values on the 3 or 4 widgets immediately below to show dimension. Currently, I think I would require 3 separate switchers.

    0
    Comment actions Permalink
  • Avatar
    Dan Chalmers

    All, FYI you can get the changer to affect multiple widgets by adding their IDs into the string.

    However, Inbal - could you please advise how I get it to equally update/switch a single dimensioned Indicator? Same value, same name? Doesn't seem to work.

    ie

    e.widgetIds = [

         {id:'55a7b4c6b6e6a3b826000017', panelToChange:'values', index:0} ,

         {id:'6667b4c6b6e6a3b826000017', panelToChange:'values', index:0} 
        ];

    0
    Comment actions Permalink
  • Avatar
    Inbal

    Hi Dan,

    Thank you for your very helpful comment.

    Regarding your question: The Dimension Changer Widget Plugin can be used in Column Chart, Bar Chart, Line Chart and Pivot. It does not work with indicators.

    Best,

    Inbal

    0
    Comment actions Permalink
  • Avatar
    Michael Becker

    Hi,

    when Measure Changer is present on the dashbaord and you create an indicator with main and secondary values, and then when you apply filters on those values and svae widget, filters from main value will be removed. Any suggestions how to work this around?

    Regards,

    Michał

    0
    Comment actions Permalink
  • Avatar
    Ramon Lopez

    Hi!

    To leverage this plugin and change the breakby instead of the value use the following script.

    * panel to change is case sensitive

    Enjoy!

    Ramon J Lopez

    widget.on('render',function(w,e){
    e.prefixText = 'Break By - ';
    e.widgetIds = [
    {
    id:'580139775fe8975c36000017',
    panelToChange:'break by',
    index:0
    }
    ];  });

    0
    Comment actions Permalink
  • Avatar
    Shani Levin

    Hi!

    This is a very useful plugin!

    I've come across a problem - It seems that you can't use different number displays between the dimensions: i.e. - I can't display one measure as a number and one as percentage.

    Could this be fixed?

    Thanks!  
     

    1
    Comment actions Permalink
  • Avatar
    Tripti Jaiswal

    Hi,

    Can we have sorting (Asc/Desc) option for values in measures.

    Regards

    Tripti Jaiswal 

    GE

     

     

     

    2
    Comment actions Permalink
  • Avatar
    Omer (Edited )

    Hi all,

    @Shani - Just right click on the value of one of the columns and choose "show on right axis".

    @Tripti - In the value box, press on the a->z icon and choose the sort type you want.

     

    Regards,

    Omer

    0
    Comment actions Permalink
  • Avatar
    David Wit

    Is there a way to make the widget ID dynamic instead of hard coded into the script?  This would be helpful in moving dashboards from one environment to another.

    Thank you. 

    0
    Comment actions Permalink
  • Avatar
    Omer

    Hi David,

    Yes, it is possible. Just change the following code in the script:

     

    e.widgetIds = [
    
         {id:'55a7b4c6b6e6a3b826000017', panelToChange:'values', index:0} // for pivot insert 'rows', for charts insert 'values' 
    
        ];

    To this:

    e.widgetIds = [
    
         {id: w.oid, panelToChange:'values', index:0} // for pivot insert 'rows', for charts insert 'values' 
    
        ];

     

    Regards,

    Omer

    1
    Comment actions Permalink
  • Avatar
    Evan York

    Is there any particular reason why this can't work for line charts when using paneltochange equal to 'rows' instead of 'values'?  The comment in the script implies that 'rows' vs 'values' is intended for specific widget types, but I'd love to be able to change the dimension (i.e. 'row') for my line chart.  My use case is a simple end-user click to switch from date to week to month time granularity in the chart.  Simply setting paneltochange as 'rows' didn't work.  Is there any way to support changing dimensions (not meaures nor break-bys) for line charts?

    0
    Comment actions Permalink
  • Avatar
    Evan York

    Well, fiddling around I ended up solving my issue.  For those curious, 'rows' is the name reserved for pivot dimensions, whereas 'x-axis' is for line charts and 'categories' is for column/bar chart dimensions.  Like this:

     e.widgetIds = [
    { id:'58cbfd4aeaf4ef00000000ad', panelToChange:'categories', index:0
    } ];

    So, it seems obvious now but I take it that the panelToChange is hard-coded to the element label within the widget's configuration.  Perhaps the instructions could be clearer about this?

     

    1
    Comment actions Permalink
  • Avatar
    Santhosh Prabhakaran

    Hi Inbal,

    I want to dynamically change the title of the widget this impacts.  Is there a code that could help me achieve this?

     

    Regards,
    Santhosh

    0
    Comment actions Permalink
  • Avatar
    Divya Krishnan

    While using this plugin, when I download the dashboard as pdf the order of the widgets is all jumbled up. Can you fix this issue?

    0
    Comment actions Permalink
  • Avatar
    Carly Smallwood

    Hi Inbal,

    Will this plugin be updated for 6.7?

    Thanks!

    0
    Comment actions Permalink
  • Avatar
    Rolf Brandes

    Hi Inbal,

    Nice plugin, thank you. I'm trying to use it with a Pivot table and I would like it to affect the second row (dimension) in the pivot table. I can't seem to get this to work. I would like the second row of the pivot table to change between two different dimensions. Is there a way to accomplish this? Thank you.

     

    Rolf

    0
    Comment actions Permalink
  • Avatar
    Denis Pesa

    Hi guys,

    This is a great plugin!

    One thing bothers me: everytime the screen size changes (e.g., if I unhide the filters bar, or If I change my browser to full screen mode), the target widget reloads and changes to the first dimension/measure of the list. This obviously consumes server resources unnecessarily.

    Do you know how to change this behaviour?

    Thanks!

    1
    Comment actions Permalink
  • Avatar
    Oxana Noa Umansky (Edited )

    Hi all,

    Please note that we've made a few fixes to the plugin. You can go ahead and download the latest version. Here is what was fixed: 

    1. Fixed widget not working in V6.7 and V7 in some scenarios 
    2. Fixed In export to PDF layout of widgets distorted 
    3. Added robust configuration via design pane

    You can also find those and further update details in the release notes at the bottom of this post. 

    Let us know what you think. 

    Thanks,

    Oxana

    0
    Comment actions Permalink
  • Avatar
    Avi Tavdi

    Hi Rolf,

    Your request should be possible using the new version via the design panel config. please try it and let us know.

    0
    Comment actions Permalink
  • Avatar
    Amministratore BI

    Hi everybody,

    I'm trying to use this widget but it doesn't seem to work.

    I can see it in the list of possible widgets: I choose it, and then add to the values just the columns that I'm interested in.

    Then I go into the edit script  and I paste in the code (just for this picture I changed the widget's code, but the code is correct

    And then, after saving the script and applying the modifications... nothing works.

    As you can see nothing shows up.

    The code refers to this widget:

    I'm using Sisense 6.7, and when I try the example dashboard, it works fine, so it shouldn't be a problem of corrupt plugin or something similar...

    Any hints on what could be wrong?

    Thanks a lot

    Giovanni

    0
    Comment actions Permalink

Please sign in to leave a comment.