For your second question, you'd like to add another filter with dates? Would something like this be helpful?
http://community.retool.com/t/how-to-write-a-query-that-filters-data-using-a-date-range-component/13361