Hi,
I've been playing around with the dashboard capabilities and I am
struggling with the correct way to do something I believe should be very
simple...
In brief I would like the functionality of a CategoryFilter but rather than
filtering the data I would like it to re-summarise the data.
For example, I have sales for two markets (A,B) across a 3 week period:
Market, Week, Sales
A, 1, 10
A, 2, 11
A, 3, 12
B, 1, 5
B, 2, 4
B, 3, 3
In the unfiltered state I want to get the sum of sales across both markets:
Week, Sales
1, 15
2, 15
3, 15
When I filter market A or B I want to get back to the individual series
correctly.
How do I do this?
I've attached where I've got to - the problem being that in the unfiltered
state I get 2 series plotted on the chart rather than the sum total.
Additional notes:
1. In the final version I will have more than one filtering column (e.g.
Market, Country, State etc.).
2. In the final version I will be reading from a Google spreadsheet so if I
need to use the data query functionality that will be fine.
Thanks in advance,
Tim
--
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/-/fic6vbrEqHwJ.
To post to this group, send email to google-visualization-api@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.
Title:
Google Visualization API Sample