DataTable + Dashboard + Auto Charts

[IMTheNachoMan]

I was wondering if, given a populated DataTable, is there a way to
create a chart where the user can pick various options (including the
chart) and it will reflect those in the charts.
 
For example, if I have a DataTable with 3 columns, a string and 2
numbers, the user could select “pie chart” and then select column 1
and column 2 and it would show a pie chart with column 1 and column 2.
Or if the user selected “column chart” and selected column 1, 2 and 3,
it would show as such.
 
Any ideas?

[asgallant]

The dashboards and controls might do most of what you want (though they are in beta and thus subject to change): http://code.google.com/apis/chart/interactive/docs/gallery/controls.html.

You would probably have to write your own handler to do some of what you want (IIRC, the dashboards don't let you change chart types (yet?), but that shouldn't be too hard to work around).

[IMTheNachoMan]

I saw those but I wanted something where a user could graphically
alter a DataTable. Say group by a column or other stuff. All
dynamically.

[Riccardo Govoni]

I don't think we have something like that.

The controls library let users alter a datatable mostly row-wise (via filtering), although we are exploring alternatives for different kind of data manipulations.

The ChartEditor lets the user customize the chart type and options given a specific ChartWrapper (that is, given a specific DataTable contained therein).

But there is no readymade user interface for columnwise Datatable manipulation. I think what you want is a GUI whose input is a DataTable and whose output is a different DataTable (or Dataview) matching the user organization criteria. This fits in the scheme laid  out by the controls library but such component does not exist yet.

Feel free to file a feature request for this. Part of the reason the 'controls' library exists in beta status is exactly to gather a better understanding of usage patterns from adopters.

[IMTheNachoMan]

I actually already wrote it...sorta...almost done.

It works by letting the programmer define different functions for
calculated columns and group by aggregations. When the page loads it
shows the current table then you add a 'transformation' and select the
function you want, the columns you want, etc...

On Aug 17, 5:54 am, Riccardo Govoni <battleho...@gmail.com> wrote:
> I don't think we have something like that.
>
> The controls library let users alter a datatable mostly row-wise (via
> filtering), although we are exploring alternatives for different kind of
> data manipulations.

> The ChartEditor<http://code.google.com/apis/chart/interactive/docs/reference.html#goo...>lets the user customize the chart type and options given a specific

> ChartWrapper (that is, given a specific DataTable contained therein).
>
> But there is no readymade user interface for columnwise Datatable
> manipulation. I think what you want is a GUI whose input is a DataTable and
> whose output is a different DataTable (or Dataview) matching the user
> organization criteria. This fits in the scheme laid  out by the controls
> library but such component does not exist yet.
>

> Feel free to file a feature request<http://code.google.com/p/google-visualization-api-issues/issues/list>for this. Part of the reason the 'controls' library exists in beta status is