Skip to main content
Topics#Tableau Desktop & Web AuthoringTableau Community Forums Member (Inactive)'s Question
Tableau Community Forums Member (Inactive) (Salesforce) asked in #Tableau Desktop & Web Authoring
Aug 14, 2013, 11:45 AM

Filter on a group and date

Hello!

 

Could you please help me to create a calculated field? Please look at the file attached below.

 

The dilemma is the following:

 

I have clients [CLIENT] on different days [DAY] of the week: from Monday to Sunday. They buy different products [PRODUCT] each day: Apple, Banana, Bread, Milk, etc.

 

I need to look only at the clients that buy Apples on Monday, and see what they buy on Tuesday.

 

Thanks!

Julia

My example.twb.zip
9 answers
  1. Tableau Community Forums Member (Inactive) (Salesforce)
    Aug 14, 2013, 5:59 PM

    Julia,

     

    Take a look at the attached workbook providing a solution to your problem.

     

    This solution involves creating another data connection to your data source and then using the 'Custom SQL' option to select only Monday Apple buying clients:

    Julia, Take a look at the attached workbook providing a solution to your problem.

     

    and then blending the original data source to the new data source in order to filter the data set to only show the clients you are interested in.

     

    Hope this helps!

    Daniel.

Write an answer...
0/9000