In the sample super store,how to get customers buying only furniture and not office supplies or technology [closed]

General Tech Technology & Software 2 years ago

0 2 0 0 0 tuteeHUB earn credit +10 pts

5 Star Rating 1 Rating

Posted on 16 Aug 2022, this text provides information on Technology & Software related to General Tech. Please note that while accuracy is prioritized, the data presented might not be entirely correct or up-to-date. This information is offered for general knowledge and informational purposes only, and should not be considered as a substitute for professional advice.

Take Quiz To Earn Credits!

Turn Your Knowledge into Earnings.

tuteehub_quiz

Answers (2)

Post Answer
profilepic.png
manpreet Tuteehub forum best answer Best Answer 2 years ago

In tableau for its sample super store dataset,I need to get the exclusive customers who buy only furniture and not office supplies and technology.

Want to display the exclusive customer names and their sales.

profilepic.png
manpreet 2 years ago

You can put Customer on the Filter shelf and on the condition tab, use the following formula min([Category] = "Furniture") For boolean expressions, True > False, so MIN(condition) is true if and only if condition is true for every record. MIN() for booleans can thus be read as "every()" and MAX() can be read as "any()"

If you work with this group of customers a lot, you might want to define a set of Customers that only buy furniture, instead of a filter. There are lots of ways to think of sets, but one is just as a saved named filter.


0 views   0 shares

No matter what stage you're at in your education or career, TuteeHub will help you reach the next level that you're aiming for. Simply,Choose a subject/topic and get started in self-paced practice sessions to improve your knowledge and scores.