3 Replies Latest reply on Dec 12, 2016 6:21 PM by Shinichiro Murakami

# Find the total and Percentage of Total

Hello All,

I am seeking help to find the percentage of each dimension and sum of dimensions (Rows). Please see attached worksheet. Any help would be appreciated. Thanks

GG

• ###### 1. Re: Find the total and Percentage of Total

Gurpreet,

It's quite trouble some to convert string to time format and calc.

I converted all the measure to "hour" unit.

I just pick up example on Talk time. Others are similar to it.

[Talk Time (Time Format)]

datetime((dateparse("HH:mm:ss",[Talk Time])))

[Talk Hours]

float(([Talk Time (Time Format)]-date(#1899/12/30#)))*12

//  usually converting days to hours is "24", but in this case am/pm is default and I needed to use "12". Don't know background in detail.

FYI

[Total hours]

[Talk Hours %]

sum([Talk Hours])/sum([Total])

Thanks,

Shin

2 of 2 people found this helpful

## Great! Thank you Shin, I really appreciate your help. I am sorry, I have another question. I am also looking to find the average of each column and want to recognize the agent who is over the average of each column. I forgot to mention. I am just talking about % worksheet. Thanks again.

• ###### 3. Re: Find the total and Percentage of Total

Gurpreet

That requires quite a bit steps.

This is just a example for "talk hours" but you need to do same thing for all measures.

[Talk Hours AVG]

{sum([Talk Hours])}/{fixed :countd([Agent Name])}

[Talk Hours vs AVG]

sum([Talk Hours])-attr([Talk Hours AVG]) > 0

I mean set different color for each measure is one of the most troublesome task in Tableau.

Hope at some version hit kind of table view creation becomes much more easier.

Go this link for detail explanations.

Such a simple view, it required 100 steps!! - Having Multiple KPIs - - Still Struggling with Excel ?? <Tableau's Room>

Thanks,

Shin