Same issue here, if I could query a different timerange for a dashboard variable, the problem would be solved.