field count

[#1]

Hi All

i coulndt solve my issue.

At the attached excel.  Columns (F, G, H , I) has Sub_delay_code_1, Sub_delay_code_2, Sub_delay_code_3, Sub_delay_code_4

i want to count all codes in this four columns

for example '15A' is 3+1+2+0 = 6 in all four columns

thnaks a lot

[#2]

it is not clear to me what you said but

try to make a barchart

dimension DS_DELAY_SUB_CODE

and expression =Count(DS_DELAY_SUB_CODE_1)+Count(DS_DELAY_SUB_CODE_2)+Count(DS_DELAY_SUB_CODE_3)+Count(DS_DELAY_SUB_CODE_4)

[#3]

thank you very much but for dimesion i tried to merge the columns to cerate DS_deLay_sub_code

but i used concatanate and join but i couldnt, how i will prepare it

[#4]

which column you want to merge?

[#5]

F, G, H, İ columns

i tried in the script but it dublicated the data

[#6]

i dont know how to create DS_DElay_sub_code

because at the and people wants to selecte some codes from DS_DELAY_SUB_CODE

and it will be dynamic