Charts

Charts

Essentially what I'd like to do is create one chart that then allows the user to specify the y-axis without having to put all the fileds in the y-axis for myself and then requiring them to check and uncheck the legend filters.

Ideally I'd like to let the user do the following:

9 columns"

Date
Absolute Month
Brand
Campaign
Ad Group
Keyword
Clicks (number)
Impressions (number)
Click through Rate (percent)

I want to create one chart, then allow the user to select from three different numbers to display - clicks, impressions, click through rate.

Basically, I want them to select the "chart they want", then perform ascending filters - brand, campaign, ad group, keyword.

Is this possible? or will it ever be?  This goes along with my averages post I made a little while ago, as I also need the user to be able to select a date range and have the Click through rate formula or query calculate based on that user input.

Jamie