I have a dataset containing registrations of events. I need to be able to create a new cateogry from the Primary category, where some of the events are grouped together, and others are not. Basically, I need to be able to make diagrams where A Enquiry and B Enquiry are shown, but the rest of the events in primary category are added together. Does that make sense? Can I do this with a calculation or?
@Lise Kok Petersen
Hi, you can use:
New Primary Category:
IF [Primary category]="A enquiry" OR [Primary category]="B enquiry" THEN [Primary category] ELSE "Other" END
If this post resolves the question, would you be so kind to "Select as Best"?. This will help other users find the same answer/resolution and help community keep track of answered questions. Thank you.
Regards,
Diego
Tableau Ambassador
