My requirement is a line chart where X-axis is plotted with week(six weeks) and Y-axis is a measure. Now the week is put up as a dashboard filter, where choosing on a particular week(say week 10), then the weeks that’s displayed on the x-axis should have the previous six weeks’ data(wk5 - wk10).
Could you please help me with any posts with such a requirement?
One option is to:
I think that would work for any data set up. Depending on your data structure, you may be able to code a more elegant solution in the LookML.