Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
sagar_vij99
Creator
Creator

Chart expression using Set Analysis for multiple dimensions

Hi,

I am making a chart which have 2 dimensions one is Tenure_of_Emp and other is Business_Unit. I am using an expression where I am counting number of employees (count([person number]). Now i want the chart to show % of employees as per different buckets on business unit dimension. As of now i used count([person number])/count({1}[person number]) and it gives me 100% for every bucket(i understand it sums up as per business unit but not as total).

below is the screenshot of chart. can anyone help me out here?


Capture.JPG

12 Replies
tresesco
MVP
MVP

May be:

count([person number])/count( TOTAL {1}[person number])

sagar_vij99
Creator
Creator
Author

Hi B,

Thanks for the reply but there is some change. Lets say i have 3 different teams with 10 employees each and they have their respective tenure buckets. Now team A has 3 people in bucket x, 3 in y and 4 in z. With your solution it is calculating percentage for team A taking 30 as denominator but ideally it should take 10(bcz team size of A is 10).

is it possible to create an expression for the same..??

tresesco
MVP
MVP

Could you post a qvw with sample data?

sunny_talwar

Try this may be

Count([person number]/Count(TOTAL <Business_Unit> [person number])

or this, if you need the set analysis

Count([person number]/Count({1} TOTAL <Business_Unit> [person number])

sagar_vij99
Creator
Creator
Author

Hi Sunny,

Thanks for the reply but it will not solve my problem. Consider the below case:

Lets say i have 3 different teams with 10 employees each and they have their respective tenure buckets. Now team A has 3 people in bucket x, 3 in y and 4 in z. With my solution it is calculating percentage for team A taking 30 as denominator but ideally it should take 10(bcz team size of A is 10). So for team A percentages should be 30% for bucket x, 30% for y and 40% for z. but my solution is giving 10% for x and so on because it is taking 30(which i sum of 3 teams ) for team A.

is it possible to create an expression for the same..??

Anonymous
Not applicable

Hi Sagar,

can you please try below formula:

Num(Sum(emps)/sum(TOTAL <team> emps),'##0%')

I have used below test data:  

teambucketemps
teamA>103
teamA5-103
teamA3-54
teamB>103
teamB5-103
teamB3-54
teamC>103
teamC5-103
teamC3-54
sunny_talwar

Did you even try the expressions I gave you? Cause when you say Team, you mean Business_Unit, then my expression should have worked for you. If they have not, then I would suggest posting a sample so that we can take a look at what you might be doing wrong.

sagar_vij99
Creator
Creator
Author

Hi Sunny,

thanks for replying but it did not work exactly. Here is the data i am working on and i want the chart to be same as pasted in my post. please assist me here.

 

Person NumberPlatform FunctionTenure Bucket
013409Global Technology 5-10
014714Insurance Ops❤️
014727Global Technology 5-10
014786Insurance Ops>10
014795Insurance Ops>10
014797Insurance Ops>10
014798Insurance Ops>10
014799Insurance Ops>10
014817Global Operations (Others)>10
015122Insurance Ops>10
015348Insurance Ops>10
015563Insurance Ops>10
015602Insurance Ops>10
015622Insurance Ops>10
015878Insurance Ops>10
015919Insurance Ops>10
015926Insurance Ops>10
015933Insurance Ops>10
016115Enterprise Data Management>10
016172Insurance Ops>10
016299Insurance Ops>10
016421Insurance Ops>10
016422Insurance Ops>10
016437Insurance Ops>10
016480Insurance Ops>10
016527Insurance Ops>10
016563Insurance Ops 3-5
016621Insurance Ops>10
016685Global Operations (Others)>10
016809Enterprise Data Management>10
016810Insurance Ops>10
016812Insurance Ops>10
016826Insurance Ops>10
017031Insurance Ops 5-10
017033Insurance Ops 5-10
017040Insurance Ops 5-10
017152Enterprise Data Management 5-10
017214Insurance Ops 5-10
017242Insurance Ops 5-10
017269Insurance Ops 5-10
017273Insurance Ops❤️
017336Insurance Ops 5-10
017354Insurance Ops 5-10
017378Enterprise Data Management 5-10
017513Global Operations (Others) 5-10
017518Insurance Ops 5-10
017567Enterprise Data Management 5-10
017569Insurance Ops 5-10
017605Insurance Ops 5-10
017639Insurance Ops 5-10
017658Global Operations (Others) 5-10
017682Insurance Ops 3-5
017741Insurance Ops 5-10
017751Insurance Ops 5-10
017768Global Operations (Others) 5-10
017855Insurance Ops 5-10
017879Insurance Ops 5-10
017939Insurance Ops 5-10
018112Insurance Ops 5-10
018295Enterprise Data Management 5-10
018454Insurance Ops 5-10
018522Insurance Ops❤️
018530Insurance Ops 5-10
018531Insurance Ops 5-10
018532Insurance Ops 5-10
018554Enterprise Data Management 5-10
018595Insurance Ops 5-10
018677K&E 5-10
018684Enterprise Data Management 5-10
018699Insurance Ops 5-10
018706Insurance Ops 5-10
018707Insurance Ops 5-10
018715Insurance Ops 5-10
018716Insurance Ops 5-10
018727Insurance Ops 5-10
018729Enterprise Data Management 5-10
018766Enterprise Data Management 5-10
018827Insurance Ops 5-10
018830Insurance Ops 5-10
018886Insurance Ops 5-10
019001Insurance Ops 5-10
019017Insurance Ops 5-10
019024Insurance Ops 5-10
019041Insurance Ops 5-10
019059Global Technology 5-10
019087Insurance Ops 5-10
019145Insurance Ops 5-10
019155Insurance Ops 5-10
019164Insurance Ops 5-10
019196Insurance Ops 5-10
019197Insurance Ops 5-10
019213Insurance Ops 5-10
019235Insurance Ops 5-10
019261Insurance Ops 5-10
019290Insurance Ops 5-10
019348Global Operations (Others) 5-10
019360Insurance Ops 5-10
019420Enterprise Data Management 5-10
019425Insurance Ops 5-10
019427Insurance Ops 5-10
019436Enterprise Data Management 5-10
019458Insurance Ops 5-10
019503Global Technology❤️
019544Insurance Ops 5-10
019545Insurance Ops 5-10
019565Insurance Ops 5-10
019584Insurance Ops 5-10
019589Insurance Ops 5-10
019655Insurance Ops 5-10
019672Insurance Ops 5-10
019711Insurance Ops 5-10
019730Insurance Ops 5-10
019746Insurance Ops 5-10
019747Insurance Ops 5-10
019764Insurance Ops 5-10
019777Insurance Ops 5-10
019800Insurance Ops 5-10
019805Insurance Ops 5-10
019806Insurance Ops 5-10
019818Insurance Ops 5-10
019848Insurance Ops 5-10
019859Insurance Ops 5-10
019867Insurance Ops 5-10
019869Insurance Ops 5-10
019890Insurance Ops 5-10
019891Insurance Ops 5-10
019895Insurance Ops 5-10
019913Insurance Ops 5-10
019914Insurance Ops 5-10
019930Insurance Ops 5-10
019942Global Operations (Others) 5-10
019955Insurance Ops 5-10
019958Insurance Ops 5-10
019967Insurance Ops 3-5
019971Insurance Ops 3-5
019973Insurance Ops 3-5
019982Insurance Ops 3-5
020027Insurance Ops 3-5
020033Insurance Ops 3-5
020067Insurance Ops 3-5
020070Insurance Ops 3-5
020077Global Operations (Others) 3-5
020082Insurance Ops 3-5
020084Insurance Ops 3-5
020085Insurance Ops 3-5
020098Insurance Ops 3-5
020104Insurance Ops 3-5
020115Global Operations (Others) 3-5
020122Insurance Ops 3-5
020132Insurance Ops 3-5
020139Insurance Ops 3-5
020154Enterprise Data Management 3-5
020163Insurance Ops 3-5
020164Insurance Ops 3-5
020166Global Operations (Others) 3-5
020194Enterprise Data Management 3-5
020196Enterprise Data Management 3-5
020217Insurance Ops 3-5
020222Insurance Ops 3-5
020230Insurance Ops 3-5
020240Insurance Ops 3-5
020254Insurance Ops 3-5
020269Insurance Ops 3-5
020274Insurance Ops 3-5
020294Enterprise Data Management 3-5
020301Insurance Ops 3-5
020304Insurance Ops 3-5
020305Enterprise Data Management 3-5
020313Insurance Ops 3-5
020331Insurance Ops 3-5
020361Enterprise Data Management 3-5
020388Insurance Ops 3-5
020417Insurance Ops 3-5
020421Insurance Ops 3-5
020430Insurance Ops 3-5
020455Insurance Ops 3-5
020474Insurance Ops 3-5
020501Insurance Ops 3-5
020502Insurance Ops 3-5
020518Insurance Ops 3-5
020581Enterprise Data Management 3-5
020605Insurance Ops 3-5
020616Insurance Ops 3-5
020622Enterprise Data Management 3-5
020623Insurance Ops 3-5
020638Insurance Ops 3-5
020654Insurance Ops 3-5
020655Insurance Ops 3-5
020660K&E 3-5
020673Insurance Ops 3-5
020684Insurance Ops 3-5
020687Insurance Ops 3-5
020695Insurance Ops 3-5
020696Enterprise Data Management 3-5
020718Insurance Ops 3-5
020724Insurance Ops 3-5
020729Insurance Ops 3-5
020736Insurance Ops 3-5
020739Insurance Ops 3-5
020740Insurance Ops 3-5
020743Insurance Ops 3-5
020762Insurance Ops 3-5
020796Insurance Ops 3-5
020808Insurance Ops 3-5
020839Global Technology 3-5
020840Insurance Ops 3-5
020860Insurance Ops 3-5
020867Insurance Ops 3-5
020896Insurance Ops 3-5
020971Insurance Ops 3-5
020985Global Technology 3-5
021049Insurance Ops 3-5
021056Insurance Ops 3-5
021061Insurance Ops 3-5
021066Insurance Ops 3-5
021082Global Technology 3-5
021126Insurance Ops 3-5
021128Insurance Ops 3-5
021129Insurance Ops 3-5
021130Insurance Ops 3-5
021134Global Technology 3-5
021151Enterprise Data Management 3-5
021179Insurance Ops 3-5
021186Insurance Ops 3-5
021214Insurance Ops 3-5
021222Insurance Ops 3-5
021223Insurance Ops 3-5
021224Insurance Ops 3-5
021231Insurance Ops 3-5
021247Global Operations (Others) 3-5
021248Insurance Ops 3-5
021303Insurance Ops 3-5
021317Insurance Ops 3-5
021321Enterprise Data Management 3-5
021323Insurance Ops 3-5
021347Insurance Ops 3-5
021348Insurance Ops 3-5
021349Global Technology 3-5
021354Insurance Ops 3-5
021356Insurance Ops 3-5
021383Insurance Ops 3-5
021384Insurance Ops 3-5
021386Insurance Ops 3-5
021387Insurance Ops 3-5
021389Insurance Ops 3-5
021390Insurance Ops 3-5
021391Insurance Ops 3-5
021393Insurance Ops 3-5
021394Insurance Ops 3-5
021400Insurance Ops 3-5
021415Insurance Ops 3-5
021416K&E❤️
021419Global Technology 3-5
021427Insurance Ops❤️
021428Insurance Ops 3-5
021441Insurance Ops❤️
021442Insurance Ops❤️
021447Insurance Ops 3-5
021456Insurance Ops 3-5
021481Insurance Ops 3-5
021491Enterprise Data Management❤️
021498Enterprise Data Management❤️
021499Global Technology 3-5
021537Enterprise Data Management❤️
021557Insurance Ops 3-5
021604Insurance Ops❤️
021619Insurance Ops❤️
021621Global Technology❤️
021639Insurance Ops 3-5
021642Insurance Ops❤️
021644Insurance Ops❤️
021655Global Technology❤️
021658Insurance Ops❤️
021662Insurance Ops❤️
021665Insurance Ops 3-5
021669Insurance Ops 3-5
021670Insurance Ops 3-5
021684Insurance Ops❤️
021685Insurance Ops❤️
021719Insurance Ops❤️
021722Insurance Ops❤️
021741Insurance Ops❤️
021791Insurance Ops❤️
021813Insurance Ops❤️
021824Insurance Ops❤️
021827Insurance Ops❤️
021835Insurance Ops❤️
021852Insurance Ops❤️
021853Insurance Ops❤️
021854Insurance Ops❤️
021862Insurance Ops❤️
021874Insurance Ops❤️
021907Insurance Ops❤️
021908Insurance Ops❤️
021930Global Operations (Others)❤️
021940Insurance Ops❤️
021942Insurance Ops❤️
021960Insurance Ops❤️
021965Insurance Ops❤️
021968Insurance Ops❤️
021975Global Operations (Others)❤️
021996Insurance Ops❤️
021997Insurance Ops❤️
021998Insurance Ops❤️
021999Global Technology❤️
022010Insurance Ops❤️
022026Insurance Ops❤️
022032Global Technology❤️
022035Insurance Ops❤️
022040Insurance Ops❤️
022062Global Operations (Others)❤️
022109Insurance Ops❤️
022131Insurance Ops❤️
022153Insurance Ops❤️
022156Insurance Ops❤️
022157Insurance Ops❤️
022158Insurance Ops❤️
022169Insurance Ops❤️
022180Insurance Ops❤️
022183Insurance Ops❤️
022198Global Technology❤️
022201Insurance Ops❤️
022202Insurance Ops❤️
022206Global Technology❤️
022210Global Operations (Others)❤️
022215Insurance Ops❤️
022226Insurance Ops❤️
022234Global Operations (Others)❤️
022259Enterprise Data Management❤️
022263Insurance Ops❤️
022264Insurance Ops❤️
022275Insurance Ops❤️
022283Insurance Ops❤️
022290Insurance Ops❤️
022291Insurance Ops❤️
022303Insurance Ops❤️
022310Insurance Ops❤️
022312Insurance Ops❤️
022313Enterprise Data Management❤️
022314Insurance Ops❤️
022327Insurance Ops❤️
022336Insurance Ops❤️
022338Insurance Ops❤️
022345Insurance Ops❤️
022346Insurance Ops❤️
022347Insurance Ops❤️
022348Insurance Ops❤️
022349Insurance Ops❤️
022353Insurance Ops❤️
022354Insurance Ops❤️
022356Insurance Ops❤️
022357Insurance Ops❤️
022361Insurance Ops❤️
022363Insurance Ops❤️
022369Insurance Ops❤️
022386Insurance Ops❤️
022387Enterprise Data Management❤️
022396Insurance Ops❤️
022401Global Technology❤️
022417Insurance Ops❤️
022419Insurance Ops❤️
022426Global Operations (Others)❤️
044685Global Technology 5-10
046017Global Technology❤️
048222Insurance Ops❤️
049319Insurance Ops❤️
049373Insurance Ops❤️
049374Insurance Ops❤️
049423Insurance Ops❤️
049435Global Operations (Others)❤️
049636Insurance Ops❤️
049925Insurance Ops❤️
049947Insurance Ops❤️
049949Insurance Ops❤️
049950Insurance Ops❤️
049951Insurance Ops❤️
049952Insurance Ops❤️
049954Insurance Ops❤️
049964Insurance Ops❤️
050119Insurance Ops❤️
050120Insurance Ops❤️
050121Insurance Ops❤️
050246Global Operations (Others)❤️
050303Insurance Ops❤️
050321Insurance Ops❤️
050363Insurance Ops❤️
050502Insurance Ops❤️
100273Insurance Ops❤️
100285Insurance Ops❤️
100297Insurance Ops❤️
103005Insurance Ops❤️
103234Insurance Ops❤️
103249Enterprise Data Management❤️
103250Insurance Ops❤️
103251Insurance Ops❤️
103452Insurance Ops❤️
103453Insurance Ops❤️
103454Insurance Ops❤️
103512Global Technology❤️
103560Enterprise Data Management❤️
103621Insurance Ops❤️
103630Insurance Ops❤️
103632Insurance Ops❤️
103633Insurance Ops❤️
103634Insurance Ops❤️
103635Insurance Ops❤️
103637Insurance Ops❤️
103638Insurance Ops❤️
103640Insurance Ops❤️
103641Insurance Ops❤️
103642Insurance Ops❤️
103644Insurance Ops❤️
103645Insurance Ops❤️
103646Insurance Ops❤️
103647Insurance Ops❤️
103654Insurance Ops❤️
103655Insurance Ops❤️
103657Insurance Ops❤️
103659Insurance Ops❤️
103660Insurance Ops❤️
103661Insurance Ops❤️
103662Insurance Ops❤️
103663Insurance Ops❤️
103665Enterprise Data Management❤️
103666Enterprise Data Management❤️
103667Enterprise Data Management❤️
103670Insurance Ops❤️
103671Insurance Ops❤️
103672Insurance Ops❤️
103673Insurance Ops❤️
103674Insurance Ops❤️
103675Insurance Ops❤️
103676Insurance Ops❤️
103677Insurance Ops❤️
103705Insurance Ops❤️
103706Insurance Ops❤️
103707Insurance Ops❤️
103709Insurance Ops❤️
103710Insurance Ops❤️
103711Insurance Ops❤️
103712Insurance Ops❤️
103714Insurance Ops❤️
103715Insurance Ops❤️
103716Insurance Ops❤️
103717Insurance Ops❤️
103747Global Operations (Others)❤️
103748Insurance Ops❤️
103749Insurance Ops❤️
103751Insurance Ops❤️
103752Insurance Ops❤️
103755Insurance Ops❤️
103849Insurance Ops❤️
103850Insurance Ops❤️
103851Insurance Ops❤️
103852Insurance Ops❤️
103855Insurance Ops❤️
103856Insurance Ops❤️
103857Insurance Ops❤️
103859Insurance Ops❤️
103898Insurance Ops❤️
103937Insurance Ops❤️
103941Insurance Ops❤️
103993Insurance Ops❤️
103994Insurance Ops❤️
103995Insurance Ops❤️
104007Insurance Ops❤️
104085Insurance Ops❤️
104137Insurance Ops❤️
104138Insurance Ops❤️
104139Insurance Ops❤️
104320Global Technology❤️
104358Insurance Ops❤️
104524Global Technology❤️
104582Insurance Ops❤️
104637Insurance Ops❤️
104692Insurance Ops❤️
104693Insurance Ops❤️
104694Insurance Ops❤️
104700Insurance Ops❤️
104847Insurance Ops❤️
104851Insurance Ops❤️
104958Insurance Ops❤️
104959Insurance Ops❤️
104967Insurance Ops❤️
104970Insurance Ops❤️
105130Enterprise Data Management❤️
105177Insurance Ops❤️
105211Insurance Ops❤️
105212Insurance Ops❤️
105234Insurance Ops❤️
105236Insurance Ops❤️
105241Insurance Ops❤️
105243Insurance Ops❤️
105246Insurance Ops❤️
105247Insurance Ops❤️
105395Insurance Ops❤️
105476Insurance Ops❤️
105481Enterprise Data Management❤️
105484Enterprise Data Management❤️
105514Insurance Ops❤️
105521Enterprise Data Management❤️
105525Enterprise Data Management❤️
105530Enterprise Data Management❤️
105531Insurance Ops❤️
105533Global Operations (Others)❤️
105547Global Operations (Others)❤️
105549Insurance Ops❤️
105552Insurance Ops❤️
105590Insurance Ops❤️
105608Global Operations (Others)❤️
105635Insurance Ops❤️
105666Global Technology❤️
105776Insurance Ops❤️
105792Insurance Ops❤️
105835Global Operations (Others)❤️
105866Global Operations (Others)❤️
105887Insurance Ops❤️
105888Insurance Ops❤️
105905Insurance Ops❤️
105954Insurance Ops❤️
105960Insurance Ops❤️
105972Insurance Ops❤️
105979Insurance Ops❤️
105994Insurance Ops❤️
106001Insurance Ops❤️
106003Insurance Ops❤️
106045Insurance Ops❤️
106119Enterprise Data Management❤️
106126Insurance Ops❤️
106149Insurance Ops❤️
106151Insurance Ops❤️
106199Insurance Ops❤️
106216Insurance Ops❤️
106236K&E❤️
106300Global Operations (Others)❤️
106308Global Operations (Others)❤️
106311Global Operations (Others)❤️
106338Insurance Ops❤️
106353Insurance Ops❤️
106355Insurance Ops❤️
106357Insurance Ops❤️
106360Insurance Ops❤️
106362Insurance Ops❤️
106364Insurance Ops❤️
106368Insurance Ops❤️
106371Insurance Ops❤️
106373Insurance Ops❤️
106393Insurance Ops❤️
106395Insurance Ops❤️
106397Insurance Ops❤️
106399Insurance Ops❤️
106401Insurance Ops❤️
106418Insurance Ops❤️
106473K&E❤️
106599Enterprise Data Management❤️
106643Insurance Ops❤️
106657Insurance Ops❤️
106690Insurance Ops❤️
106715Insurance Ops❤️
106723Insurance Ops❤️
106724Insurance Ops❤️
106725Insurance Ops❤️
106727Insurance Ops❤️
106728Insurance Ops❤️
106729Insurance Ops❤️
106730Insurance Ops❤️
106731Insurance Ops❤️
106732Insurance Ops❤️
106745Insurance Ops❤️
106746Insurance Ops❤️
106747Insurance Ops❤️
106748Insurance Ops❤️
106749Insurance Ops❤️
106752Insurance Ops❤️
106754Insurance Ops❤️
106755Insurance Ops❤️
106756Insurance Ops❤️
106757Insurance Ops❤️
106759Insurance Ops❤️
106760Insurance Ops❤️
106764Insurance Ops❤️
106781Insurance Ops❤️
106822Global Operations (Others)❤️
106825Insurance Ops❤️
106826Insurance Ops❤️
106827Insurance Ops❤️
106829Insurance Ops❤️
106913Insurance Ops❤️
106914Insurance Ops❤️
106916Insurance Ops❤️
106917Insurance Ops❤️
106934Insurance Ops❤️
107017Insurance Ops❤️
107027Insurance Ops❤️
107029Global Operations (Others)❤️
107063Insurance Ops❤️
107065Global Operations (Others)❤️
107079Insurance Ops❤️
107081Insurance Ops❤️
107095Insurance Ops❤️
107149Insurance Ops❤️
107186Insurance Ops❤️
107190K&E❤️
107191K&E❤️
107244Insurance Ops❤️
107251Insurance Ops❤️
107255Insurance Ops❤️
107256Insurance Ops❤️
107257Insurance Ops❤️
107259Insurance Ops❤️
107261Global Operations (Others)❤️
107290Insurance Ops❤️
107354Insurance Ops❤️
107355Insurance Ops❤️
107407Enterprise Data Management❤️
107414Insurance Ops❤️
107434Enterprise Data Management❤️
107450Insurance Ops❤️
107451Insurance Ops❤️
107453Insurance Ops❤️
107455Insurance Ops❤️
107477Insurance Ops❤️
107478Insurance Ops❤️
107479Insurance Ops❤️
107484Insurance Ops❤️
107486Insurance Ops❤️
107545Insurance Ops❤️
107553Insurance Ops❤️
107565Insurance Ops❤️
107585Insurance Ops❤️
107611Insurance Ops❤️
107627Insurance Ops❤️
107631Insurance Ops❤️
107633Insurance Ops❤️
107658Insurance Ops❤️
107659Insurance Ops❤️
107660Insurance Ops❤️
107661Insurance Ops❤️
107699Insurance Ops❤️
107711Global Operations (Others)❤️
107726Global Technology❤️
107727Global Technology❤️
107784Insurance Ops❤️
107785Insurance Ops❤️
107788Insurance Ops❤️
107789Insurance Ops❤️
107790Insurance Ops❤️
107791Insurance Ops❤️
107792Insurance Ops❤️
107804Insurance Ops❤️
107806Insurance Ops❤️
107834Insurance Ops❤️
107905Global Operations (Others)❤️
107928Insurance Ops❤️
107937Insurance Ops❤️
107968Insurance Ops❤️
107995Insurance Ops❤️
107999Enterprise Data Management❤️
108000Enterprise Data Management❤️
108003Insurance Ops❤️
108027Insurance Ops❤️
108060Insurance Ops❤️
108088Insurance Ops❤️
108094Insurance Ops❤️
108128Insurance Ops❤️
108129Insurance Ops❤️
108158K&E❤️
108175Enterprise Data Management❤️
108176Enterprise Data Management❤️
108181Insurance Ops❤️
108187Enterprise Data Management❤️
108188Enterprise Data Management❤️
108235Enterprise Data Management❤️
108236Insurance Ops❤️
108272Insurance Ops❤️
108281Insurance Ops❤️
108287Global Technology❤️
108309Insurance Ops❤️
108310Insurance Ops❤️
108312Insurance Ops❤️
108314K&E❤️
108323Insurance Ops❤️
108344Insurance Ops❤️
108345Insurance Ops❤️
108355Insurance Ops❤️
108361Insurance Ops❤️
108362Insurance Ops❤️
108378Insurance Ops❤️
108384Insurance Ops❤️
108385Enterprise Data Management❤️
108388Insurance Ops❤️
108389Enterprise Data Management❤️
108413Enterprise Data Management❤️
108414Global Operations (Others)❤️
108421Insurance Ops❤️
108424Enterprise Data Management❤️
108430Insurance Ops❤️
108471Insurance Ops❤️
108473Enterprise Data Management❤️
108483Insurance Ops❤️
108484Insurance Ops❤️
108494K&E❤️
108578Insurance Ops❤️
108591K&E❤️
108595Enterprise Data Management❤️
108597Insurance Ops❤️
108667Insurance Ops❤️
108686Insurance Ops❤️
108779Insurance Ops❤️
108837Insurance Ops❤️
108893Enterprise Data Management❤️
108955Insurance Ops❤️
108958Insurance Ops❤️
108987Insurance Ops❤️
108989Insurance Ops❤️
109016Global Operations (Others)❤️
109148Global Operations (Others)❤️
109149Global Technology❤️
109152Insurance Ops❤️
109175Insurance Ops❤️
109235Global Operations (Others)❤️
109263K&E❤️
109311Insurance Ops❤️
109318Insurance Ops❤️
109322Insurance Ops❤️
109331K&E❤️
109337Insurance Ops❤️
109385Insurance Ops❤️
109391Enterprise Data Management❤️
109413Insurance Ops❤️
109414Insurance Ops❤️
109415Insurance Ops❤️
109419Insurance Ops❤️
109421Insurance Ops❤️
109429Insurance Ops❤️
109435Insurance Ops❤️
109438Insurance Ops❤️
109440Enterprise Data Management❤️
109470Insurance Ops❤️
109472Insurance Ops❤️
109489Insurance Ops❤️
109492Insurance Ops❤️
109521Insurance Ops❤️
109582Insurance Ops❤️
109607K&E❤️
109616Insurance Ops❤️
109618Insurance Ops❤️
109624Insurance Ops❤️
109625Enterprise Data Management❤️
109626Insurance Ops❤️
109651Global Technology❤️
109663Insurance Ops❤️
109734Insurance Ops❤️
109765Insurance Ops❤️
109766Insurance Ops❤️
109767Insurance Ops❤️
109768Insurance Ops❤️
109771Insurance Ops❤️
109773Insurance Ops❤️
109774Insurance Ops❤️
109775Insurance Ops❤️
109776Insurance Ops❤️
109777Insurance Ops❤️
109791Insurance Ops❤️
109793Global Operations (Others)❤️
109795Global Technology❤️
109796Global Technology❤️
109797Global Technology❤️
109798Global Technology❤️
109799Global Technology❤️
109800Global Technology❤️
109830Insurance Ops❤️
109831Insurance Ops❤️
109832Insurance Ops❤️
109833Insurance Ops❤️
109834Insurance Ops❤️
109835Insurance Ops❤️
109836Insurance Ops❤️
109837Insurance Ops❤️
109839Insurance Ops❤️
109843Insurance Ops❤️
109868Insurance Ops❤️
109869Insurance Ops❤️
109886Insurance Ops❤️
109887Insurance Ops❤️
109892Insurance Ops❤️
109893Insurance Ops❤️
109894Insurance Ops❤️
109896Insurance Ops❤️
109912Insurance Ops❤️
109913Insurance Ops❤️
109914Insurance Ops❤️
109917Insurance Ops❤️
109924Insurance Ops❤️
109982Global Technology❤️
109983Global Technology❤️
109985Insurance Ops❤️
110012Insurance Ops❤️
110014Insurance Ops❤️
110017Insurance Ops❤️
110030Insurance Ops❤️
110031Insurance Ops❤️
110062Insurance Ops❤️
110086Insurance Ops❤️
110089Insurance Ops❤️
110115Insurance Ops❤️
110172Insurance Ops❤️
110178Global Technology❤️
110185Global Technology❤️
110216Enterprise Data Management❤️
110217Enterprise Data Management❤️
110222Enterprise Data Management❤️
110224Insurance Ops❤️
110243Insurance Ops❤️
110244Global Technology❤️
110245Global Technology❤️
110247Global Technology❤️
110248Insurance Ops❤️
110278Global Technology❤️
110281Global Technology❤️
110282Global Technology❤️
110283Insurance Ops❤️
110290Global Technology❤️
110305Insurance Ops❤️
110370Global Technology❤️
110373Insurance Ops❤️
110379Global Technology❤️
110381Global Technology❤️
110418Insurance Ops❤️
110419Insurance Ops❤️
110420Enterprise Data Management❤️
110421Enterprise Data Management❤️
110427Global Technology❤️
110428Insurance Ops❤️
110435Insurance Ops❤️
110495Global Technology❤️
110506Global Operations (Others)❤️
110558Insurance Ops❤️
110587Global Technology❤️
110625Global Technology❤️
110642Insurance Ops❤️
110678Insurance Ops❤️
110708Enterprise Data Management❤️
110720Insurance Ops❤️
110735Global Technology❤️
110738Enterprise Data Management❤️
110741Global Technology❤️
110763Global Technology❤️
110781Global Technology❤️
110783Global Technology❤️
110883Insurance Ops❤️
110914Insurance Ops❤️
111001Insurance Ops❤️
111002Insurance Ops❤️
111006Insurance Ops❤️
111048Insurance Ops❤️
111049Insurance Ops❤️
111050Insurance Ops❤️
111052Insurance Ops❤️
111123Insurance Ops❤️
111189Insurance Ops❤️
111304Insurance Ops❤️
111472Global Technology❤️
111536Insurance Ops❤️
111538Insurance Ops❤️
111539Insurance Ops❤️
111540Global Technology❤️
111541Global Operations (Others)❤️
111542Insurance Ops❤️
111550Global Operations (Others)❤️
111631Insurance Ops❤️
111644Global Technology❤️
111691Insurance Ops❤️
111705Insurance Ops❤️
111719Insurance Ops❤️
111737Insurance Ops❤️
111755Enterprise Data Management❤️
111764Insurance Ops❤️
111766Insurance Ops❤️
111767Enterprise Data Management❤️
111769Insurance Ops❤️
111771Insurance Ops❤️
111779Insurance Ops❤️
111785Enterprise Data Management❤️
111815Global Technology❤️
111820Global Technology❤️
111821Global Technology❤️
111828Global Technology❤️
111829Insurance Ops❤️
111854Global Technology❤️
111885Insurance Ops❤️
111896Insurance Ops❤️
111899Insurance Ops❤️
111900Insurance Ops❤️
111901Insurance Ops❤️
111904Insurance Ops❤️
111914Insurance Ops❤️
111917Insurance Ops❤️
111921Insurance Ops❤️
111935Insurance Ops❤️
111941Global Operations (Others)❤️
111965Insurance Ops❤️
111984Global Technology❤️
111985Global Technology❤️
111987Insurance Ops❤️
111989Insurance Ops❤️
111990Insurance Ops❤️
111994Insurance Ops❤️
112013Insurance Ops❤️
112026Global Operations (Others)❤️
112036Insurance Ops❤️
112037Enterprise Data Management❤️
112038Insurance Ops❤️
112039Enterprise Data Management❤️
112045Insurance Ops❤️
112106Enterprise Data Management❤️
112124Enterprise Data Management❤️
112132Enterprise Data Management❤️
112157Insurance Ops❤️
112158Insurance Ops❤️
112167Insurance Ops❤️
112170Insurance Ops❤️
112172Global Technology❤️
112195Global Technology❤️
112232Insurance Ops❤️
112238Global Technology❤️
112283Insurance Ops❤️
112289Enterprise Data Management❤️
112328Insurance Ops❤️
112332Enterprise Data Management❤️
112333Global Operations (Others)❤️
112344Insurance Ops❤️
112349Insurance Ops❤️
112401Global Technology❤️
112435Insurance Ops❤️
112493Insurance Ops❤️
112525Insurance Ops❤️
112530Insurance Ops❤️
112539Insurance Ops❤️
112543Insurance Ops❤️
112545Insurance Ops❤️
112546Insurance Ops❤️
112547Insurance Ops❤️
112548Insurance Ops❤️
112567Global Technology❤️
112568Insurance Ops❤️
112605Insurance Ops❤️
112607K&E❤️
112609Insurance Ops❤️
112610Insurance Ops❤️
112646Insurance Ops❤️
112665Insurance Ops❤️
112678Insurance Ops❤️
112680Insurance Ops❤️
112681Insurance Ops❤️
112703Global Technology❤️
112713Global Operations (Others)❤️
112719Insurance Ops❤️
112724Insurance Ops❤️
112843Insurance Ops❤️
112845Global Technology❤️
112846Insurance Ops❤️
112849Global Operations (Others)❤️
112862Global Operations (Others)❤️
112863Insurance Ops❤️
112889Insurance Ops❤️
112914Insurance Ops❤️
112915Enterprise Data Management❤️
112926Global Operations (Others)❤️
112942Global Technology❤️
112945Insurance Ops❤️
112946Global Operations (Others)❤️
112947Insurance Ops❤️
112949Insurance Ops❤️
112959Insurance Ops❤️
112960Global Technology❤️
112964Global Technology❤️
112965Insurance Ops❤️
112977Global Technology❤️
112987Insurance Ops❤️
113008Insurance Ops❤️
113019Insurance Ops❤️
113022Insurance Ops❤️
113093Enterprise Data Management❤️
113106Global Operations (Others)❤️
113107Insurance Ops❤️
113121Insurance Ops❤️
113145Insurance Ops❤️
113148Global Technology❤️
113176Insurance Ops❤️
113190Insurance Ops❤️
113194Global Operations (Others)❤️
113205K&E❤️
113206Global Operations (Others)❤️
113208Insurance Ops❤️
113213Enterprise Data Management❤️
113234Enterprise Data Management❤️
113261Insurance Ops❤️
113278Insurance Ops❤️
113286Global Technology❤️
113298Insurance Ops❤️
113310Insurance Ops❤️
113311Insurance Ops❤️
113312Insurance Ops❤️
113313Insurance Ops❤️
113317Enterprise Data Management❤️
113329Insurance Ops❤️
113366Insurance Ops❤️
113427Insurance Ops❤️
113439Insurance Ops❤️
113453Global Operations (Others)❤️
113481Enterprise Data Management❤️
113509Insurance Ops❤️
113548Insurance Ops❤️
113557Insurance Ops❤️
113562Insurance Ops❤️
113620Insurance Ops❤️
113798Insurance Ops❤️
113870Insurance Ops❤️
113887Insurance Ops❤️
113896Global Technology❤️
113907Insurance Ops❤️
113930Global Operations (Others)❤️
113968Global Operations (Others)❤️
113973Enterprise Data Management❤️
114042Insurance Ops❤️
114044Insurance Ops❤️
114125Insurance Ops❤️
114126Insurance Ops❤️
114133Insurance Ops❤️
114192Insurance Ops❤️
114231Enterprise Data Management❤️
114236Insurance Ops❤️
114238Enterprise Data Management❤️
114288Insurance Ops❤️
114291Insurance Ops❤️
114327K&E❤️
114328Insurance Ops❤️
114331Insurance Ops❤️
114332Global Operations (Others)❤️
114334Global Operations (Others)❤️
114337Global Operations (Others)❤️
114348Global Operations (Others)❤️
114353Insurance Ops❤️
114357Insurance Ops❤️
114367Global Operations (Others)❤️
114380Insurance Ops❤️
114388Insurance Ops❤️
114389Insurance Ops❤️
114399Global Operations (Others)❤️
114435Insurance Ops❤️
114436Insurance Ops❤️
114437Insurance Ops❤️
114458Insurance Ops❤️
114461Insurance Ops❤️
114482Insurance Ops❤️
114483Insurance Ops❤️
114484Insurance Ops❤️
114485Insurance Ops❤️
114486Insurance Ops❤️
114492Global Operations (Others)❤️
114532Insurance Ops❤️
114533Insurance Ops❤️
114602Global Operations (Others)❤️
114603Enterprise Data Management❤️
114632Insurance Ops❤️
114633Insurance Ops❤️
114656Insurance Ops❤️
114657Insurance Ops❤️
114672Insurance Ops❤️
114686Insurance Ops❤️
114687Insurance Ops❤️
114688Insurance Ops❤️
114706Insurance Ops❤️
114744Insurance Ops❤️
501650Global Technology❤️
501673Global Technology❤️
901599Insurance Ops 3-5
901600Insurance Ops 3-5
901606Insurance Ops 3-5
901607Insurance Ops 3-5
901611Insurance Ops 3-5
901613Global Operations (Others) 3-5
901711Global Technology 3-5
901714Global Technology 3-5
901715Global Technology 3-5
901716Global Technology 3-5
901797Global Technology 3-5
901841Insurance Ops 3-5
901849Insurance Ops 3-5
901883Global Operations (Others) 3-5
901884Global Technology 3-5
901908Insurance Ops 3-5
901953Global Operations (Others) 3-5
901992Insurance Ops 3-5
901993Insurance Ops 3-5
901994Insurance Ops 3-5
902040Insurance Ops 3-5
902068Insurance Ops 3-5
902090Insurance Ops 3-5
902122Enterprise Data Management 3-5
902123Insurance Ops 3-5
902255Global Technology 3-5
902260Insurance Ops 3-5
902334Insurance Ops 3-5
902380Global Operations (Others)❤️
902381K&E 3-5
902386Insurance Ops 3-5
902451Enterprise Data Management❤️
902459Insurance Ops❤️
902460Insurance Ops❤️
902463Insurance Ops❤️
902465Insurance Ops❤️
902479Insurance Ops❤️
902488Enterprise Data Management❤️
902490Insurance Ops❤️
902496Insurance Ops❤️
902521K&E❤️
902541Insurance Ops❤️
902561Global Technology❤️
902582Insurance Ops❤️
902590Insurance Ops❤️
902591Insurance Ops❤️
902597K&E❤️
902617Global Operations (Others)❤️
902658Insurance Ops❤️
902659Insurance Ops❤️
902674Insurance Ops❤️
902700Insurance Ops❤️
902761Global Technology❤️
902777Enterprise Data Management❤️
902784Global Operations (Others)❤️
902794Insurance Ops❤️
902804Insurance Ops❤️
902805Insurance Ops❤️
902822Insurance Ops❤️
902840K&E❤️
902841K&E❤️
902851Insurance Ops❤️
902859Insurance Ops❤️
902860Insurance Ops❤️
902873Insurance Ops❤️
902888Global Technology❤️
902897Enterprise Data Management❤️
902916Global Operations (Others)❤️
902926Insurance Ops❤️
902929Insurance Ops❤️
902932Insurance Ops❤️
902951Insurance Ops❤️
sunny_talwar

Check it out

Capture.PNG

Expression used

=Count([Person Number])/Count(TOTAL <[Platform Function]> [Person Number])