How to make my stack bar chart for reject and production same length ?

[paulyeo11]

Hi All

I have a chart which display reject qty and product Qty by product line. which showing 2 Bar , one is very long another one is very short. So it is hard to know which product line have more reject.

So i convert the chart to stack chart , again i can know which product line have more reject compare to total production qty.

So i convert the both expression to display relative value , this time some bar become long and some become short.

my question is how to make all bar same length ?

Enclosed my QVW file.

Paul

[john9inno · Accepted solution]

Is this what you aim to acheive?

below is expressions that i used.

reject = count(Aggr(NODISTINCT kode_reject,date_time))/sum(product_total)

Production = 1 - count(Aggr(NODISTINCT kode_reject,date_time))/sum(product_total)

[paulyeo11]

Hi Sir

I use your expression , but i get the chart not like your. where i go wrong ?

Paul

[paulyeo11]

Hi Sir

I found the answer , i should not click on relative . now working fine.

Thank you

Paul

[john9inno]

You need to untick relative under Expressions.

that will allow you to have same chart.

thanks.

FYI just realised that set MAX  Static scale as 1 make it easier to read.

[john9inno]

Yep that is it.

It is simpler than you thought.