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.