5 Replies Latest reply on Dec 2, 2018 10:26 PM by Zhouyi Zhang

How to set filter value based on another condition?

Yun Feng Dec 2, 2018 6:49 PM

I have data like this：

标题 1	标题 2	标题 3
DATE	GROUP	VALUE
20180101	1	3
20180102	2	2
20180103	3	7
20180104	1	5
20180105	2	4
20180106	3	9
20180107	1	1
20180108	2	2
20180109	3	5

I have created a date range filter, if I select date range as 20180103 - 20180108, the max date is 20180108 and its group is 2, so I want to bar plot all the group 2 value between 20180103 - 20180108 which are (20180105, 2, 4) and (20180108, 2, 2), how to do this?

Thanks!

1. Re: How to set filter value based on another condition?

Zhouyi Zhang Dec 2, 2018 7:23 PM (in response to Yun Feng)

Hi, Yun

Please try this calculaiton

[Group] = {Fixed:Max(if [Date] = {Fixed :max([Date])} then [Group] end)}

This will give you the flag of the rows you expected.
and for your date range filter, please right click and select add to context.

Hope this helps

ZZ
1 of 1 people found this helpful
Like Show 0 Likes(0)

Actions
2. Re: How to set filter value based on another condition?

Yun Feng Dec 2, 2018 9:45 PM (in response to Zhouyi Zhang)

Hi，Zhouyi

Thank you! I am new to Tableau, so I first create a calculation, and drag it to filter, and select it True?

Thanks!
Like Show 0 Likes(0)

Actions
3. Re: How to set filter value based on another condition?

Zhouyi Zhang Dec 2, 2018 10:12 PM (in response to Yun Feng)

Yes, Yun. and if you add date as filter, make sure you right click the date filter and select add it to context.

ZZ
Like Show 0 Likes(0)

Actions
4. Re: How to set filter value based on another condition?

Yun Feng Dec 2, 2018 10:18 PM (in response to Zhouyi Zhang)

Thanks！
Like Show 0 Likes(0)

Actions
5. Re: How to set filter value based on another condition?

Zhouyi Zhang Dec 2, 2018 10:26 PM (in response to Yun Feng)

no worries,

ZZ
Like Show 0 Likes(0)

Actions

Go to original post

Tableau Community Forums

How to set filter value based on another condition?

1. Re: How to set filter value based on another condition?

2. Re: How to set filter value based on another condition?

3. Re: How to set filter value based on another condition?

4. Re: How to set filter value based on another condition?

5. Re: How to set filter value based on another condition?

Actions

More Like This