Content in Tableau Community Forums

Dynamically modify the subjects of the subscription emails sent by Tableau Server

tableaucommunity@tableau.com — Mon, 25 Aug 2014 14:16:25 GMT

I am using the subscription feature to send out daily reports. I would like to be able to have the Tableau Server include the date of the report in the subject line of the email it sends.

Thank you!

Intentionally Duplicating Records in an Extract

tableaucommunity@tableau.com — Wed, 27 Aug 2014 20:12:28 GMT

I have a data set like this in an extract (pulled from a Netezza DB):

FruitID	Fruit	Inventory
A	Apple	12
B	Banana	18
C	Grape	2
D	Cherry	45

I want to duplicate the entire data set and add an additional column to differentiate the two sets of records, such that the final data set looks like this:

FruitID	Fruit	Inventory	Source
A	Apple	12	1
B	Banana	18	1
C	Grape	2	1
D	Cherry	45	1
A	Apple	12	2
B	Banana	18	2
C	Grape	2	2
D	Cherry	45	2

Can I do this all within Tableau using extracts or do I have to have this done as a new Table in the Netezza DB itself?

Thank you!

Data Reshape problem

tableaucommunity@tableau.com — Thu, 06 Feb 2014 06:03:12 GMT

I have a data source (Direct DB... NOT RESHAPEABLE) with records that list transaction like this:

BUYERID	VOLUME	SELLERID
TOM	1	****
****	2	JANE
JANE	3	TOM
MARK	5	MARK
PAUL	1	MARK
TOM	1	ALLAN

I would like to create a View in Tableau that looks like this:

ID	TOT_VOLUME
TOM	5
****	3
JANE	5
MARK	11
PAUL	1
ALLAN	1

I can create two separate views that show me SUM(VOLUME), one using the BUYERID and the other using the SELLERID. Can I create one view that combines the two taking into consideration that:

a) The same ID may be in both the BUYERID and the SELLERID for the record.

b) not all BUYERID are in SELLERID and vice versa.

Thank you!

How do I set up a filter using an OR of two dimensions

tableaucommunity@tableau.com — Thu, 30 Jan 2014 23:34:50 GMT

Lets say I have just 3 fields

Name1 Name2 Volume

A B 10

A D 20

B A 30

C D 10

A A 10

B D 20

I want to sum the Volume number when A is in “Name1” OR “Name2”. Total of 70.

Thank you!