The Measure Changer Widget

Follow
Avatar
Inbal

Download: Measure Changer

Introduction

Dimension Changer Widget Plugin allows the user to display several values on one widget with easy values switching on the same chart visualization.

The purpose is to display several related values in one chart in a simple and easy way.

The Dimension Changer Widget Plugin can be used in Column Chart, Pie Chart, Bar Chart, Line Chart and Pivot.

Important: The Dimension Changer Widget Plugin does not support ranking filter (Top x).

The Dimension Changer Widget Plugin works on V5.7. and up.

 

Example

In this example we choose 3 values to switch between in the Dimension Changer Widget Plugin.

Above we see the Dimension Changer Widget and below we see the Column chart it affects.

 

The data presentation in the chart below changes according to the value chosen in the Dimension Changer Widget above. You can see the chosen value marked in green.

In this example we see that clicking on a value changes the data visualization in the graph - from Total revenues to Total Quantity.



Steps

In order to add the Dimension Changer Widget Plugin to affect a chart, please follow the listed steps below:

Step 1:

Download and extract the enclosed folder into the plugins folder:

C:\Program Files\Sisense\PrismWeb\plugins\DimensionChanger, if the "plugins" folder is not there, please create it. If you are using version 7.2 and higher unzip the contents into your C:\Program Files\Sisense\app\plugins\ folder. 

Step 2:

Create a Column Chart/ Bar Chart/ Line Chart/ Pivot.

The Dimension Changer Widget Plugin supports more than one chart value (but affects only one).

Step 3:

Create a Dimension Changer

 

For Charts:

Put the values you wish to display and change between them under value.

The first value will appear first in the chart. Leave Rows empty.

 

For Pivots:

Put the rows you wish to display and change between them under rows.

The first row will appear first in the chart. Leave Values empty.

 

Save the widget.

Step 4:

Refresh the Widget and click apply

The chart should appear with the Plot Line chosen and configuration.

Attached is an example for a dashboard with Dimension Changer Widget Plugin. (connects to Sample Ecommerce data).

DimentionChangerPlugin.dash

Release Notes:

January 09, 2018 - the plugin was updated with the following: 

  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

June 23, 2020 - the plugin was updated with the following: 

  1. Fixed plugin.json manifest to support Sisense v8.2
  2. Updated readme with script samples
6

Comments

67 comments

Sort by Date Votes
  • Avatar
    Evan York

    Any ideas on how to make this work for the 'break by / color' of a Scatter Chart?  It appears that the element must be something different than the label, because attempting to use this as the paneltochange option fails with a browser error:

      Uncaught TypeError: Cannot read property 'items' of undefined

    It works perfectly for the 'point' element, but not 'break by / color'. Thanks!

    0
    Comment actions Permalink
  • Avatar
    Gopinath Venkataramanan

    I am trying both with pivot table and column chart, doesnt seem to work, we are in v6.7

    Here is my simple dashboard

    0
    Comment actions Permalink
  • Avatar
    Ian Emmons

    Very cool! This could be really useful for pie charts as well, if that's a possibility.

    0
    Comment actions Permalink
  • Avatar
    Evan York

    Ian, it is!  For pie charts just change the "panel to change" value in the plug-in widget to "categories" or "values" depending on whether you're changing dimensions or metrics.

    0
    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
    Charles Bonsall

    I see earlier in this thread that to sort with this plugin you press the usual A->Z.  However, I do not see an A->Z in the changer widget and on the chart the sort gets overwritten when I change dimensions. 

    0
    Comment actions Permalink
  • Avatar
    Paul Lam

    I installed the plugin, but I’m not able to get the Dimension Changer widget to work. I am currently on version 7.2 of Sisense. I am using the below script for the dimension changer widget (screenshot #1).

    In my case when I switch to a different value from the dimension changer widget it creates a duplicate of the value I just selected (screenshots #2) and nothing happens with the Column Chart.

    Am I missing something to get the dimension changer to work properly?

    Screenshot #1

    Screenshots #2

    0
    Comment actions Permalink
  • Avatar
    Huang Xiaolong

    What methods can affect multiple fields?

    0
    Comment actions Permalink
  • Avatar
    Avi Tavdi

    Huang Xiaolong,

    What do you mean by methods? can you please elaborate?

    0
    Comment actions Permalink
  • Avatar
    Huang Xiaolong

    Avi Tavdi

    in Pivot,I have two columns that need to change,Do I need to create two Dimension Changer Widget?  The values of these two columns are related

    0
    Comment actions Permalink
  • Avatar
    An Y (Edited )

    Thank you for providing this plugin. Just downloaded it and setup three dimensions offering alternating views for four Bar and Column charts on my dashboard. Loving how smoothly it  works, however, running into these issues if someone can help ?
    1. Can’t set Chart Bar Values %, $ and number formatting per dimension.
    2. Chart’s Bar Values SORT DESC doesn’t stay .
    3. Bar Chart’s Auto Zoom settings doesn’t stay.

    PS: Omer’s suggestion from January 04, 2017 05:25 in the thread didn’t work out.


    TIA
    An

    0
    Comment actions Permalink
  • Avatar
    Artem Yevtushenko

    Inbal, just fyi, this is one of my favorite plugins.

    0
    Comment actions Permalink
  • Avatar
    Ravid Paldi

    @An Y, 

     

    Generally, you can achieve what you're looking for by modifying the "changeDimension(element)" function (located in the widget.js file). 

    It requires some playing around to achieve what you want, ping me if you need any help. 

    ravid@paldi.solutions

     

    Cheers,

    Ravid

     

    0
    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
    Michael Becker

    Hi Antonio,

    In Dimension Changer widget in edit mode, on the right hand side in the design pane you have at the top option to add widgets affected by dimension changer. Click add button there and select which widget/-s should be affected. Hope it helps.

    Regards,

    Michał

    0
    Comment actions Permalink
  • Avatar
    Antonio Tomaro (Edited )

    Hi Michael,

    thanks for your reply.
    I added the widgets but they continue to show only their on values, they don't become one single widget that can be navigated through Dimension Changer Widget.
    I also looked at the example dashboard but I am still confused about how this works, maybe I don't have to create the values in the column charts?

    Best regards,

    Antonio

    0
    Comment actions Permalink
  • Avatar
    Client Reporting

    Hi,

    Is it possible to choose which formula to use in "Values" section for a Pivot widget based on which "Rows" value we are selecting from the Dimension Changer? We are switching between Year, Quarter and Month and need to use GrowthPastYear, GrowthPastQuarter and GrowthPastMonth function depending on which value we are choosing. Is anyone aware if we can achieve it with this plugin.

    Thanks

    0
    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
    Weinan Sun

    Hi,

    Have anyone tried using this plugin in Sisense 8.1? there seems to be some problem with it that I lose the ability to choose the widget to change.

    0
    Comment actions Permalink
  • Avatar
    Chad Solomon

    I installed this on 8.1.1. I cannot find the Dimension Changer in my list of widgets. Is it supported in this version?

    0
    Comment actions Permalink
  • Avatar
    Mati Lukas

    Does this work on ver 8.1 ? 

    0
    Comment actions Permalink
  • Avatar
    Hemant Pathare

    I also do not see the Dimension Changer in the widgets list. We just installed ver 8.1.1 . Will this plugin be supported in this version. Thanks

    0
    Comment actions Permalink
  • Avatar
    Alexandre Biton

    Not working on our end as well. I also created a ticket to let your dev team dig that issue. Thanks for giving us visibility on a potential fix. 

    0
    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
    Chad Solomon

    I can now select Dimension Changer as a widget, however there is no option to select the widget to impact, per Weinan's screenshot above.

    0
    Comment actions Permalink
  • Avatar
    Hemant Pathare

    Yes, I also see the widget now in ver 8.1.1, but the panel does not show the options , see screenshot attached.

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

    Anyone have this working in 8.1.1?  Like some of the other posters I either can't see the widget as an option to create, or after altering the json file i am unable to relate the dimension changer to any of my existing widgets.  

    0
    Comment actions Permalink
  • Avatar
    Gabi Susser

    Hi,

    This looks like a great plugin and i would be very happy to make use of it. I installed it but still cannot see the dimension changer in the widget list. It seems that the version we are using doesn't support the plugin (we are currently on the 8.1.3.10037 version).  Can anything be done to make it work on 8.1 version?

    0
    Comment actions Permalink
  • Avatar
    Gustav Ösgård

    Hi, found this thread after upgrading and realizing plugin broke...

    This one has become so important to our users that we had to revert from the new Sisense version, back to the old. 

    Any official update on this?

    0
    Comment actions Permalink

Please sign in to leave a comment.

Didn't find what you were looking for?

New post