Big Data Analysis to a Slide Presentation Reviews
41851 reviews
Guys, this is the second time i do this lab and it's really bad bad written and super confusing lab. To start, it may be necessary to access gScript settings to turn on BQ API (i had to spend a lot time trying here and there until i find this was OFF). Then, it's really super super confusing all this wording. You guys may, for instance, take code lines to provide instructions as they move forward (place this code at line x because it will bla bla bla), or sketch where things goes in a map so people can figure it out the where things go and the why they need to be done that way. I place it amongst top 3 most frustrating labs i've ever done. Thanks. ---- Gosh, i can't do a decent score in Next 20 with this lab. More inputs: This is where things start to get out of track. What the hell do you guys mean with "tweak app"??? 2. Return spreadsheet: In the above code, createColumnChart() needs the spreadsheet object, so tweak app to return spreadsheet object so it can pass it to createColumnChart(). After logging the successful creation of the Google Sheet, return the object at the end of runQuery(). Replace the last line (starts with Logger.log) with the following: --- Isn't logical segregation so fancy and cute??? 3. Drive createBigQueryPresentation() function: Logically segregating the BigQuery and chart-creation functionality is a great idea. Create a createBigQueryPresentation() function to drive the app, calling both and createColumnChart(). --- What log line? No one read about a "log" immediately previously to this to be written. Why not include this instruction a couple paragraphs before, where changes already affects the logger.log line? To make runQuery() more digestible for general use, move that log line. The best place to move it? If you guessed createBigQueryPresentation(), you'd be correct! --- At this moment in time, there are 2 createColumnChart() functions: one at createBigQueryPresentation() function (Runs a BigQuery query, adds data and a chart in a Sheet) and another one in the createColumnChart(spreadsheet) function (Uses spreadsheet data to create columnar chart)... where it goes? All of the work on the slide deck takes place in the createSlidePresentation() function, which you add to bq-sheets-slides.gs right after the createColumnChart()function code. --- When i land here: 2. Add data table: The next step in createSlidePresentation() is to import the cell data from the Google Sheet into our new slide deck. Add this code snippet to the createSlidePresentation()function: I'm so damn furious of this lab that i just wanna puke ! --- On this one, you guy have a closing parenthesis: 3. Import chart: The final step in createSlidePresentation() is to create one more slide, import the chart from our spreadsheet, and return the Presentation object. Add this final snippet to the function: But you don't have an opening one :)))) --- on this instruction: 5. Update createBigQueryPresentation(): Since createColumnChart() returns the chart, you need to save that chart to a variable then pass both the spreadsheet and the chart to createSlidePresentation(). It funny because it's an instruction that operates over a previous instruction (the one to add the Logger.log). You guys are genious of this world. Can't this be simplified???
Américo A. · Reviewed over 5 years ago
Pujan T. · Reviewed over 5 years ago
Linh V. · Reviewed over 5 years ago
great but I have problems with the server
Rebeca P. · Reviewed over 5 years ago
Excellent introduction to appscript and gsuite services.
Ramakrishna R. · Reviewed over 5 years ago
Kamalesh N. · Reviewed over 5 years ago
Tahir M. · Reviewed over 5 years ago
Michel J. · Reviewed over 5 years ago
Roberto M. · Reviewed over 5 years ago
Jonathan S. · Reviewed over 5 years ago
Mohamed Y. · Reviewed over 5 years ago
Andrey T. · Reviewed over 5 years ago
Sumeet S. · Reviewed over 5 years ago
Satyam S. · Reviewed over 5 years ago
Vadim G. · Reviewed over 5 years ago
Onur B. · Reviewed over 5 years ago
Marcos J. · Reviewed over 5 years ago
Nathaly S. · Reviewed over 5 years ago
Saksham G. · Reviewed over 5 years ago
Bhavesh W. · Reviewed over 5 years ago
Minh Cuong H. · Reviewed over 5 years ago
Nivea G. · Reviewed over 5 years ago
Ahlem m. · Reviewed over 5 years ago
Jittisak S. · Reviewed over 5 years ago
Guys, this is the second time i do this lab and it's really bad bad written and super confusing lab. To start, it may be necessary to access gScript settings to turn on BQ API (i had to spend a lot time trying here and there until i find this was OFF). Then, it's really super super confusing all this wording. You guys may, for instance, take code lines to provide instructions as they move forward (place this code at line x because it will bla bla bla), or sketch where things goes in a map so people can figure it out the where things go and the why they need to be done that way. I place it amongst top 3 most frustrating labs i've ever done. Thanks.
Américo A. · Reviewed over 5 years ago
We do not ensure the published reviews originate from consumers who have purchased or used the products. Reviews are not verified by Google.