Intial sets of learning:
- While loading multiple package use one single google.load() statement.
- When using both package 1 and 1.1 we can use only 1.1 as it is backward compatible.
- In google playground click edit html for complete source code.
- Months of google date starts from index 0 (zero) as January.
- You must give all controls a filterColumnIndex (or filterColumnLabel) to specify column in use.
- You should listen for the ready event before you try to change the dashboard composition or draw it again.
- A control can be added in chart location for binding as well as in control location later.
- Using bortosky-google-visualization for integrating data source with Dot Net.
- Changed a code in above lib to manage date & datetime i.e: return string.Format(“\”Date({0}, {1}, {2})\””, d.Year, d.Month – 1, d.Day);
- We will include Visualization libs source code in our solution.
- In new google.visualization.DataTable(gdt, 0.5) < 0.5 is version of the google api
- Before returning the data table to UI change the date column with google charts date data type.
- We need to be very careful of the data type that we are sending to the charts, especially with int and datetime. Since some column mapping like pie charts only take integers.
- To add pagination to table of google charts. add page : ‘enable’ under option section
- If we are using GeoCharts we cannot zoom and pan by default. It will come in future version. But we can create a manual zoom and pan if required.
- Few of the data in the charts are send to the server for processing. So need to be careful with data security.
Happy Charting!
Vikram Shetty 