Count text occurrences across multiple columns/fields

GMellow — Tue, 28 Jun 2022 19:34:51 GMT

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.

Re: Count text occurrences across multiple columns/fields

MarcoWedel — Tue, 28 Jun 2022 22:11:42 GMT

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'))

topic Count text occurrences across multiple columns/fields in App Development

Count text occurrences across multiple columns/fields

Re: Count text occurrences across multiple columns/fields