Content in Tableau Community Forums

How to drop original columns in tableau desktop

tableaucommunity@tableau.com — Thu, 10 Apr 2014 04:13:21 GMT

Hi Guys

My trouble is like this. I got a huge workbook need to be sent to customer. But before sending. I need drop some columns in desktop. Actually these columns are in the extracts and not calculated fields. I can only hide them rather than drop then. If regenerate these workbooks will be really painful because they are huge workbooks.

Please shed some light on this. Thanks.

Build flexible calculation

tableaucommunity@tableau.com — Thu, 27 Jun 2013 04:22:39 GMT

The issue we meet is a little complicate.I will start with a example.

We have data like this.To simplify question.let us assume there are only 6 rows in the table.

Product Period Count Profit

A 201301 null 20

A 201301 30 null

A 201302 30 null

A 201302 null 20

------------------------------------------------------------

B 201301 null 30

B 201302 null 30

B 201302 30 null

....

We need build a calculate field "Profit rate", which logic is:

for each Product,computing

Sum(Profit)/Sum(Count)

So for Product = A, "Profit rate" in 201301 should be 20/30 = 80%

"Profit rate" of 201301 and 201302 should be (20+20)/(30+30)

That is just perfect situation.

But in some month.Only one of the Profit or Count exist.Like product B,See the record marked in red,it only have Profit in 201301,

Count is missing.So "Profit rate" in 201301 should be zero.in 201302 should be 30/30 = 100%,But when computing "Profit rate" for 201301 and 201302.The "Profit rate" should be (30 + 30) / 30 = 200 %.Here comes the question,When only one of Count and Profit exist we want to ignoring the records of this month when computing "Profit rate" in multiple Period.So The right "Profit rate" of 201301 and 201302 should be 30/30 = 100%.

I really don't want to make that in database level.So I wonder if there is some solution exist in tableau.

I have tried to count records for each product.and setting table calculation partition by Product.Then constrain the record count distinct equal to 2.

But this table calculation need add more columns in level of detail than I need in report.Now I am really stuck by this issue.

I hope I explain my issue clearly. by the way,I think tableau may need to enhance partition function.when I need to make some partition calculation.I need to put partition column on level of detail.That design is really not flexible in my opinion.Maybe it's not design for that,But it's really great to make it better.

Look forward to everyone's advice.

A complex filter cascading.

tableaucommunity@tableau.com — Thu, 20 Jun 2013 05:45:08 GMT

Hi Guys

I am working on a filter cascading function now.

Basically I want to make something like that.

There are two filters

Filters A

- Worldwide

- Region

- By Country

Filters B

- Worldwide

- Country A

- Country B

- ....

When "WorldWide" is selected,Filters B will only show item "WorldWide".

When "Region" is selected,Filters B will only show Countries belong to that region.

When "By Country" is selected,Filters B will show all the countries except "WorldWide"

Enclosed workbook is currently what I have done.I use parameter and one calculate field to make that function.

It work well in low record count.But in my case,unfortunately，we have too many records in which case using this method will bring performance issue.I think that is because complex condition calculation.

I need some advice about tuning the performance or give another solution for dealing with this kind of requirement.

Thanks

Is there some method can let people manipulate multiple select filter

tableaucommunity@tableau.com — Wed, 19 Jun 2013 03:02:30 GMT

Our team encounter one requirement about multiple select filter.

For example,there are 5 items in the multiple select filter.

Fruit

Apple

Banana

Pear

Grape

What we want to make is:

When select one of the (Apple,Banana,Pear,Grape),You can't select Fruit anymore.

When you select Fruit.You can't select the sub item.

That is a bit like when you manipulate web component using javascript or something else.

Can tableau do the same staff?

You may suggest to build a hierarchy.But our data structure decide that we need put Fruit and its subitem together.I know that's not elegant structure.But that is currently we have.

So I look for help here.Looking forward to your advice.

filter on custom value list

tableaucommunity@tableau.com — Thu, 13 Jun 2013 02:45:37 GMT

Hi guys

I am using custom value list filter in my report.I got a question here.when query some values on a custom value list.It will show all values in the database.Is there any way can let me filter that list,So it just present relevant values?

I have search that question in the knowledge base.But I didn't find a answer.

I think it's more convenience to let user only see relevant values.