I filter my data using a date filter shown below.
Then I create a Single Value Chart for my sales index using filtered data.
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.