I'm trying to create a function on a secondary sheet to monitor which of my blogs are getting the most traffic. Currently my secondary sheet has a formula that works to show me blogs that have over 400 views that works:
=QUERY('Raw data'!A3:AM,"Select * Where AF > 400)
However, I want to modify this to allow me to simply write in A1 the view threshold I wish to see, that will dictate the entire spreadsheet without having to change the formula each time but the formula I thought would work, doesn't:
=QUERY('Raw data'!A3:AM,"Select * Where AF > A1).
What am I doing wrong?