Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Geeks,
I have a requirement to include new filter with below values in drop down,
Past 10 weeks
Past 8 weeks
Past 6 weeks
Past 4 weeks.
If i select on any of above value corresponding Past 10 weeks data need to be selected in week filter w.r.to current week filter selected value or No value selected in week filter.
e.g)
1. If week 40 is chosen and if i select Past 10 weeks value, then following weeks needs to be selected
40,39,38,37,36,35,34,33,32,31
2.) If no week is selected and If i select Past 10 weeks, then past 10 weeks data to be selected basis current week number
Thanks in advance!
Hi,
I think you can add some flag columns into your calendar table. 4 new flag columns for each your selections.
For example: Flag 10 weeks, and flag your dates if before 10 weeks, put 1 to that cell. Same for the other 3 week columns.
Create an inline table; put your 4 different selections. In the app side, put your inline table as a filter. And in your expression use set expression; if Past 10 weeks selected, in expression put something like {<Flag 10 weeks = {1}>}.
I think it'll work.