Represent NA in a Bar Chart

[sagar_vij99]

hi there,

Actually i am using a DB where for a column i can have possible values as 0,1 and Blank. I can show sum of these values in a Bar Chart over a dimension. Now the question is I want to show another bar in the same chart that will show NA for blank values on the same dimension.

eg.

Load * inline

[

name,errors

A,2

B,3

A,Blank

]

Can anyone please help me out here..??

Also I have another question. Here i am trying to calculate %share for an individual from same column, so Column NPT has nu. of production hours. When i calculate % for A it will be sum(NPT)/sum(NPT). now the problem is it always show 100% whenever i select a person's name in filter and i understand the reason that it filters out other values as well. Is it possible to store total of NPT column seperatley and then i can use it to calculate percentage share of each individual..? I am trying this on frontend. Any help/suggestion will be appreciated.

eg,

Name,NPT

A,2

B,2

ideally share should be 50% for both but i am getting 100.

Thanks

Sagar

[vinieme12]

please post some sample data

[sagar_vij99]

Processed By	Processing Time (Min)	QC Time (Min)	SumOfVolume	delay	Exempt	SumOfQC Count	SumOfInternal Error	SumofExternalError
Tapan Sharma	419	231	25	5	5	12	0
Tapan Sharma	1095	540	24	5	5	24	0
Tapan Sharma	905	250	12	5	5	5	0
Tapan Sharma	58	5	5	5	0
Tapan Sharma	40	2	5	5	0
Tapan Sharma	1142	75	33	5	5	3	0
Tapan Sharma	1831	140	5	5	0

Here now i want to make a bar graph showing sumofQCCount, sumofinternalerror and sumofexternalerror.

what is happening is i am getting only 2 bars but i want if i donot have values for sumofexternalerror column NA should appear in chart.

i hope this makes it clear.

[vinieme12]

ok, but what are your dimensions? and will you have all 3 expressions in a single chart?

[sagar_vij99]

There is one more field Process That has different values like Coding,Issuance etc.