Hello, I was trying to use the categoryPicker dashboard item on an AnnotatedTimeLine. It doesn't lend itself very well to this time of graph however because for the annotatedtimeline data the columns are always only going to contain either a date or a numeric value. The categories that I want to filter on are in fact the column headers but this isn't an option.
I think I'm left with two choices: 1. return the datatable where the categories are listed in a column, and then create a separate dataview for the annotatedtimeline which has the correct format it expects. 2. As I am using the Query Language and getting the data from an MSSQL database, create my own catagoryPicker which alters the query depending on what is selected and then requeries and redraws. Option 2 seems to have the benefit of only getting the data from the database required, however does need to re-query which option 1 does not have to do, just filter and redraw. Have you got any advice on the best way to go with this, or do you think that a future version of the dashboard controls will allow for filtering on the Column headers rather than the values of a single columns (which would seem particularly useful for the annotated timeline). 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/-/DMEAYCYhd9gJ. 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.
