Time/Timestamp within the query

Thanks Antony. I’ve read a lot of post and documentation, but it’s not very clear to me how the I can use the macro in “where” statement, and so on. So, being able to use normal query maybe for me it could be easier.
For example I would like to show all the data from the beginning till now grouped by year without being affected by the time searching.
as you can better understand here Same dashboard with more relative time panel - #11 by donatod