Hi. Total Looker newb, here.
A company I work for uses a SaaS product which uses Looker as a back end.
Said company has asked me to produce a weekly report of credit card transactions by customers who have—as of each new report date—spent above certain set thresholds in the last twelve months.
I can do this in Google Sheets quite easily using in the inbuilt QUERY function but I’m completely new to Looker and its query language. I had a look through the reference syntax and I swear my eyes started to water.
Nonetheless I would like to generate this report within Looker and save it as a ‘Look’, if possible. Doing this would save me the hassle of downloading the transaction list as a CSV and importing it into Google Sheets which will inevitably slow to a crawl and crash repeatedly under the size of the table (many tens of thousands of rows).
I found a button marked “Calculations”:
Which opened this modal box:
Is this where I do the thing that does the stuff to the table?
Also, can someone hold my hand through this?
I’ve started gorging myself on Looker tutorials on YouTube.
Hi Herman,
Can you show us a sample of your data, what is the desired output, and even the query you usually use in Google Sheets?
Hi, Dawid.
I will create a small mock-up of the data and a sample Google Sheet.
Stay tuned!