7 Replies Latest reply on Oct 4, 2018 11:27 PM by suman kumar

# basic questions on tableau

1. Populate column “Combined Address” by combining the address in column C, E F, G & H, each separate by a “, ” – example “702 SW 8th St, Bentonville, Arkansas, Benton, United States”
2. Fill in the “Sig Number” in column B for each company from the sheet Sig Number – use a formula to do so
3. What is the average revenue per headcount, based on ‘Revenue USD’ for each company. Ignore companies where head count is not given. Add this as a column between ‘Sig Number’ and ‘Address’

suman kumar need your help for these three questions as I am having  some doubt in these three

Regards

sakshi

• ###### 1. Re: basic questions on tableau

Hi Sakshi,

1. Fill in the “Sig Number” in column B for each company from the sheet Sig Number – use a formula to do so

Where is Signumber sheet I didn't find any in the excel attached

BR,

NB

• ###### 2. Re: basic questions on tableau
 Company Sig Number Boyd 2 AMC Networks Inc. 3 Progress 12 Westell 12 Textron Inc. 13 Body 13 Cecil Bancorp, Inc. 14 Golub 15 La Quinta Holdings Inc. 16 Netreit, Inc. 16 Dxp 16 Liveperson, Inc. 17 Essendant 17 Vista 21 Vishay 23 The 23 Salem Media Group, Inc. 24 Triplepoint Venture Growth Bdc Corp. 24 The 24
• ###### 3. Re: basic questions on tableau

Question:1

=CONCATENATE(C2,", ",+E2,", ",F2,", ",G2,", ",H2)

see below image for result

Question:2

Please use VLOOKUP function and bring all company sig number in main sheet from sheet Sig Number.

Please let me know if you need help in vlookup as well.

Question:3

I didn't get your third question.

Best

Suman

• ###### 4. Re: basic questions on tableau

ques-3 )What is the average revenue per headcount, based on ‘Revenue USD’ for each company. Ignore companies where head count is not given.

file is attached in excel format

• ###### 5. Re: basic questions on tableau

Hi Sakshi,

Please use AVERAGE function for this question.

Best

Suman

• ###### 6. Re: basic questions on tableau

it will be like this?

• ###### 7. Re: basic questions on tableau

Yes, Exactly.