Hi, I hope you are doing well.
I would love to share a Data Visualization tool for Excel, Office 365 and Google Sheets. You can make charts like Treemap, Sankey, Sentiment Comparison, Likert, WordCloud, Scatterplot, Crosstab Bar Chart and many more with few clicks; No coding skills required. Installation Source: ChartExpo™ for Google Sheets <https://chartexpo.com/utmAction/MTErY29tbXVuaXR5K2dzK1NCK0dHKw==> ChartExpo™ for Excel <https://chartexpo.com/utmAction/MTErY29tbXVuaXR5K3hsK1NCK1JHKw==>: Thanks & Regards. On Friday, July 2, 2021 at 1:52:37 AM UTC+5 [email protected] wrote: > Well, I was able to resolve this myself. I wanted to post my own answer, > in case this can help anyone else later on. > > I finally realized that the numeric data I was trying to get Treemap to > work with was coming through the JSON as string values. So, since Treemap > wasn't able to add strings up into meaningful numbers, it was not > displaying anything. Forcing the strings '.00', '2.00', '5.00', etc into > literal numeric values allowed Treemap to work and display everything > exactly as it should. > > On Tuesday, 29 June 2021 at 17:22:48 UTC-4 Dwight T. Oakey wrote: > >> I am attempting to use Treemap on a web page for the first time. My data >> is retrieved from a server-side, perl script. When I use static, dummy >> data, my Treemap displays properly. Dummy data is only 54 rows. However, >> when I query my database, and return 1145 rows of data, the Treemap >> displays with the "root node", but nothing else - it is just blank space. >> My data is formatted the same way in both cases, with my "containers" at >> the top of the recordset and my "data points" at the bottom of the list. I >> have attached a screen shot of where my chart should be, but isn't. [image: >> Blank Treemap.png] >> >> Is there some limit to the number of rows of data? Is there some limit to >> the "distance between the 'containers' and the 'data points'"? Has anybody >> else even seen a "blank" chart like this? Any ideas on how to get my 1145 >> rows of data to display in a Treemap? >> I get my data via an $.ajax() call (which returns JSON), and pass it to >> this function to draw my Treemap. >> function drawTreemap (newdata) { >> data = new google.visualization.arrayToDataTable(newdata); >> >> tree = new >> google.visualization.TreeMap(document.getElementById('chart_div')); >> >> tree.draw(data, { >> title: 'Top Credit Hours Earned', >> minColor: '#AADDE9', >> midColor: '#00eee9', >> maxColor: '#0f0', >> headerHeight: 15, >> fontColor: 'black', >> showScale: true, >> generateTooltip: showCredits >> }); >> } >> My "data" is present, both because "System" is my root node and because I >> can log it to the console. When the Treemap displays properly, my >> showCredits() function works properly. >> Thanks, all. >> > -- 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 view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/ce2ed8aa-14cb-44de-9851-531804129779n%40googlegroups.com.
