-
1. Re: Default Filter Selection to Max Value
Norbert MaijoorDec 4, 2017 12:56 AM (in response to ameya v)
Hi Ameya,
Find my approach as reference below and stored in attached workbook version 10.3 located in the original thread
Approach is explained here
1. P1. Select Date
2. D1. Select Date conversion:
IF [P1. Select Date]="Today" THEN TODAY()
ELSE DATE([P1. Select Date])
END
3. M1. YTD:
if DATEDIFF('year',[D1. Select Date conversion],[date])=0
and [date]<[D1. Select Date conversion] then [value] END
4. Drag required objects to the indicated locations and show parameter control
Regards,
Norbert
-
Default today_nalmai_10.3.twbx 17.5 KB
-
-
2. Re: Default Filter Selection to Max Value
Tushar More Dec 4, 2017 1:16 AM (in response to ameya v)1 of 1 people found this helpful -
3. Re: Default Filter Selection to Max Value
zhang chenggong Dec 20, 2017 1:31 AM (in response to ameya v)Hi Ameya,
I have the same question with you。
NOW,I hava two charts that I want to use date linking together。One of the chart showed values in the last thirteen months,and the other showed values in the last month 。IF I click one of the last thirteen months in the first chart ,the last chart can change。(tableau v 9.0)
-
4. Re: Default Filter Selection to Max Value
zhang chenggong Dec 20, 2017 1:35 AM (in response to Tushar More)Hi,Tushar,I can't find the option in V10.2
-
5. Re: Default Filter Selection to Max Value
Norbert MaijoorDec 20, 2017 1:39 AM (in response to zhang chenggong)
1 of 1 people found this helpfulHi Zhang,
It's available from V10.3 onwards:(
Regards,
Norbert
-
6. Re: Default Filter Selection to Max Value
zhang chenggong Dec 20, 2017 7:06 PM (in response to Norbert Maijoor) -
7. Re: Default Filter Selection to Max Value
Norbert MaijoorDec 20, 2017 11:04 PM (in response to zhang chenggong)
Hi Zhang,
Could you share a workbook in .tbwx format?
Regards,
Norbert
-
8. Re: Default Filter Selection to Max Value
zhang chenggong Dec 21, 2017 1:23 AM (in response to Norbert Maijoor)THANK YOU Norbert,I have uploaded it in tableau public。
https://public.tableau.com/profile/zhangcg3377#!/vizhome/1_5162/1
-
9. Re: Default Filter Selection to Max Value
zhang chenggong Dec 24, 2017 8:00 PM (in response to zhang chenggong)Jamieson Christian can you help me
-
10. Re: Default Filter Selection to Max Value
Norbert MaijoorDec 25, 2017 4:25 AM (in response to zhang chenggong)
Hi Zhang,
Find my approach as reference below and stored in attached workbook version 10.4 located in the original thread
1. Define Parameter PERIOD based on PERIOD change Data type to string and add entry "Today".
Move entry "Today" up to the highest position and set is to Current Value
2. D1.Date converter: if [PERIOD Parameter]="Today" then today() else date([PERIOD Parameter]) end
3. D2. Display: datediff('year',[PERIOD],[D1.Date converter])=0 and [PERIOD]<=[D1.Date converter]
4. Drag required objects to the indicated locations (both sheets) and filter D2. Display on True & show parameter control
Regards,
Norbert
-
工作簿1_nalmai_10.4.twbx 39.0 KB
-