The Measure Changer Widget

Comments

66 comments

  • 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
    Timothy Roy

    We are having an issue with this plugin (Sisense 8.2) where we cannot generate manual pdf emails

    while the plugin is active. Will there be a new, 8.2 version available soon ?

    0
    Comment actions Permalink
  • Avatar
    Sharon Morad

    Hi,

    Thank you for this plugin - I definitely think it's supposed to be as part of the market place plugins.

    I come across with two critical problems:

    1. I can't use two different number displays using this plugin such as number and percentage.
      I want to switch between "Sales value" and "Share of Sales %".  
    2. The chart can be sort by each of the measures - important functionality when you look at many items.

    Are you aware of that? Can you update if you will change it in the future? 

    Thanks,

    Sharon.

     

    0
    Comment actions Permalink
  • Avatar
    Barry Gaffey (Edited )

    hi Sharon Morad

    I use a custom script in the measure changer to accomplish this. After setting the 'format' like this
    You can use this custom script in the dimension changer, which will then apply the formatting when it applies the measure to the target widget(s).

    widget.on('render', function (w, e) {

    // TODO set target widgets here, replace the id value(s) with the id of the target widget(s).
    e.widgetIds = [
    {
    id: '44ffffffffffffffffffffff',
    panelToChange: 'values',
    index: 0
    },
    {
    id: '44fffffffffffffffffffffe',
    panelToChange: 'values',
    index: 0
    }
    ];

    function dimClicked(ex) {
    let titleToFind = ex.target.innerText;

    let targetDim = getDimByTitle(titleToFind);

    for (var i = e.widgetIds.length - 1; i >= 0; i--) {
    let widgetId = e.widgetIds[i].id;
    let widgetToApplyOn = getWidgetById(widgetId);

    if (widgetToApplyOn) {
    let item = widgetToApplyOn.metadata.panel(e.widgetIds[i].panelToChange.toLowerCase()).items[e.widgetIds[i].index];
    if (item) {
    item.jaql = targetDim.jaql;

    item.format = targetDim.format;

    widgetToApplyOn.changesMade();
    widgetToApplyOn.refresh();
    }
    }
    }
    return (true);
    }

    function getDimByTitle(title) {
    let dimension = w.rawQueryResult.metadata;

    for (let i = dimension.length - 1; i >= 0; i--) {
    if (dimension[i].jaql.title.toUpperCase() === title.toUpperCase())
    return (dimension[i]);
    }
    }


    function getWidgetById(widgetId) {
    var widgets = $$get(widget, 'dashboard.widgets.$$widgets');
    for (var i = widgets.length - 1; i >= 0; i--) {
    if (widgets[i].oid === widgetId)
    return (widgets[i]);
    }
    }

    $(document.body).on('click', 'widget[widgetid= ]', dimClicked);
    });
    0
    Comment actions Permalink
  • Avatar
    John Lusk (Edited )

    We have kind of a new problem with this widget, upgrading from 7.4 to 8.2.3. We've installed version 1.0.1 of this plugin.

    Basically, it's breaking our dashboards in a weird way: users get kicked entirely out of Sisense when they try to pull up a dashboard containing this widget. If we look at the browser dev tools, we see a PUT request issued to /api/dashboards/5f171da4f14bf475fc2ee6c8/widgets/5c192249b315da4e20cc3b3d (modulo exact ids, of course). The response to that request is 403 ("Forbidden", meaning *unauthorized as opposed to unauthenticated*, if I understand things correctly), and then the user is kicked out to our portal.

    If I delete the widget and create it from scratch, I have no trouble, and it seems to be working properly, so that's a possible solution. However, I'd prefer not to have tell our users they need to go into each dashboard (of which we have many), delete the widget, and recreate it.

    So. Has anybody seen this sort of thing? Any ideas on a fix?

    (I tried Weinan's suggestion of changing "pluginInfraVersion" to just "version", but that did not help.)

    0
    Comment actions Permalink
  • Avatar
    Parag Paliwal

    This is a great plugin, is there any way we can convert the tabs to dropdown menus?

    0
    Comment actions Permalink

Please sign in to leave a comment.