Bar chart Help

[Saif1]

Hello QLikers, 

i have a sample data :

Emp num	Category	Mark	Score
1	One	Wanted	40
1	One	Actual	20
1	Two	Wanted	25
1	TWo	Actual	0
1	Three	Wanted	25
1	Three	Actual	10
1	Four	Wanted	10
1	Four	Actual	15
2	One	Wanted	40
2	One	Actual	25
2	Two	Wanted	25
2	Two	Actual	20
2	Three	Wanted	25
2	Three	Actual	25
2	Four	Wanted	10
2	Four	Actual	10

I want to show the AVG of (actual) in a bar chart with grouped category, i did it but when i take the AVG(SCORE)

it gives me the avg for both wanted and actual score, i want to make the wanted as a static bar (for referencing) and the actual as AVG

something like this ( A = one , B = two , etc.....)  , excuse my drawing XD,

any help ? thanks.

[justISO · Accepted solution]

Hi, I believe you need to create 2 different measures, one just for Wanted, other for Actual. This can be done like this:

avg({<Mark={'Wanted'}>}Score)

avg({<Mark={'Actual'}>}Score)

so your chart should look like this:

[Saif1]

It worked , weird enough that the first time it did not give me an option to add 2 measures, then i took max(actual values) to achieve what I wanted.

Thank you so much.