How to Compare two Fields in same Chart

[#1]

Hi,

how to compare two fields ie.

in my senario i need to compare Developer and Manager Contribution in single chart or in any chart just show side by side and value on data points !

[#2]

You can create Bar chart with Dimension and two expressions.

first expression:  Developer Contribution

second expression: Manager Contribution.

[#3]

Use this dimension:

IF(IsNull(Manager), Developers, Manager)

[Gysbert_Wassenaar]

There are several ways you can do this. The easy way out is to use a calculated dimension: =[Manager] & [Developers]. You can add a background color expression to the expression to give the manager bar a different color: =if(Len(Manager), lightred())

[israelcsouza]

Follows the attachment,

[#6]

thanks Gysbert.

i got it.but  in my sourse file i got 50 managers names and their team members.

when  select a manager name then his team membs contribution and his contribution should show .but in my case it showing only manager name dosnt showing developer names and by default it should show only one manager name when no selections made.

[#7]

thanks israel,

when i select manager it should show all developers names along with Manager contribution it like comparision side by side

[#8]

the problem is your data, some developers doesn't have a Manager.

Manager	Developers	Contribution
Sam		1000
Nile	leno	200
Mick	Falts	399
	Afstla	500
	Antony	600
	bent	400
	brigate	788
	cult	820
	David	300
	Frank	500
	jon	400
	mark	300
	Mickle	700
	samule	599
	venil	987
	William	200
	Wilson	900

[Gysbert_Wassenaar · Accepted solution]

Ok, then transform your table like this:

Manager, Employee, Role, Contribution:

Sam, Sam, Manager, 1000

Sam, Anthony, Developer, 600

Sam, David, Developer, 300

...etc

Mick, Mick, Manager, 900

Mick, Frank, Developer, 500

Mick, Eva, Developer, 400

...etc

Then use Employee as dimension in the chart and use the field Manager to select a manager.

[israelcsouza]

ok,

and now?