So, what is your question in relation to Tableau? Are you asking for calculations that will separate these out?
If each grouping should be unique, then something like the following should get you close (you could also write one calc for each group, if that makes more sense).
IF [Group]='group a' and [Vendor]='' then 'Group A' // this assumes Tableau interprets the blank cell as an empty string
elseif [Group]='group b' and [Vendor]='' then 'Group B' //same assumption here
elseif [Group]='group a' and [Vendor]='vendor A' then 'Group A + Vendor A'
elseif [Group]='group b' and [Vendor]='vendor A' then 'Group B + Vendor A'
// if you want an ELSE condition, you can add it here.
//You can write more of these if needed for more scenarios in your data but in your sample data the above scenarios are all I found
Note that '' is two single quotes or an empty string, not double quotes
Let me know if this is not what you are looking for. I wasn't sure based on your text description what you are trying to accomplish--you are always better off bringing your data inside Tableau, and posting a packaged workbook on the forum, as well as a detailed description of what you are trying to accomplish and what you've already done on your own in an attempt to get there--AND a clear description of the end result you are looking for (or a mock up).
see attached, what I want to see is:
group A : 123
Group B: 1234567
Tried your idea but it didnt group as expected.
I don't see an attachment; Will check back again tomorrow if you do upload a workbook. Thanks
I had a quick look at your question and excel file, but I don't quite understand how you expect to get the result you want with that data:
Tickets 123, 1234 and 12345 all are exclusively in Group A.
Ticket 1234567 has two combinations; one is group a and the other is group a + Vendor A.
Ticket 12345678 has 3 combinations; group a, group b + vendor A, group b
Ticket 12345678910 has 2 combinations; group a, group b
Essentially you have nothing that identifies the 3 tickets that you want in Group B as different from the others in every instance. So using your rules you would see the following:
ticket Group Vendor Result 123 group a - Group A 1234 group a - Group A 12345 group a - Group A 1234567 group a vendor A Group B 12345678 group a - Group A 12345678910 group a - Group A 123 group a - Group A 1234 group a - Group A 12345 group a - Group A 1234567 group a - Group A 12345678 group b vendor A Group B 12345678910 group b - Group B 123 group a - Group A 1234 group a - Group A 12345 group a - Group A 1234567 group a - Group A 12345678 group b - Group B 12345678910 group b - Group B
and your final view would be:
group A : 123
Group B: 1234567
Does this make sense?
I didn't bother to look at the data in the Excel file closely, so thank you Nicolas - this is a good example of how (for me) a packaged workbook really helps users help each other much more readily in Tableau.
hopefully the attachment works this time!
I changed a bit of it around so I could explain myself better:
Assume all the tickets are owned by one group (in this case "blue")
tickets are assigned to different groups or vendors as needed
I want to separate the data (tickets) into 2 sections: one with just group A only (no vendors, no other groups assigned) and the second everything else...
Assume a life cycle of : ticket is opened and assigned, it also maybe assigned to other groups for work or vendors as needed. so a ticket may have multiple assignment groups or vendors.
ticket # 12345678910
assigned group: group A
assigned group: group B
*this ticket had 2 assigned groups to it.*
owner : blue
first assigned group : group A
I hope this helps, I could keep adding more fields but im hoping this makes sense.
multygroup.twbx 21.5 KB
OK Jason, I think I understand what you want. Essentially if there are no instances of a ticket being in multiple groups or vendors then it would fall under Group A, otherwise it would be categorized as group B. See attached for my solution:
Let me know if this was what you were looking for..
multygroup - Nic.twbx 21.3 KB
here is another level added (see attached):
say there is a sub group (in this case 1,2 or 3) and you wanted to separate group A from group B further by saying anything with sub group greater than 1 is group B
the results should only show group A being 123 and the rest under group B
multygroup - Nic.twbx 19.7 KB