I need one more help in deciding how to visualize the following data mean which chart to use on the following type of data.
The count is the grouping of the chrom,ref and alt columns. I need to show this in some kind os visualization for the users. I tried several graphs but no luck. Chrom Ref Alt Count YTC3154TC379988AC63396CA,T78TA,C320AC,T214GC,T118TA27059 TA451710GT6506 Really appreciate your help. Ragini On Saturday, 20 July 2013 23:59:34 UTC-4, Ragini Pandey wrote: > > Hi, > > I an trying to create a piechart but only the label shows but the chart is > not displayed. Here is the link. > http://medeolinx.com/BASP/vcf-details-visualize.php > > Here is the code- > <script type="text/javascript"> > google.load('visualization', '1.0', {'packages':['controls']}); > $(document).ready(function (){ > // Set a callback to run when the Google Visualization API is > loaded. > //alert("loaded"); > google.setOnLoadCallback(visualizebase); > > var vcffilename='vcf1'; > function visualizebase() { > var jsonDataResult = $.ajax({ > url:"getvcfvisualizeData.php", > data:{vcffilename:vcffilename, > visualtype:'base'}, > dataType: "text", > async: false, > success: ( > function(data) { > > //alert(data); > alert("loaded"); > var tData = > google.visualization.arrayToDataTable(eval(data)); > // Create a dashboard. > var dashboard = new > google.visualization.Dashboard(document.getElementById('dashboard_div')); > // Define a category picker for the 'Go Name' > column. > var platformPicker = new > google.visualization.ControlWrapper({ > 'controlType': 'CategoryFilter', > 'containerId': 'platformPicker_div', > 'options': { > 'filterColumnLabel': 'Reference', > 'ui': { > //'allowTyping': true, > 'allowMultiple': true, > //'sortValues':true, > 'labelStacking':'vertical', > 'state': {'selectedValues': ['A', > 'C']}, > 'selectedValuesLayout': 'belowStacked' > } > } > > }); > > var altPicker = new > google.visualization.ControlWrapper({ > 'controlType': 'CategoryFilter', > 'containerId': 'altPicker_div', > 'options': { > 'filterColumnLabel': 'Alt', > 'ui': { > 'allowMultiple': true, > 'labelStacking':'vertical', > 'selectedValuesLayout': 'belowStacked' > } > } > > }); > > > var logChart = new > google.visualization.ChartWrapper({ > 'chartType': 'PieChart', > 'containerId': 'chart_div', > 'options': { > 'width': 550, > 'height': 300, > 'title': 'Ref and Alt', > 'pieSliceText': 'value', > 'legend': 'right' > }, > 'view': {'columns': [3,4]} > }); > > > var result = google.visualization.data.group( > tData, > [3,4], > [{'column': 3, 'aggregation': > google.visualization.data.count, 'type': 'number'}] > ); > > var table = new > google.visualization.ChartWrapper({ > 'chartType': 'Table', > 'containerId': 'table_div', > 'options': { > 'page': 'enable', > 'pageSize': 20, > 'pagingSymbols': {prev: 'prev', next: > 'next'}, > 'pagingButtonsConfiguration': 'auto', > 'showRowNumber':true > } > }); > > > > //dashboard.bind(platformPicker, > table).bind(platformPicker, altPicker).bind(altPicker, table); > dashboard.bind([platformPicker,altPicker], > [logChart,table]).bind(platformPicker, altPicker); > > dashboard.draw(tData); > > }) > }); > } > > }); > </script> > > Please help. > I also needed help with grouping the 3,4 columns together to get the > counts and show in some kind of chart > > > Thanks > Ragini > -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/google-visualization-api. For more options, visit https://groups.google.com/groups/opt_out.
