Figures Above & Approaching Threshold For Last Twelve Months

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.

0 2 91
2 REPLIES 2

Dawid
Participant V

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!

Top Labels in this Space
Top Solution Authors