Perfect!
Thank you
On Monday, June 16, 2014 7:53:12 PM UTC+2, Andrew Gallant wrote:
>
> The formatters won't do this for you, but you can format your data
> yourself:
>
> for (var i = 0; i < grouped_data.getNumberOfRows(); i++) {
> for (var j = 1; j < grouped_data.getNumberOfColumns(); j++) {
> if (grouped_data.getValue(i, j) == null) {
> grouped_data.setFormattedValue(i, j, '');
> }
> }
> }
>
> On Monday, June 16, 2014 4:19:08 AM UTC-4, bob3321 wrote:
>>
>> Hello everyone,
>> I have a table chart showing the totals qta by month.
>> the data is loaded by the function
>>
>> var grouped_data =google.visualization.data.group= (
>> dt, [0],
>> [{'column': 1, 'aggregation': google.visualization.data.sum,
>> 'type': 'number'}, / / gen
>> [{'column': 2, 'aggregation': google.visualization.data.sum,
>> 'type': 'number'}, / / feb
>> ...
>> ]);
>>
>> Often the amount per month is 0.
>> I wish that instead of zero was shown the empty cell, for better
>> readability.
>> There is a special formatter, or another trick I can use?
>>
>> thanks
>>
>
--
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 [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/google-visualization-api.
For more options, visit https://groups.google.com/d/optout.
