2 Replies Latest reply on Nov 3, 2018 8:20 PM by Jennifer VonHagel

# To show the values as per the flags.

Consider we have the requirement like below.

My requirement is to find show the date,group,customer name,customer rank,experience/fresher in the report where the group should contain freshers (like group 3) and combination of fresher and experience (like group 1).It should eliminate the group with all experienced people(like group 2).Kindly help me to build the logic

 Date Group Customer Name Customer Rank Experience/Fresher 1-Jan-18 1 AAA 1 F BBB 2 E CCC 1 E DDD 1 F EEE 1 F 1-Jan-18 2 AAAB 1 E BBBC 2 E CCCD 3 E DDDE 1 E EEEF 1 E 1-Jan-18 3 AAAB 1 F BBBC 2 F CCCD 3 F DDDE 1 F EEEF 1 F

@@

Header 1Header 2Header 3Header 4Header 5Header 6

 Date Group Customer Name Customer Rank Experience/Fresher 1-Jan-18 1 AAA 1 F BBB 2 E CCC 1 E DDD 1 F EEE 1 F 1-Jan-18 2 AAAB 1 E BBBC 2 E CCCD 3 E DDDE 1 E EEEF 1 E 1-Jan-18 3 AAAB 1 E BBBC 2 E CCCD 3 E DDDE 1 E EEEF 1 E
• ###### 1. Re: To show the values as per the flags.

Hello Meher,

If you are still seeking assistance with this question, please upload a Tableau Packaged workbook.  Please see - Packaged workbooks: when, why, how for assitance.

Regards

Patrick

• ###### 2. Re: To show the values as per the flags.

Hi Meher,

Assuming that within each date and group, a Customer can only be assigned F or E (not both), I would do something like the following.  As Patrick mentioned, it would be helpful to have sample data in a .twbx; keep in mind this logic isn't tested. Also keep in mind that FIXED calculations need to be crafted thoughtfully in respect to other filters that may also be in the view.

{ FIXED date, group : MAX(Experience/Fresher = 'F') }

This groups your data by date and group, then for that date and group returns TRUE if F appears at all in the group, and FALSE if it does not appear at all in the group. You can put this calculation on the filter shelf and set it to TRUE.

Best,

Jennifer