Not Planned [XF1] Google charts integration

[Alpha1]

I would like to use be able to use custom fields to show areas on maps. For example the popularity of the item per US state. i.e. I would like to display various statistical information on maps using Google charts.
There are many ways google charts can be used to showcase item information.
https://developers.google.com/chart/interactive/docs/gallery

 

[petrolskin]

I am trying to do some custom code for this also to extend functionality. If this is something that will be included in a future version of SC I can turn my attention to something else

 

[Bob]

I am trying to do some custom code for this also to extend functionality. If this is something that will be included in a future version of SC I can turn my attention to something else

I've marked it as considered, but that doesn't mean that I WILL be implementing it. I have no idea when I will even have time to look into this as I'm in the middle of a very large update already that is feature locked, so it won't be until SC 2.3.0 is released that I will even begin to look into some of the new suggestions.

 

[petrolskin]

I've marked it as considered, but that doesn't mean that I WILL be implementing it. I have no idea when I will even have time to look into this as I'm in the middle of a very large update already that is feature locked, so it won't be until SC 2.3.0 is released that I will even begin to look into some of the new suggestions.

No problem Bob, understood.

 

[tajhay]

would LOVE this feature too!

 

[3rd angle]

I came in planning to request this... and @alfa1 beats me... in fact, in all suggestion threads (in all XF related forums) Alfa1 is the dude that beats everyone

 

[Bob]

With this much interest, I certainly will take some time to do some extensive R&D for it. When I get to that point, I'll probably start a convo with you guys so I have a good understand of what each of you are wanting (you can post examples here if you want to).

 

[Alpha1]

Awesome news Bob!

 

[Alpha1]

I am going to use Showcase to showcase information about various items. This includes statistical data which I would like to display with charts.
For example show the prevalence of something in a Geo map. See the top map here: https://developers.google.com/chart/interactive/docs/gallery/geochart
The idea is that users fill in custom fields, for each state/country and this data is displayed in the map.
Similarly I would like to show the status of an area. Similar to how the election results are shown on a per state basis in this chart here: http://stackoverflow.com/questions/...t-the-region-color-for-each-state-in-geochart

I would also like to use it in a way similar to polls to show percentages / popularity in a Pie chart: https://developers.google.com/chart/interactive/docs/gallery/piechart

Tables would also be very handy to showcase statistical data from custom fields. https://developers.google.com/chart/interactive/docs/gallery/table
Column Charts: https://developers.google.com/chart/interactive/docs/gallery/columnchart
Line Charts: https://developers.google.com/chart/interactive/docs/gallery/linechart

As I envision it the data for the charts would come from custom fields. The fields are filled in by a user. For example if the custom field is for a map, then the user would select the region (state/country) possibly from a drop down and then fill in the related data in one or more fields. This data is then displayed in the GeoChart.
A relational custom field would be very useful: a field which pulls data (averages,etc) from other fields.
It would be very awesome if we could take this a step further and allow multiple users to post data, so that it becomes a small survey / poll. For example:
Lets say we make a mini survey for 1969 Boss 429 sightings.
Field1: select your state
Field2: how many 1969 Boss 429 have you seen this year?

4 users from Montana fill in this survey in 2014. The total number of sightings in Montana from these users is 9.
On the Geomap this displays on the area of Montana. When hovering over montana the information is displayed that there were 9 sightings in 2014. And if there is data from 2013, then that can be shown as well.

Another example is a field where users can fill in how much they paid for car. For the 1970 Plymouth Barracuda showcase item this would mean that you would be able to see the prices of the 1970 Plymouth Barracuda on a state by state basis. Or even on a country by country basis. How it would work is that users would enter their location and the price they have paid for their 1970 Plymouth Barracuda. Lets say 5 users in Montana enter a price.
By the use of a relational field the system can calculate an average of what these 5 users have paid. This average is then displayed on a map.
If we have the average price of last year as well, then we can show a column chart or a line chart showing the fluctuation of the price over time.

It does not need to be Google charts. What we need are pretty charts to showcase boring statistical data in a visually pleasing way. Whether that is from Google or from jQuery or somewhere else does not matter.

 

[Alpha1]

Flot has the benefit that its already included into XF and no external widgets need to be loaded.
Google charts looks better and has more options, but it can cause page loading problems, privacy concerns and EU cookie law issues.

 

[Alpha1]

Somewhat related: http://xenaddons.com/threads/google-insights-charts.1453/