4 Replies Latest reply on May 18, 2016 5:57 AM by Eshwar Prasad

Common Members for 6 months

Eshwar Prasad May 18, 2016 4:29 AM

Hi I have requirement like below.

i need to find out the members list who are there in all 6 months, means who is coming continuously for 6 months.

can any one help me?

1. Re: Common Members for 6 months

Tharashasank Davuluru May 18, 2016 5:26 AM (in response to Eshwar Prasad)

Hi,

Attache sample data or sample workbook.

Based on your question calculation need to be some thing like this: IF DATEDIFF('day', [time or date],[End Date])<=180 THEN [field] END. Place this in filter and select true.
Like Show 0 Likes(0)

Actions
2. Re: Common Members for 6 months

Tharashasank Davuluru May 18, 2016 5:29 AM (in response to Eshwar Prasad)

Hi,

Attache sample data or sample workbook.

Based on your question calculation need to be some thing like this: IF DATEDIFF('day', [time or date],[End Date])<=180 THEN [field] END. Place this in filter and select true.
Like Show 0 Likes(0)

Actions
3. Re: Common Members for 6 months

Tharashasank Davuluru May 18, 2016 5:30 AM (in response to Eshwar Prasad)

Hi,

Attache sample data or sample workbook.

Based on your question calculation need to be some thing like this: IF DATEDIFF('day', [time or date],[End Date])<=180 THEN [field] END. Place this in filter and select true.
Like Show 0 Likes(0)

Actions
4. Re: Common Members for 6 months

Eshwar Prasad May 18, 2016 5:57 AM (in response to Tharashasank Davuluru)
Hi PFA work book

Book1.twbx 1,010.6 KB
Like Show 0 Likes(0)

Actions

Tableau Community Forums