combine 2 field

[Anonymous]

hi guys,

I have a file, where there is 2 field like city and country.

I'd like to calculate sore for country and cities in 1 table.

Score1	Score2	Score3	Score4
47	61	18	61
47	46	35	45
4	7	4	45
58	56	42	23
5	4	13	88
44	78	33	65
88	88	13	58
8	56	45	12
46	4	23	88
25	72	87	4
77	12	72	75
86	79	35	65
78	88	16	14
12	78	4	32
86	48	35	23
26	23	15	75
35	89	13	56
78	42	12	88

Please find my attached file.

Thanks,

[Anonymous]

Sorry about it.

I added Score5 (Yes, No and missing value)

Thank you,

[Anonymous]

I just modified the test file.

I want to see % of Yes for each tag and also average of % for countries.

[sunny_talwar]

And how is percentage calculated? Can you give an example from your database?

Best,

S

[Anonymous]

I usually calculate"

dimension  -Name1

Count({<Score5={'Yes'}>} Name1)/ Count (Total Name1)

and the same for Name2

But I don't know how to combine 2 fields in 1

[sunny_talwar]

This may not be the best way to do this, but nonetheless PFA

Best,

S