Hi Jonathan - I'm currently doing this with a PHP function that I wrote that queries tables on a MySQL database.
Users can currently use dropdowns and checkboxes to set WHERE selections on several variables, choose X and Y axis variables, limit time series depth, set chart size and chart type and choose between several data source tables which contain different states of a simulation we are running. The settings are processed on the server and return a correctly formatted data set to a Motion Chart embedded in a PHP / HTML page that refreshes every time a change is requested. The Motion Chart displays the users' chosen data and visualization settings for further analysis. All these choices are saved between sessions in cookies so they "persist" for users - something they definitely appreciate. Switching between different source tables in the same Motion Chart was a bit tricky, but it works. An interesting aspect of this function is that - with the exception of the first 2 variables in the data source table - it does not matter what variables the tables contain, what they are called, what order they occur in or even how they are represented as data types in the table. The function reads the variable names and types and fills in the corresponding drop downs accordingly. In alphabetical order to make it easier to find variables when there are 40 - 50 of them to choose from. So: it can be done. Your specific idea "Where D contains" could be implemented through simple LIKE syntax in the SQL statement that the PHP function assembles. Hope this helps. -- 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.
