2 Replies Latest reply on Sep 25, 2012 7:30 AM by Janet Shen

Groups

manideepak ganapathi Aug 23, 2012 1:25 PM

I have a column A which is a measure/string variable that takes three different values a1, a2 and a3. Column B is visualized on Tableau as a line graph.Field B is a calculated field which is an aggregation based on the quick filters applied using other columns.

Now the question is, I need to make two groups G1 and G2 which will have values (a1,a2) and (a1,a2, a3) that come from column A respectively. I need to create two line graphs of B one for group G1 and the other for G2. The problem here is, a1, a2 being part of both G1 and G2 does not allow me to make two different groups on Tableau. Please suggest a workaround.

A quick reply is appreciated.

Thanks,

ManiDeepak

1. Re: Groups

Russell Christopher Aug 23, 2012 5:43 PM (in response to manideepak ganapathi)

Hi Manideepak -

You'll probably get a quicker response if you post some sample data in a Tableau packaged workbook as well as a visual "mock up" of what you'd like your result to look like - It's a bit difficult to understand what you're trying to get accomplished "visually" based on the "verbal" description.

Good luck!
Like Show 0 Likes(0)

Actions
2. Re: Groups

Janet Shen Sep 25, 2012 7:30 AM (in response to manideepak ganapathi)
Hello Manideepak,

When such groups overlap, it is necessary to create separate calculated fields with IF/ELSE statements. To demonstrate, I have attached an example Tableau Workbook and Excel file.

Let me know if you have any questions!

185194.xlsx 10.3 KB

OverlappingGroupsExample.twbx.zip 33.9 KB

1 of 1 people found this helpful
Like Show 0 Likes(0)

Actions

Go to original post

Tableau Community Forums

Groups

1. Re: Groups

2. Re: Groups

Actions

More Like This