What are you trying to do with this?
calc: function (dt, row) {
var number0 = dt.getValue(row, 3);
var number1 = dt.getValue(row, 4);
var number3 = dt.getValue(row, 5);
var formatter = new
google.visualization.NumberFormat({fractionDigits:2});
console.log(formatter.formatValue(number0), typeof
(formatter.formatValue(number0)));
console.log(formatter.formatValue(number1), typeof
(formatter.formatValue(number1)));
console.log(formatter.formatValue(number3), typeof
(formatter.formatValue(number3)));
return {
v: number0,
f: formatter.formatValue(number0)
}
return {
v: number1,
f: formatter.formatValue(number1)
}
return {
v: number3,
f: formatter.formatValue(number3)
};
}
The 2nd and 3rd "return" statements will never be reached (and even if you
could return multiple values, in one function, the API doesn't know what to
do with them).
On Wednesday, September 18, 2013 12:05:34 PM UTC-4, khamosh wrote:
>
> thanks alot for your answer,
> that's right,
> but now my problem is this:
>
> view: {
>
> columns: [
>
> {
>
> type: "string",
>
> calc: function (dt, row) {
>
> var date = dt.getValue(row, 2);
>
> var formatter =
> newgoogle.visualization.DateFormat({pattern:"dd/MM/yyyy
> HH:mm"});
>
> }
>
> },
>
>
>
> {
>
> type:"number",
>
> calc: function (dt, row) {
>
> var number0 = dt.getValue(row, 3);
>
> var number1 = dt.getValue(row, 4);
>
> var number3 = dt.getValue(row, 5);
>
> var formatter =
> newgoogle.visualization.NumberFormat({fractionDigits:2});
>
> console.log(formatter.formatValue(number0),
> typeof(formatter.formatValue(number0)));
>
> console.log(formatter.formatValue(number1),
> typeof(formatter.formatValue(number1)));
>
> console.log(formatter.formatValue(number3),
> typeof(formatter.formatValue(number3)));
>
> return {
>
> v: number0,
>
> f: formatter.formatValue(number0)
>
> }
>
> return {
>
> v: number1,
>
> f: formatter.formatValue(number1)
>
> }
>
> return {
>
> v: number3,
>
> f: formatter.formatValue(number3)
>
> };
>
> }
>
> },
>
> 6,7]
>
> }
>
>
> az you see i must to change the "type" of the 3 Column ???
>
>
>
>
>
> On Wednesday, September 18, 2013 5:11:47 PM UTC+2, asgallant wrote:
>>
>> Also, you need to change the "type" of the series to "number":
>>
>> {
>> type: 'number',
>> calc: function (dt, row) {
>> var number = dt.getValue(row, 2);
>> var formatter = new
>> google.visualization.NumberFormat({fractionDigits:2});
>> return {
>> v: number,
>> f: formatter.formatValue(number)
>> };
>> }
>> }
>>
>> On Wednesday, September 18, 2013 10:51:16 AM UTC-4, asgallant wrote:
>>>
>>> You are returning a string value when you should be returning a number
>>> value. If you want to format the data, you can return it as an object with
>>> "v" (value) and "f" (formatted value) properties:
>>>
>>> calc: function (dt, row) {
>>> var number = dt.getValue(row, 2);
>>> var formatter =
>>> newgoogle.visualization.NumberFormat({fractionDigits:2});
>>> return {
>>> v: number,
>>> f: formatter.formatValue(number)
>>> };
>>> }
>>>
>>>
>>>
>>> On Wednesday, September 18, 2013 9:22:12 AM UTC-4, khamosh wrote:
>>>>
>>>> hello every body
>>>> I have a ComboChart with ControlWrapper, I want in my chart only I see
>>>> the the figure on two decimal places, so I use formatter, this my code
>>>>
>>>> view: {
>>>>
>>>> columns: [
>>>>
>>>> {
>>>>
>>>> //transform the numbers into strings, so the
>>>> steppedArea series will work
>>>>
>>>> type: "string",
>>>>
>>>> calc: function (dt, row) {
>>>>
>>>> var date = dt.getValue(row, 2);
>>>>
>>>> var formatter =
>>>> newgoogle.visualization.DateFormat({pattern:"dd/MM/yyyy
>>>> HH:mm"});
>>>>
>>>> return formatter.formatValue(date);
>>>>
>>>> console.log(calc, typeof (calc));
>>>>
>>>> }
>>>>
>>>> },
>>>>
>>>> {
>>>>
>>>> type:"string",
>>>>
>>>> calc: function (dt, row) {
>>>>
>>>> var number = dt.getValue(row, 2);
>>>>
>>>> var number = dt.getValue(row, 3);
>>>>
>>>> var number = dt.getValue(row, 4);
>>>>
>>>> var formatter =
>>>> newgoogle.visualization.NumberFormat({fractionDigits:2});
>>>>
>>>> console.log(calc);
>>>>
>>>> return formatter.formatValue(number);
>>>>
>>>> }
>>>>
>>>> },
>>>>
>>>> 6,7]
>>>>
>>>> }
>>>>
>>>>
>>>> but I have this error :
>>>>
>>>> One or more participants failed to draw()×
>>>> All series on a given axis must be of the same data type×
>>>>
>>>
--
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/groups/opt_out.
