Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
please post some sample data
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.
ok, but what are your dimensions? and will you have all 3 expressions in a single chart?
There is one more field Process That has different values like Coding,Issuance etc.