How to create QTD chart with QTD change in Looker with BQ

[rohit_shoppertr]

Hi team,

I am trying to create QTD period over period analysis by which this kind of chart would be there:

Can you please guide me how to create a chart for latest Quarter up to latest date vs. last quarter same day.

For example today is 5th day of this quarters so 

5 days sales of this quarter/5 days of last completed quarter

Thanks in advance

Rohit