Number format in Sankey charts

[dunba...@gmail.com]

Hi, 

I've become a big fan of Google's sankey charts, but one thing is bothering me - I can't figure out how to do number formatting so that the relevant units show up with the numbers in the third data table column. I've tried several approaches - trying to set 'pattern' options, using formatter, but for the life of me nothing seems to work - see this JSFiddle example: http://jsfiddle.net/nickdunbar/t9e3dcy3/1/

Number formatting works so smoothly for the other Google chart types I can't believe that there isn't an option available somewhere. It isn't in the Google documentation. I have looked at the D3 literature but nothing obvious springs out there either. 

All help appreciated. 

NIck 

[Sergey Grabkovsky]

Hi Nick,

We don't have any options for controlling the formatting on the Sankey chart yet. We'll work on improving this for future versions, but you can file a feature request to help remind us.

--
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 http://groups.google.com/group/google-visualization-api.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/b813316e-b1f9-4fc5-b1de-b9099e27c60d%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

• • • •

Sergey Grabkovsky Software Engineer Google, Inc gra...@google.com

[Nick Dunbar]

Hi Sergey, 

Thanks for getting back to me. I got an answer to the problem on Stackoverflow: http://stackoverflow.com/questions/33996664/how-to-specify-number-formats-in-googles-sankey-charts-d3/33998420?noredirect=1#comment55755627_33998420

What do you think? 

Regards,

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/ax7ITGgcrQY/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 http://groups.google.com/group/google-visualization-api.

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

[Sergey Grabkovsky]

Oh that's true. I forgot about custom tooltips. Sorry about that; slipped my mind.

If that's enough for your use case, then by all means use them.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/CAO5F7csnJMohzQQuxa4g9-sHzf%3DQiED%2BzD%3D2qCku5N2%3DXoNLww%40mail.gmail.com.

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

[Nick Dunbar]

Not at all, I'm happy to share what I find out. You guys have done a great service to the community. Keep up the good work. 

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

[Nick Dunbar]

One thing that would be helpful to know is how to reinstate the Google default tooltip for Sankey charts along with the customisation. At present, as soon as the custom tooltip is added, the default of 'source -> target' etc disappears. How can I get that back again? Thanks again, Nick 

[Sergey Grabkovsky]

Right, so you can't do that automatically. That's one of the reasons why this solution didn't come to mind; it replaces the entire tooltip, instead of just formatting the value. You'd have to reproduce the formatting yourself.

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

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

[Nick Dunbar]

So could you do it with two tooltip columns - one for the tooltip text and one for the formatting? Would that reproduce the default while including the additional formatting? Something like this maybe (in pseudocode): 

1st column

data.getValue(source)+'->'+data.getValue(target)

2nd column

formatter.formatValue(data.getValue)

To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/CAEwwup7%3Du-VLiFa%3Dz%2BfXq40ydsM6%3DrbzQh-CWxEFxtfk_HkGhA%40mail.gmail.com.

[Sergey Grabkovsky]

I don't understand why you would need two tooltip columns. You can do it with one, you just need a newline between the two things. You'd probably be better off using a DataView and a calculated column than the exact solution you got on stackoverflow, though there's no reason that you can't use that method.

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

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

[Nick Dunbar]

You're right it only needs one column. But I can't get the newline to work. Putting '\n' inside the quote marks doesn't have any effect. I guess it could be done in HTML with a <br> tag. 

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

[Sergey Grabkovsky]

Oh I guess you're right. I thought we fixed that issue across all charts, but I guess not. I suppose your only remaining solution is an HTML tooltip with a <br> tag like you said.

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

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

[Daniel Hinostroza]

It worked for me with </br> instead of <br>