Need help in getting past 4 quarters of data based on the filter selection on dashboard.
In the source table, we have data at quarter level ( have Year and Quarter column with other measures)
Example:
Year Quarter Orders
2019 1 100
2019 2 200
2019 3 50
2019 4 90
2020 1 300
On the dashboard, have a filter in which user will select the Quarter ( this filter will have values like 2019Q1,2019Q2 so on which utilizes a dimension built using Year and Quarter)
Once the user selects the Quarter, then the visualization should only show past 4 quarters of data.
New to looker, any help here would be appreciated.