-
1. Re: Show only filtered dates in Parameter Calendar
Nagarajan K Nov 28, 2019 11:03 PM (in response to Chaitanya Kulkarni)Hi @ Kulkarni
Good Noon
How are you?
Like
You want - Based on date selection -show chart for last 15 days right?
Thanks
Nagarajan K
-
2. Re: Show only filtered dates in Parameter Calendar
Chaitanya Kulkarni Nov 28, 2019 11:11 PM (in response to Nagarajan K)Nope, I'm looking to only show last 15 day's in the calendar when using the Parameter as a date filter.
Regards,
CK
-
3. Re: Show only filtered dates in Parameter Calendar
Nagarajan K Nov 28, 2019 11:25 PM (in response to Chaitanya Kulkarni)-
Last 15 Days.twbx 7.4 MB
-
-
4. Re: Show only filtered dates in Parameter Calendar
Chaitanya Kulkarni Nov 28, 2019 11:27 PM (in response to Nagarajan K)Can't open the file.
Can you attach the file in 10.5 version or 2018.3?
-
5. Re: Show only filtered dates in Parameter Calendar
Nagarajan K Nov 28, 2019 11:33 PM (in response to Chaitanya Kulkarni) -
6. Re: Show only filtered dates in Parameter Calendar
amar savale Nov 28, 2019 11:42 PM (in response to Chaitanya Kulkarni) -
7. Re: Show only filtered dates in Parameter Calendar
amar savale Nov 28, 2019 11:45 PM (in response to Chaitanya Kulkarni)Hi,
Please find the workbook.
Thanks,
Amar D. Savale
-
8. Re: Show only filtered dates in Parameter Calendar
Chaitanya Kulkarni Nov 29, 2019 12:15 AM (in response to amar savale)Hi Amar,
Thanks for the reply.
My concern is to show only those days' in the calendar when using Parameter and not to show all the other dates.
Regards,
CK
-
9. Re: Show only filtered dates in Parameter Calendar
Mike Cheng Nov 29, 2019 1:10 AM (in response to Chaitanya Kulkarni) -
10. Re: Show only filtered dates in Parameter Calendar
Chaitanya Kulkarni Nov 29, 2019 1:27 AM (in response to Mike Cheng)Hi Mike
Thanks for the reply.
What happens if a user goes in the start date, will he/she be able to see only those last 15 days?
-
11. Re: Show only filtered dates in Parameter Calendar
Mike Cheng Nov 29, 2019 1:37 AM (in response to Chaitanya Kulkarni)Hi
I am not sure what you mean by "if a user goes in the start date", can you explain more?
mike
-
12. Re: Show only filtered dates in Parameter Calendar
Tharanga Gunawardena Nov 29, 2019 1:59 AM (in response to Chaitanya Kulkarni)Hi,
As I understood you want to disable or hide other days from the calendar except last 15 days?
is that what you want?
if so I don't think that it will be possible with the inbuilt calendar module as you cannot customize the parameter calendar other than fixing range of dates but it will not be dynamic and you will have to set min and max dates manually every time.
regards,
Tharanga
-
13. Re: Show only filtered dates in Parameter Calendar
Chaitanya Kulkarni Nov 29, 2019 4:52 AM (in response to Tharanga Gunawardena)Okay
-
14. Re: Show only filtered dates in Parameter Calendar
Sayali Sapkar Nov 29, 2019 5:57 AM (in response to Chaitanya Kulkarni)Hi Chaitanya,
According to your requirement, if you always want 15 days previous to current day, I think your 'end date' parameter would always be fixed.
For this, instead of using 2 parameters, 15 days can be shown using a filter, as a date range or as a multiple value dropdown.
(OR as per your requirements.)
This way might be considered.
You may refer this in below images. I used superstore data for it.
for date range, I have fixed the end date, which would be in your case, 'current date'.
The calculation I used is as below, in that, you should use today() in place of hardcoded date.
order date would be any of your referred date field.
I have also attached workbook for your reference.
Regards,
Sayali
-
temp.twbx 29.4 KB
-