-
15. Re: Show only filtered dates in Parameter Calendar
Chaitanya Kulkarni Dec 1, 2019 10:36 PM (in response to Sayali Sapkar)Hi Sayali,
Thank you for the reply.
Yes, I would like to only display the last 15 day's of current date.
Could you please attach the workbook in lower version 10.5 or 2018.3, so that I can have give a deep dive in it?
Regards,
CK
-
16. Re: Show only filtered dates in Parameter Calendar
Sayali Sapkar Dec 1, 2019 11:22 PM (in response to Chaitanya Kulkarni)Hi Chaitanya,
PFA attached workbook with v 2018.3
If that helps, please mark this reply as 'helpful' & 'answered'.
Regards,
Sayali
-
temp_v2018.3.twbx 28.4 KB
-
-
17. Re: Show only filtered dates in Parameter Calendar
Nagarajan K Dec 2, 2019 12:30 AM (in response to Chaitanya Kulkarni)Hi @ Kulkarni
Please follow the link
Get Idea
Thanks
Nagarajan K
-
18. Re: Show only filtered dates in Parameter Calendar
Chaitanya Kulkarni Dec 2, 2019 1:37 AM (in response to Sayali Sapkar)Sorry, I'm still not able to open the file.
Cold you please attach in 10.5?
Regards,
CK
-
19. Re: Show only filtered dates in Parameter Calendar
Nagarajan K Dec 2, 2019 2:00 AM (in response to Chaitanya Kulkarni)Hi @ Kulkarni
Please check the workbook
Thanks
Nagarajan K
-
Last 15 Days_v2018.3.twbx 7.3 MB
-
-
20. Re: Show only filtered dates in Parameter Calendar
Sayali Sapkar Dec 2, 2019 2:56 AM (in response to Chaitanya Kulkarni)Please refer to this attachment.
OR
I'll elaborate my calculations step by step.
step 1: Create a calculated field that calculates the previous 15th date.
step 2: Create a calculated field for comparing the dates greater than or equal to temp date
step 3: Create a true/false condition as below, allow only true values and set it as a context filter
step 4: Create a copy of the field from step 2 and drag that copy to filters shelf. Select individual dates -> select 'Null' and exclude it -> OK -> Set it as a context filter.
step 5: Drag the field from step 2 on the filter shelf -> range of dates (if you want to show date range) and 'Next' -> 'Starting date' (it will keep end date fixed) -> OK and show that filter.
if you want to show a multiple value drop-down, then :
Drag the field from step 2 on the filter shelf -> Individual dates and 'Next' -> All -> OK and show that filter.
step 6: Click on the dropdown in the top right corner of the filter and set 'All values in context'
Regards,
Sayali
-
temp_v10.5.twbx 28.1 KB
-