Google Spreadsheet Post #1458
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Dec-29, 2013
question by Universal Account (http://productforums.google.com/forum/?zx=5j3c3wqmicu2#!mydiscussions/docs/g0NE6a0Mtcw)
How to combine filter and google clock in a way that works?
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Dec-29, 2013
question by Universal Account (http://productforums.google.com/forum/?zx=5j3c3wqmicu2#!mydiscussions/docs/g0NE6a0Mtcw)
How to combine filter and google clock in a way that works?
Why does the following not work?
=COUNTA(FILTER(CK:CK;CK:CK=" Open", A:A>=datetime '"&text(GoogleClock()-30," yyyy-MM-dd HH:mm:ss")&"'))
I know I can get a rolling 30-day view of data using query and google clock in this manner. Can I not use it in this format for filtering data? Related, how do I intelligently filter by month only - also based on Google Clock. For instance, always show 1 month back in relation to current time? I see many examples for calculating static date ranges in this forum; I have not encountered any using filter.
Appreciate any help immensely!
-Jonathan
---
Example spreadsheet:
https://docs.google.com/ spreadsheet/ccc?key= 0AorgbSDvY2oTdHg5bVlaYXl2Q3lxN E9sWVVqcXlXMmc&usp=sharing
FormResponses comes from a Google Form. It contains Enrollment Info for a school. Imagine it has 500 entries, with dates spread across months and years.
------------------------------------------------------------------------------------------------------------------------------------------------------
No comments:
Post a Comment