graphic line filter

[Victor Capeluto]

I have been looking for a line graphic with 2 filters, i need to show it as follows:
1- The amount of advertising by currency (US$, EUR, CAD$) (i want to have a filter for every currency)
2- Total gross profit or profit divided by advertising or paid version (is a license type of software) (i want to select one of those 3 options)

Please help me with this I'm really late, google doesn't have good help about this subjects!


Regards

[Sergey Grabkovsky]

Hello, it sounds like you want a LineChart with some Controls. It sounds like you want something with two CategoryFilters (one for the currency and another for the profit). However, I'm a bit confused about how you intend to structure your data. Is this by date? If so, then does every row have both a cost and a revenue? Or does every row represent a sold copy? If that's the case, then I'm not sure how the advertising part fits in here. Do you have any data that I can look at (real or fake) to help you further?

- Sergey

--
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/-/x2Kw7Nk6bTUJ.
To post to this group, send email to google-visua...@googlegroups.com.
To unsubscribe from this group, send email to google-visualizati...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/google-visualization-api?hl=en.

[asgallant]

There are a few different ways to handle this.  First off, do you plan to load the different currency amounts into the chart, or do you want the chart to convert from one currency to another?  Do you want the change in currency for the advertising to affect the displayed values for the profit?

[Victor Capeluto]

Hi Sergey,

This is what i have now, that filter is not working and i need another filter for the currency (i don't want to show all currencies like that).
Yes, the graph is by date so i need to show the total amount of donations by currency and if is paid version/free version or both.

[Sergey Grabkovsky]

Hi, I still need to know the exact format of your DataTable, since that will determine how you should proceed. asgallant actually brought up a good point that I didn't consider, which is did you want the other currencies to convert on the fly to whatever currency you have selected? Or did you just want to compare how much each currency contributed?

- Sergey

[Victor Capeluto]

Hi gallant,

First, i need a filter for the currency so i need to show only 1 currency per time.
Second, I have 3 amounts per currency X amount/$ for paid version, X amount/$ for free version (which is by advertising) and X amount/$ for both. So i have 3 amounts per currency.
Basically i need 2 filters:
Currency: US/EUR/CAD
License type: Paid/Ad/Both

I hope this is clearly than the previous explanation.
Thanks in advance

--

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/-/V8OHIkVosC8J.

[Victor Capeluto]

I just need to compare how much each currency contribution and by license type, so i have 3 differents amounts per currency because of license type.

[asgallant]

Ok, I see what you need.  If my assumptions are correct, you have 10 columns of data: 1 for date, and 1 for each license type for each currency.  You then need two controls to select which column(s) of data to present in the chart.  This is doable, but will require a bit of custom coding to make it happen, as there isn't anything in the API that will do this for you.  As a starting point, I wrote a hack that turns the CategoryFilter control into a column selector (see http://jsfiddle.net/asgallant/WaUu2/); check it out and see if that works similar to what you want.

On Wednesday, January 23, 2013 3:21:26 PM UTC-5, Victor Capeluto wrote:

I just need to compare how much each currency contribution and by license type, so i have 3 differents amounts per currency because of license type.

On Wed, Jan 23, 2013 at 3:15 PM, Sergey Grabkovsky <gra...@google.com> wrote:

Hi, I still need to know the exact format of your DataTable, since that will determine how you should proceed. asgallant actually brought up a good point that I didn't consider, which is did you want the other currencies to convert on the fly to whatever currency you have selected? Or did you just want to compare how much each currency contributed?

- Sergey

On Wed, Jan 23, 2013 at 3:11 PM, Victor Capeluto <vscf...@gmail.com> wrote:

Hi Sergey,

This is what i have now, that filter is not working and i need another filter for the currency (i don't want to show all currencies like that).
Yes, the graph is by date so i need to show the total amount of donations by currency and if is paid version/free version or both.

On Wed, Jan 23, 2013 at 2:34 PM, Sergey Grabkovsky <gra...@google.com> wrote:

Hello, it sounds like you want a LineChart with some Controls. It sounds like you want something with two CategoryFilters (one for the currency and another for the profit). However, I'm a bit confused about how you intend to structure your data. Is this by date? If so, then does every row have both a cost and a revenue? Or does every row represent a sold copy? If that's the case, then I'm not sure how the advertising part fits in here. Do you have any data that I can look at (real or fake) to help you further?

- Sergey

On Wed, Jan 23, 2013 at 2:16 PM, Victor Capeluto <vscf...@gmail.com> wrote:

I have been looking for a line graphic with 2 filters, i need to show it as follows:
1- The amount of advertising by currency (US$, EUR, CAD$) (i want to have a filter for every currency)
2- Total gross profit or profit divided by advertising or paid version (is a license type of software) (i want to select one of those 3 options)

Please help me with this I'm really late, google doesn't have good help about this subjects!


Regards

--
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/-/x2Kw7Nk6bTUJ.
To post to this group, send email to google-visua...@googlegroups.com.

To unsubscribe from this group, send email to google-visualization-api+unsub...@googlegroups.com.

For more options, visit this group at http://groups.google.com/group/google-visualization-api?hl=en.

--
You received this message because you are subscribed to the Google Groups "Google Visualization API" group.
To post to this group, send email to google-visua...@googlegroups.com.

To unsubscribe from this group, send email to google-visualization-api+unsub...@googlegroups.com.

For more options, visit this group at http://groups.google.com/group/google-visualization-api?hl=en.

--
You received this message because you are subscribed to the Google Groups "Google Visualization API" group.
To post to this group, send email to google-visua...@googlegroups.com.

To unsubscribe from this group, send email to google-visualization-api+unsub...@googlegroups.com.

For more options, visit this group at http://groups.google.com/group/google-visualization-api?hl=en.

--
You received this message because you are subscribed to the Google Groups "Google Visualization API" group.
To post to this group, send email to google-visua...@googlegroups.com.

To unsubscribe from this group, send email to google-visualization-api+unsub...@googlegroups.com.

[Victor Capeluto]

Hi Gallant,

I got this message from your code, so i can't test it. Can you help me with this please?

To view this discussion on the web visit https://groups.google.com/d/msg/google-visualization-api/-/qGiX2_NJRTEJ.

To post to this group, send email to google-visua...@googlegroups.com.

To unsubscribe from this group, send email to google-visualizati...@googlegroups.com.

[Victor Capeluto]

Hi gallant,

Did you received my message? there is a license message so i'm unable to test your code...

On Wed, Jan 23, 2013 at 3:34 PM, asgallant <drew_g...@abtassoc.com> wrote:

To view this discussion on the web visit https://groups.google.com/d/msg/google-visualization-api/-/qGiX2_NJRTEJ.

To post to this group, send email to google-visua...@googlegroups.com.

To unsubscribe from this group, send email to google-visualizati...@googlegroups.com.

[asgallant]

You can test the code; the message is just a standard Creative Commons license granting you the right to use the code according to the terms set forth here.  When you opened the link there should have been a chart and a control in the lower right pane; if they didn't show up then either there is a bug I am unaware of in my code or you have javascript turned off in your browser.

- Sergey

- Sergey

To unsubscribe from this group, send email to google-visualization-api+unsubscr...@googlegroups.com.

For more options, visit this group at http://groups.google.com/group/google-visualization-api?hl=en.

--
You received this message because you are subscribed to the Google Groups "Google Visualization API" group.

To post to this group, send email to google-visua...@googlegroups.com.

To unsubscribe from this group, send email to google-visualization-api+unsubscr...@googlegroups.com.

For more options, visit this group at http://groups.google.com/group/google-visualization-api?hl=en.

--
You received this message because you are subscribed to the Google Groups "Google Visualization API" group.

To post to this group, send email to google-visua...@googlegroups.com.

To unsubscribe from this group, send email to google-visualization-api+unsubscr...@googlegroups.com.

For more options, visit this group at http://groups.google.com/group/google-visualization-api?hl=en.

--
You received this message because you are subscribed to the Google Groups "Google Visualization API" group.

To post to this group, send email to google-visua...@googlegroups.com.

To unsubscribe from this group, send email to google-visualization-api+unsubscr...@googlegroups.com.

For more options, visit this group at http://groups.google.com/group/google-visualization-api?hl=en.

--
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/-/qGiX2_NJRTEJ.

To post to this group, send email to google-visua...@googlegroups.com.