Color Heatmap

Comments

28 comments

  • Avatar
    Ravi Verma

    Hi Ronen,

    First of all thanks for bringing this chart type. This is the chart type we were looking for a while.

    I downloaded this plugin to my system, but when I am trying to create a widget by using this chart type it is showing some error stating "Error Querying Elastic Cube". Can you please help how can I get rid of this error.

    I am attaching the screenshot.

    Best regards,

    Ravi

    0
    Comment actions Permalink
  • Avatar
    Ronen Avidor

    Hi Ravi,

    Thanks for the feedback, much appreciated!

    You actually need to assign values for both X-Axis, Y-Axis and Value fields for the widget to work.

    Ronen

    0
    Comment actions Permalink
  • Avatar
    Ian Emmons

    This is awesome and definitely something I've been wanting.

    One comment though: exporting to pdf is non-functional for this add-on. Can that be added? Export to pdf is pretty important to how our clients use Sisense reports.

    0
    Comment actions Permalink
  • Avatar
    Ravi Verma

    Hi Ronen,

     

    I tired to create the heatmap by putting both x and y axis and also defined the values, but I can neither see anything in heatmap area nor any error message.

    Can you please help?

     

    Best regards,

    Ravi

    0
    Comment actions Permalink
  • Avatar
    Ronen Avidor

    Hi Ravi,

    Would it be possible to send you ecdata file to our support team, and have them forward it to me. Also let me know which fields are you using as parameters.

    Thanks,

    Ronen

    0
    Comment actions Permalink
  • Avatar
    Robert Choquette

    Seeing something odd when using in version 7.1. There are values posted in the cells (which could be good), but they could use some styling to make them more readable (in the .css file in the plugin?).  Also, the axes aren't being sorted correctly.  It's mostly correct, but there are occasional out of place values on the y-axis (see image).

    1
    Comment actions Permalink
  • Avatar
    Ronen Avidor

    Hi Robert,

    Is it possible to send our support the ecdata and dash file so I can take a look.

    Thanks,

    Ronen

    0
    Comment actions Permalink
  • Avatar
    Ronen Avidor

    Hi Robert,

    Updated a new version that hides the data labels, for some reason after 7.1 it is shown by default. If you can send me the ecdata & dash file, I can look at the other issues.

     

    Ronen

    0
    Comment actions Permalink
  • Avatar
    Sisense admin Time to know

    Hello,

    can someone tell me how to enable the lables?

    0
    Comment actions Permalink
  • Avatar
    Ravi Verma

    Hi Ronen,

    Is there a way to configure the conditional colour for heatmap cells? Like 20%< Green, 20%-50% Amber and 50% Red>.

     

    Best regards,

    Ravi

    1
    Comment actions Permalink
  • Avatar
    Upadesh user

    Hi Ronen,

     

    Is there any way we can add a single color to each attribute of Y-axis. For example, if Y-axis has 5 attributes, each attribute has different color. There is an option called range where we can select range of colors rather individual colors.

    Thanks,

    Vineela

    0
    Comment actions Permalink
  • Avatar
    Rourke Rabinowitz

    Hey I fixed the pdf not sowing up.  Fix is pretty simple just add something like thisin widget.js

    0
    Comment actions Permalink
  • Avatar
    Ronen Avidor

    Hi Rourke, appreciate the feedback. We test and incorporate on our next release.

    1
    Comment actions Permalink
  • Avatar
    Rourke Rabinowitz

    Also I added my previous change for pdfs and allowed you to change the color scheme via the sidebar.  Can these be added so I don't have to worry about missing new features.  https://drive.google.com/file/d/1sS4EFfABrSlA7EQ_ndBeXGa01Baxu6ns/view?usp=sharing 

     

    Thanks!

    2
    Comment actions Permalink
  • Avatar
    Eric Pouliot

    Hi,

    This plugin is very interesting. Could you make a few improvements so that we can be in a better position to leverage it?

    • It would be very useful to have the color configuration capabilities on the Value field, similarly to what we have for treemaps and calendar heatmaps. (I see Rourke Rabinowitz on the previous post implemented this in his forked version)
    • It would be essential for dashboard filters to push down to the widget. For some reason this doesn't appear to work, the widget simply ignores the dashboard filters (I'm using 7.1.3 for testing)

    Thanks for the good work!

    1
    Comment actions Permalink
  • Avatar
    Ian Emmons

    It seems like this widget doesn't really handle No Results well. I have it implemented and functioning in a dashboard. It works great until I add a combination of filters such that it yields no results. At that point, I get the yellow square that says "This shouldn't have happened. Please ask your administrator for assistance," rather than the more graceful "No Results" message.

    0
    Comment actions Permalink
  • Avatar
    Ronen Avidor

    Hi Ian, this is now fixed. Please download the latest version. Thanks Ronen

    0
    Comment actions Permalink
  • Avatar
    Ian Emmons

    Hey Ronen, is it possible that your last change caused the export to pdf to start failing again? I'm seeing that behavior again.

    0
    Comment actions Permalink
  • Avatar
    Giridhar Yalamanchili

    We have added the Color Heat Map plugin and created the widget by applying the conditions at widget level. But we want to apply the conditions separately for each row i.e each row may contain different conditions. Please let us know how to apply conditions at the row level.

    0
    Comment actions Permalink
  • Avatar
    Marco Geluk

    Hi Ronen,

    I really like this plug-in. It gives us new insights on our data.

    It's seems like we found a bug in this plug-in, though.

    We use scheduled reports. These scheduled reports all fail when the plug-in is active. When we disable the plug-in these scheduled reports are been send successfully again.

    We're running Version: 7.2.0.12014

    Hope that you can find this bug.

    0
    Comment actions Permalink
  • Avatar
    Eric Pouliot

    Hi,

    We also have a similar impact where we can't export any other dashboard to PDF while this plugin is enabled. Marco, this might be related.

    Ronen, any updates on this? Without the ability to export or schedule any dashboards, this plugin cannot be used at all.

    1
    Comment actions Permalink
  • Avatar
    Jessica Orlando

    Also running into this issue. We cannot export any visual to PDF with this plugin enabled (regardless if the widget is used in the dashboard or not).

    0
    Comment actions Permalink
  • Avatar
    Ian Emmons

    One other point with this widget. If you set the coloring to be conditional, rather than the range default, the legend doesn't really update accordingly.

    Here I have everything lower than 0.9 pink and everything above 0.9 green, but the legend still shows a gradient. If this couldn't be fixed, it would still be a good workaround to enable hiding the legend.

    0
    Comment actions Permalink
  • Avatar
    Robert Vaughan

    Hi Ronan,  

    We love the plugin, but we seem to be having some compatibility issues with IE.  when the plugin is enabled, all the hidden _drill dashboards become visible, and the jump-to plugin stops working.  we are also seeing some indicator widgets showing wrong numbers.

    This does not happen on Chrome.

     

    Any help would be appreciated.

    Rob.

    0
    Comment actions Permalink
  • Avatar
    Duessa Holscher

    Hi! Just wondering if anyone has found a solution to the issue of scheduled reports not working when this plugin is enabled, or if there are any alternative widgets that can accomplish a similar type of visualization? 

    0
    Comment actions Permalink
  • Avatar
    Sisense Karhoo

    Hello, I want to know if we can change the order of the x and y-axis, currently I am using dates and showing editing the formatt to show as Mon, Tue, Wed, Thu, Fri, Sat, Sun, however, the order is incorrect, how can I reorder this? The order seems to change as I change my date range. Any help on this or if there could be a a update to the plugin would be really great to have. 

    Thanks! 

     

    0
    Comment actions Permalink
  • Avatar
    Ian Emmons

    We're also seeing that having this plugin enabled causes all plugins to fail in Internet Explorer. Like Robert mentioned, it's not a problem on Chrome.

    0
    Comment actions Permalink
  • Avatar
    Ian Emmons

    I ended up downgrading to a previous version of the plugin in order to sidestep the IE problems. When I did, I found that pdf export works, but throws a highcharts error. I elected to just catch this error, though I know that's not great practice.

    render: function (widget, event) {
    try {
    console.log('render');
    var element = $(event.element),
    svgHeight = $(element).height(),
    svgWidth = $(element).width();


    element.empty();

    var num = Math.floor(Math.random() * 1000000);
    var MyDiv = element[0],
    ObjectID = widget.oid,
    ChartDivName = "colorheatmap-" + ObjectID + "-" + num;

    MyDiv.setAttribute("id", ChartDivName);
    MyDiv.setAttribute("style", "width: 99%; height: 99%; margin: 0 auto");

    //element.append('<div style="width=97% height=97% margin: 0 auto" id="' + ChartDivName + '"></div>');
    DisplayColorHeatmap
    (
    widget,
    ChartDivName,
    svgWidth,
    svgHeight
    );
    } catch(e) {
    }
    },

    0
    Comment actions Permalink

Please sign in to leave a comment.