Bar Chart Pop-up and Concat expression help.

[#1]

Hi,

I am trying to create a Pop-Up expression, that Concat's values (Level), with it's value(count(Stu_Prog))

So that the output is something like : TP:80 / UG:9 etc etc..

I've created an expression, but it doesn't seem to work when I put in the count(Stu_Prog) part.

Any suggestions? I might be missing something.

Much appreciated!

Xena

[#2]

Hello Xena,

Is this way u r looking for , attached is the solution

Thanks

Talha

[#3]

Hi Talha,

Thanks for your response.

However I need the values to be concatenated, as there may be more than 1 value for 'Level'

I see in the help , the concat function doesn't allow aggregation functions like count etc.

Thanks,

Xena

[#4]

hi

Since there are two types of level, i could come up with this, it shows the result as required by you,see if this can help

'UG:' & count(if(Level='UG',Stu_Prog)) & ' ' & 'TP:' & count(if(Level='TP',Stu_Prog))

regards

peter

[#5]

Thanks Peter!