Restrict quick filter to last 4 months
Hi Team,
I would need below filter to be restricted to last 4 months. The filter drop down should display last 4 months including latest month.
Attached .twbx
-
1. Re: Restrict quick filter to last 4 months
1 of 1 people found this helpfulYou could Edit Data Source Filters of the secondary source and set the filter to only return the Top X (4 in this case) values.
-
2. Re: Restrict quick filter to last 4 months
1 of 1 people found this helpfulHi Andrew,
Thanks for the reply.
I think you have added "Start Date" also as part of blending due to which I'm loosing existing functionality i.e., select a month from drop down then the report/dashboard shows last 4 months data.
Could you try with attached please?
Please find attached the .twbx file.
-
3. Re: Restrict quick filter to last 4 months
1 of 1 people found this helpfulCreate this calculation in the PRIMARY source and put in the filter, set to True.
ATTR([Start Date]) > DATEADD('month',-4,ATTR([Secondary].[Start Date]))
AND ATTR([Start Date]) <= ATTR([Secondary].[Start Date])
-
4. Re: Restrict quick filter to last 4 months
Hi Andrew,
Sorry, I think I was not clear what I was looking for.
There are 2 different requirements
1. In the report, show last 4 month data depends on the month we choose from the filter.
Ex: if I choose May-2018 from the drop down filter the text table should show the data for last 4 months (May,Apr,Mar,Feb-2018)
2. At the same time, in drop down filter show just last 4 months
Ex: If my latest date is Jul-2018 then show Jul,Jun,May,Apr-2018
-
5. Re: Restrict quick filter to last 4 months
2 of 2 people found this helpfulOK - do both things I have suggested and you should be good.
1. Add the data source filter to the secondary limiting the values to the top 4
2. build the calculated field in the primary source, drag to the filters shelf and set to True.
ATTR([Start Date]) > DATEADD('month',-4,ATTR([Secondary].[Start Date]))
AND ATTR([Start Date]) <= ATTR([Secondary].[Start Date])
-
-
7. Re: Restrict quick filter to last 4 months
Hi Andrew,
Just an observation, I've implemented as you suggested it works so great. But I see 'Null' in drop down is there any way to remove it please.
-
8. Re: Restrict quick filter to last 4 months
1 of 1 people found this helpfulWith blending I don't think there's any way to get rid of the Null in the filter
-
