How can I query only the last 7 days to be able to automate and present a weekly report?
Please help!.. Iโm now using this query where Column B is the date
=QUERY(โVEHICLE LOG SHEETโ!B5:M, โselect B, D, E, F, G, H, I, J, K, L, M where C = โT-191โโ)
Hi
+Walton Atizado Check out slices.
I think you should be able to do all you want with
a slice.
Hi +Walton Atizado. I am not an expert but I would try a slice with an expression like this one as
Row Filter Condition:
AND ( TODAY()<=[ColB_label] + 7 ; [ColC_label] = โT-191โ)
User | Count |
---|---|
36 | |
33 | |
27 | |
23 | |
18 |