Data Investigation -- ADVISE PLZ

[SaâdEnnassiri]

Good morning gents, 

Can I ask again for your help, I would like to find or to check waiters which has at least 18 checks OR at least 75 people in total for all their checks.

I tried something like but I end up with doubles which I can not understand my self.

Can i advise please?

Thx a lot

[Thableaus · Accepted solution]

Hi @SaâdEnnassiri 

Would something like this work?

Cheers,

[grazitti_sapna · Accepted solution]

Hi @SaâdEnnassiri,

Try using the Summarize to group by based on Waiters and take the count of waiters as well and then filter the records as per your condition. Below are the screenshots and attached is the workflow for the same. 

  

I hope it helps with your problem

[SaâdEnnassiri]

Thx a lot Sir.