How to calculate quarter to quarter increase in LookML?

I filter my data using a date filter shown below.

19369594-aec4-4a3c-8ac3-03b616b08203.png

Then I create a Single Value Chart for my sales index using filtered data.

03231ecc-3feb-4b93-9ada-6c6517956700.png

What I want to do is to create a quarter-to-quarter ratio and show it in the charts using comparison settings.For example, in this case, the quarter-to-quarter ratio is the ratio of the sales from November 6th to November 10th to the sales from November 1st to November 5th, which is the previous date range with the same length as the currently selected date range.

The rendering style I want looks like this.

cb283b03-7345-4e1a-b071-9c17418263b9.png
0 0 287
0 REPLIES 0
Top Labels in this Space
Top Solution Authors