Format number on Fusion Tables

[Rafael]

Hi,

I would like to format the number on the Fusion Table view. I'm using
this example, with modifications:
https://developers.google.com/fusiontables/docs/samples/gviz_datatable?hl=pt-br.
But, in a number column, i need format with "," and "$". I have
founded this code that suits me (http://code.google.com/intl/pt-BR/
apis/chart/interactive/docs/reference.html#numberformatter), i just
don't know where to use it.

Can anybody help me?

[asgallant]

It is used like this:

var formatter = new google.visualization.NumberFormat({prefix: '$'});

formatter.format(dataTable, column);

create the formatter and call the #format method before you draw the chart.

[Rafael]

I have one more doubt: where exactly should I put this code? And wich
variable I should set in this part dataTable (dataTable, column)? I'm
using, as I said before, this example:
https://developers.google.com/fusiontables/docs/samples/gviz_datatable.

Thanks!

[asgallant]

That example has to be tweaked to make this work (as you need a DataTable object to format first).  I made the modifications here: http://jsfiddle.net/dkYBx/

The first argument for the #format method is the DataTable object to work on and the second is the column within the DataTable.  The #format method must be called after populating the DataTable object but before drawing any charts/tables with the data.

Note that in this example, all columns returned from the fusion table are strings, so the formatter does not do anything.

[asgallant]

Oops, I left a console.log() call in there by mistake, which could cause problems with IE; here's a version without: http://jsfiddle.net/dkYBx/1/

[Rafael]

Thanks a lot!

[asgallant]

You're welcome.