-
1. Re: Restrict quick filter to last 4 months
Andrew Watson Aug 13, 2018 3:24 AM (in response to Sai Sri B)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
Sai Sri B Aug 13, 2018 4:17 AM (in response to Andrew Watson)Hi 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.
-
Book1.twbx 459.2 KB
-
-
3. Re: Restrict quick filter to last 4 months
Andrew Watson Aug 13, 2018 5:46 AM (in response to Sai Sri B)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
Sai Sri B Aug 13, 2018 7:30 AM (in response to Andrew Watson)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
Andrew Watson Aug 13, 2018 7:42 AM (in response to Sai Sri B)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])
-
6. Re: Restrict quick filter to last 4 months
Sai Sri B Aug 13, 2018 10:43 PM (in response to Andrew Watson)Thanks much Andrew. This is what I was looking for.
-
7. Re: Restrict quick filter to last 4 months
Sai Sri B Aug 13, 2018 10:53 PM (in response to Andrew Watson) -
8. Re: Restrict quick filter to last 4 months
Andrew Watson Aug 14, 2018 12:22 AM (in response to Sai Sri B)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
-
9. Re: Restrict quick filter to last 4 months
Sai Sri B Aug 14, 2018 12:47 AM (in response to Andrew Watson)Thank you Andrew