You can control click the values that you want and can use keep only , it will be like filtering the data for specific values.
Are u looking for that.
1 of 1 people found this helpful
Make calculation LAST() <= 7 and put it on filter as TRUE, so it will only keep last 8 weeks since LAST() starts with 0,1,2...,6,7
Hope it helps
i think your view is something similar to the image below and you want to show only 8 bars in the view.
please follow below procedure
drag date field to filter shelf and you will get pop up window, select individual dates option.
by default custom value list radio button is selected, change it to select from list radio button, select last 8 values you want to see in bar chart
Thanks for your response. seems i was not clear in my question. I don't want to manually select last 8 weeks every time my dashboard is refreshed at a weekly level. Want to make a default feature which selects last 8 weeks
It fulfills my requirement