Visualising data and creating reports

@LewisK 

I make extensive use of Google Sheets and Document Studio to generate the reports. I have been able to do all the formulas and calculations (granted it took some time to figure out the Google-way for some of them) i need in Sheets and then merge the data into an output report.

I have been trying enough spare time to resolve issues like dynamic spider graphs, as well as other chart types, that require the refresh of the data in the Google Slide (merge document) for a graph that is embedded. the trigger is normally that you have to trigger the update in the Google Slide to refresh the linked data and that is the problem that i am trying to resolve with the help of the creator of Document Studio and Google support.

One of the ways that i am trying to explore for a client now is to use Google Data Studio to create a 'dashboard' that does the visualizations over top of the Google Sheet that Typeform dumps into. If this will work the way the client wants, the user will submit the typeform and will receive an email 'shortly' with a link to the dashboard. The client's CRM will send out an email to the user with the link to the dashboard and a passcode they can use in conjunction with their email address to log into the dashboard and see their results.

They also receive a pdf report generated with a table of their results and some canned 'overall results from all participants' graphs - for an initial comparison while they are waiting for their access to the dashboard. This part is done with Sheets and Document Studio.

I will let folks know in the community when i figure out the graphing stuff..

@Mittyy123 Definitely take a look at the suggestions above from @john.desborough !

@LewisK - great to hear!

suggest you create the static images in a google drive, and then create a separate tab that has the ‘answerkey’ in one column and then the link to the image file. 

in your reporting tab, you can do the lookup on the ‘result’ (ie the ‘answerkey’ i mentioned - ie if answerkey greater than 3 then vlookup on imagetab, using the answerkey value and get the result from the nth column to the right of the lookup column)  and pull in the appropriate RAG status image. 

here’s one example that i did for a client: note the array formula and the vlookup

cheers

des

@Liz I’ll share what I can Liz, some of it is client work

@LewisK - depends on what you mean… if i want to have a data marker ie {{first.name}} end up in the Slide or Doc in bold, red font, then i put the marker into the document and then highlight and set it the same as you would any other text. 

if you want to use the ‘conditions’ of the logic to choose which image you want to show in the document relative to the data, then you need to have the images in the sheet as a field value. If you want to use static images in the document, you can paste the image in or should be able to paste in a link .. 

i am guessing at the context but if you can provide more detail maybe i/we can be more precise

des

I am struggling with this too. Any ideas? I may need to find another platform. :(