histogram tooltip number format

[dunba...@gmail.com]

Hi, 

I like the Histogram chart but one thing is needling me, which is that I can't seem to have number formatted tooltips. In the classic charts like ColumnChart, it's simply a matter of using the number formatter, for example: 

var formatter = new google.visualization.NumberFormat({pattern:'###.# %'});
formatter.format(data,1);

 

However, when I do this for Histogram, the formatting doesn't appear in the tooltip like it does in other charts. Any clues what I am doing wrong, or is this a bug? 

Thanks, 

Nick  

[Daniel LaLiberte]

Hi Nick,

Sounds like you found a bug.  We should be using the formatted representation of the value in the tooltips, but I see a place in the code where the unformatted value is used, so this might be easy to fix, if I have time to get around to it.

--
You received this message because you are subscribed to the Google Groups "Google Visualization API" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-visualizati...@googlegroups.com.
To post to this group, send email to google-visua...@googlegroups.com.
Visit this group at https://groups.google.com/group/google-visualization-api.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/64e9854f-3c42-426b-90fa-ae9de051ed9f%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

Daniel LaLiberte

dlaliberte@Google.com   5CC, Cambridge MA

[Nick Dunbar]

Hi Daniel, 

Thanks for getting back to me so quickly. Please try and fix this - if you do it will be perfect. 

Well almost, if were it possible to fit Normal or Lognormal curves to the histogram (analogous to trendlines) that would be amazing. 

Nick 

--
You received this message because you are subscribed to a topic in the Google Groups "Google Visualization API" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/google-visualization-api/LQg2V8dnAcU/unsubscribe.
To unsubscribe from this group and all its topics, send an email to google-visualizati...@googlegroups.com.

To post to this group, send email to google-visua...@googlegroups.com.
Visit this group at https://groups.google.com/group/google-visualization-api.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/CAOtcSJN5sFoXmANt1vOQ5YBxTONMBaVWCC0m3DYcVHugvN%3DthQ%40mail.gmail.com.

[Daniel LaLiberte]

I think I have a fix for the lack of formatting now.  Should show up in the next release.

Can't help you with log scale used with histogram, or even combining the histogram with other charts.  The current histogram implementation is not designed with these things in mind, but we are thinking of a new design that would allow much more.  The only workaround for now is to implement your own histogram calculations.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/CAO5F7csP%2B161Eu_U4mZDgt%2BuLg6sPHL2Pn%2BxfZj6%3DC93vDkCHg%40mail.gmail.com.

For more options, visit https://groups.google.com/d/optout.

[Nick Dunbar]

OK, thanks. When are you planning the next release? 

To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/CAOtcSJOURr33vfCCxH4OUm3W-bCfaXOEZmCPNiASVfM3mKnnMA%40mail.gmail.com.

[Daniel LaLiberte]

We'd be done by now, but I'm trying to stabilize a new feature regarding bar widths, which is raising entanglements with other features.   Hopefully done this week, so I should start rolling out the new release next week.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/CAO5F7cvqKEeL%3DMnJQ%3DEbPLGEQT-PwQWm48FcHC2i23UdM%3DKK_Q%40mail.gmail.com.

For more options, visit https://groups.google.com/d/optout.

[Nick Dunbar]

Great. In the gstatic loader, do I need to change from '43' to pick up these changes? 

To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/CAOtcSJOPXM%3DKQzZ2_JuDPAv_3EXZ5VcZ8i1k6vSZN6cxEZX39A%40mail.gmail.com.

[Daniel LaLiberte]

You'll need to be loading '44' at first, which is available now, but not yet updated for this fix.  Then load 'upcoming' when we start the release cycle, if you want the latest.  Then back to '44' if you want to stick with that.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/CAO5F7csiZFju%3D59gO-aU0wJ%2BBh-wXYz%2BshVjRDt3Lwkt%2B5MVVg%40mail.gmail.com.

For more options, visit https://groups.google.com/d/optout.

[Nick Dunbar]

Hi Dan, something weird came up when I swtiched from version '43' to '44'. The histogram algorithm appears to be broken in '44' for multiple series. It works fine in '43' so you might want to check that. Please keep '43' frozen in the meantime. 

Regards, 

Nick 

To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/CAOtcSJO1Fd8jfogmwSksqT8tLqtJayuJGQY6EpLQJ8uZuDPycA%40mail.gmail.com.

[Daniel LaLiberte]

Nick,

Thanks for reporting that.  Indeed, histogram is broken in v44 for multiple series.  I'm glad you caught that.

Version 43 will remain frozen indefinitely as is, barring security concerns.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/CAO5F7cs-6AX4x9_jLZHRyG5zrWrt1MVJqUmGHM%3DK%2Bfo-dHGGdg%40mail.gmail.com.

For more options, visit https://groups.google.com/d/optout.

[Daniel LaLiberte]

I discovered that for histogram, if you have the bar.variableWidth option set, it will mess things up.  Could that be what you are seeing?  If not, could you give me the details of your chart and options, since I am not seeing a problem after all, other than with the bar.variableWidth option.

[Nick Dunbar]

I'm not using that option - here they are below. My data table has about 10 or 11 separate series in it, and about 500-600 points in total. 

var chart = new google.visualization.ChartWrapper({

        chartType: 'Histogram',

        containerId: 'chart_div',

        dataTable: histogramTable,

options: {

            title: 'Title',

            width: 900,

            height: 500,

   focusTarget: 'datum',

   tooltip: {isHtml: 'true'},

   backgroundColor: 'transparent',

   interpolateNulls: false,

   isStacked: true,

   theme: 'material',

animation:{

        duration: 500,

        easing: 'out'

      },

hAxis: {format: '##.#%', textStyle: {fontSize: 12}},

histogram: { lastBucketPercentile: 5 }

}

        });    

To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/CAOtcSJNeJP6c3ht6cRFBecnKdNaBWvWA7Q_0eHt-3FNt2gFV4Q%40mail.gmail.com.

[Daniel LaLiberte]

The theme:'material' option might be causing a problem, depending on what you are seeing.  It modifies the bar.groupWidth, which now does affect the Histogram whereas it used to be ignored for histogram.  You should be able override that behavior by specifying bar.group.gap: 1  but that appears to not be working as expected, so I do need to fix that.  Or maybe we should change the theme:'material' behavior to leave the bar.groupWidth alone for histogram.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/CAO5F7cv4dt7W4R87H60QhqGBw3LaEemYnGJrZ2d%3DYB8MwEikiw%40mail.gmail.com.

For more options, visit https://groups.google.com/d/optout.

[Nick Dunbar]

All the bars appear stacked at the extreme left and right side of the chart, and disabling 'material' makes no difference. The exact same options work fine in version '43'. 

To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/CAOtcSJO7Udc8sd8u1fwiQ%2Bm_QhXZczKU65A9KjuLrFL8%3DgoHxw%40mail.gmail.com.

[Daniel LaLiberte]

Where your data is might make a difference as well, especially if the problem appears to be how the buckets are calculated or filled rather than how things are drawn.  I made a bunch of changes trying to deal with precision calculations of bucket boundaries, so I may need to see your actual data to figure this out.    Could you send me data in private email, or post an example that uses some smaller safe subset of data that still shows the problem?  Thanks.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/CAO5F7cs1rq1MxpsQEG%2BGmdO3e8XeDQONT%3DQiL2VQiyDax-ex0g%40mail.gmail.com.

For more options, visit https://groups.google.com/d/optout.

[Nick Dunbar]

Hi Dan, 

I don't know how to extract the data from the dataTable buried in my code into a form that I can send you or is usable as a safe subset. 

But you can generate something like it using this code: 

var histogramTable = new google.visualization.DataTable();

 histogramTable.addColumn('string', 'name');

 for (var i=0; i<11; i++){ 

 histogramTable.addColumn('number', i); 

}

 for (var i=0; i<500; i++) {

histogramTable.addRow(['',,,,,,,,,,,]);

}

for (var i=0; i<500; i++) {

var index = Math.floor((Math.random() * 11) + 1);

    histogramTable.setValue(i,index,Math.exp(-pow((Math.random()-0.5),2));

       }

To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/CAOtcSJPTsqOXEjepbTu17uAZF8GmREb1dEpKki40P7SVdE39fg%40mail.gmail.com.

[Daniel LaLiberte]

Your undefined values are the cause of values being stacked on the left, since they are treated like 0 in this case.   There is logic to skip null or undefined values, especially if interpolateNulls is false, but there seems to have been some problem with it.    I updated v44, however, and now it seems to work OK.   See this example using your data: https://jsfiddle.net/dlaliberte/bofqmmd4/

To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/CAO5F7cvjOF8mdYLmY5g%3DUy0Dg1xsCsoNz3_NOTD2p6cjSF-iAA%40mail.gmail.com.

For more options, visit https://groups.google.com/d/optout.

[Nick Dunbar]

Thanks Dan. '44' seems to work ok now with my original code, including the number formats. 

To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/CAOtcSJMNjHseyW5G4WHSxHKkW9QsKaY8AGdN0V_Uw06zn5PuSQ%40mail.gmail.com.

[Daniel LaLiberte]

Glad to hear it is working for you now.  

To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/CAO5F7cvWPe4Rqo0Yt9L_5MAYcPmt5BOTw8C-w3LRrLGE%2B8xZ-A%40mail.gmail.com.

For more options, visit https://groups.google.com/d/optout.