The Measure Changer Widget

Comments

66 comments

  • Official comment
    Avatar
    Gideon Jeffrey

    I have a workaround to help people use this plugin in newer Sisense versions - the following works for our team on 8.2, at least!  

    (1) Take Weinan Sun's suggestion in an earlier comment and change the text

    "pluginInfraVersion": 2 

    to

    "version": 2

    in the config JSON file for the widget.

    For us, (1) was enough to get *old* Dimension Changers to work; (2)-(5) are for creating new Dimension Changers.

    (2) When creating a new Dimension Changer, select / edit the dimensions you want to switch between as usual.

    (3) Even though you can't select "Widgets to Add" in the user interface, you can do the same thing with a widget script.  Open the Dimension Changer's widget script and enter the code below:

    widget.on('ready', function(w, args) {

    //define widgetsToAdd as an array ( in [] ) containing one object (the part in {})
    //for each widget
    you want to be affected by the dimension changer; objects
    //should be comma-
    separated for when you want to affect multiple widgets.

    var widgetsToAdd = [
    {
    'id': 'oidexample', //change to OID of widget to be affected here, e.g '5ehz679st8911a2920430783'
    'panelToChange': 'panelName', //change to appropriate panel name, like 'X-Axis' or 'Values'
    'index': 0
    }
    ];

    args.widget.style.selectedWidgets = widgetsToAdd;

    });

    (4) Save the widget's script and reload the dashboard.

    (5) Test the dimension changer; it should work as expected.

    I hope this helps, at least until the plugin is updated for Sisense 8!

    Comment actions Permalink
  • Avatar
    Tripti Jaiswal

    Hi,

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

    Regards

    Tripti Jaiswal 

    GE

     

     

     

    3
    Comment actions Permalink
  • Avatar
    Weinan Sun

    To get it working in ver 8 and higher. Open the Json file in the widget and made the following changes:

     

     

    "pluginInfraVersion": "2",

    To 

    Version": "2"

    3
    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!  
     

    2
    Comment actions Permalink
  • Avatar
    Anu Marichamy

    Hi, updated the latest version of Sisense 8.1.1, After installing the plugin i couldn't see the dimension changer in the widget list. so i changed the"version 2" in json file as you mentioned above,still its not showing. can you please help me out?

    2
    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?

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

    1
    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
    Ian Emmons

    Wow, great! Should've tried first. You guys ought to add that as a supported type in this document.

    1
    Comment actions Permalink
  • Avatar
    Antonio Tomaro

    Hi everybody,

    I cannot make it work, probably I've done something wrong or I skip a step.
    I do not understand how I create a "connection" between the changer widget and the column chart. 
    I mean, I create a column chart with some values like count(orders) and count(customers), then I want to display them throught the changer, so I create a new widget that is a dimension changer and I put the same values in it. 
    Now how can I connect the two widgets? Am I doing something wrong?

    Sorry if it is a commonplace question.

    Best regards,
    Antonio

     

     

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

     

    1
    Comment actions Permalink
  • Avatar
    Marina Doria

    Hi, we downloaded the plugin but the option of  'Dimension Changer Widget' is not appearing in the list. Is this plugin available in Version: 8.1.1.1101 ? Thank you!

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

Please sign in to leave a comment.