How to make the bar display as 2 For reject code = 124 ?

[paulyeo11]

Hi All

I want to plot a chart that display the Qty of reject by reject code, I don't have the Qty value , i only have the reject code . May i know how to count number of reject code and display on the bar chart ?

Paul

[antoniotiman · Accepted solution]

Hi Paul,

try

count(Aggr(NODISTINCT kode_reject,line_id))

Regards,

Antonio

[paulyeo11]

Thank , it work fine.

[paulyeo11]

Hi Sir

I want to count total number of reject by kode_reject , meaning I will place kode_reject at dimension .

Paul

Sent from my iPhone

[antoniotiman]

Try aggr() with date_time instead of line_id

[paulyeo11]

Hi Antonio

Thank you vey much , i manage to create all the chart i need.

Paul