Hi, I'm using the query language and using the aggregation functions along with a pivot which then causes the column names to be labelled with the aggregation function. Is there a simple way to relabel all the columns to remove the aggregation function from the name? I can see there is a label function for the query but that would require me having a full list of the columns in advance which I wouldn't unless I did two queries. Is running a initial query to find out the distinct values that will be pivoted into columns or is there a simpler more efficient way to rename the columns. I know that the label name should always be 4 characters so if there is a easy way to rename then I can just do a substring.
Any advice for the best way to achieve this? Thanks, Dan -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To view this discussion on the web visit https://groups.google.com/d/msg/google-visualization-api/-/OKtO8sQKEd4J. 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.
