Coloring/Concatenating different Calculation in single column

[dsharmaqv]

Hi

I am trying to calculate come counts of seviority and trying to display in same column.

For instance  have to count seviority by Column1

Output:

C1	Count of Seviority (High/Med/Low)
A	1/1/0
B	2/1/2
C	0/0/1
D	3/0/0

And display like this

Table A

C1	seviority
A	High
A	Med
B	High
B	High
B	Low
B	Med
B	Low
C	Low
D	High
D	High
D	High

[adamdavi3s]

AFAIK the only way to do this would be to have three different expressions and colour them

[sunny_talwar]

I don't think coloring can work, but concatenation should be simple I think

Script:

LOAD C1,

          Dual(seviority, Match(seviority, 'High', 'Med', 'Low')) as seviority

and then on the front end

Dimension:

C1

Expression:

Concat(Aggr(Count(seviority), c1, seviority), '/', -seviority)

[adamdavi3s]

Something like this is possible if you need colour coding, but you'll have to decide between having it all in one cell or having colours I am afraid!

[adamdavi3s · Accepted solution]

Another way without changes to the script is a simple

=sum(if(seviority='High',1,0)) &'\'&sum(if(seviority='Med',1,0)) &'\'&(if(seviority='Low',1,0))

[dsharmaqv]

I have tweeked a bit to avoid color coding

sum(if(seviority='High',1,0)) &'(H)\'&sum(if(seviority='Med',1,0)) &'(M)\'&sum(if(seviority='Low',1,0)) &'(L)