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 -~----------~----~----~----~------~----~------~--~---
