Count text occurrences across multiple columns/fields

[GMellow]

Hello,

I have the following (simplified notional example) of a table where I want to count the number of "A"s, "B"s...etc across multiple columns without concatenating in the script and show in a bar chart. In this case "A" would be 3, "C" would be 3, "R" would be 2, etc.

Type	Proj1	Proj2	Proj3	Proj4
A1	A
A2	C	G	R	y
A3	D	C
A4	A	F	G	J
A5	E	R	T	U
A6	F	A	G	Y
A7	C	L	P	O
A8	Q	T	Y	P
A9	J	K	X	V
A10	S	D	F	G

Any help appreciated.

[MarcoWedel · Accepted solution]

maybe like this:

using 3 measures:

Sum(SubStringCount(Proj1&Proj2&Proj3&Proj4,'A'))

Sum(SubStringCount(Proj1&Proj2&Proj3&Proj4,'C'))

Sum(SubStringCount(Proj1&Proj2&Proj3&Proj4,'R'))