Data Investigation -- ADVISE PLZ

Question

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

4701229_GQD0WC1Y.xlsx

Thableaus · Accepted Answer

Hi @SaâdEnnassiri

Would something like this work?

Cheers,

grazitti_sapna · Accepted Answer

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