you get null values since your data is missing. You can change your dataso that null will not be part of the response.
On Mon, Jul 27, 2009 at 9:24 PM, [email protected] <[email protected]> wrote: > > Thanks I can do that, but I wanted to rename null to "misc > department". > > On Jul 27, 11:10 am, ChartMan <[email protected]> wrote: > > Hi > > The problem is not renaming but how to filter a certain row from the > data. > > Try our 'where' query statementhttp:// > code.google.com/apis/visualization/documentation/querylanguage... > > > > <http://code.google.com/apis/visualization/documentation/querylanguage.. > .> > > ChartMan > > > > On Mon, Jul 27, 2009 at 8:41 PM, [email protected] <[email protected]> > wrote: > > > > > Here's a sample result from the following statement: > > > > > select dept, sum(cost) > > > from dept > > > group by dept; > > > > > dept sum(cost) > > > ---- -------- > > > null 1000 > > > 200 20 > > > 300 100 > > > > > Is there a way I can rename the null value to some other value? > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/google-visualization-api?hl=en -~----------~----~----~----~------~----~------~--~---
