Combining two columns in X-axis

[#1]

Hi Team ,

I am having three columns.Named as project,Application and requirement.One project can contain any no. of application.

EX

P1   APP1   r1

P1   APP1   r2

P1   APP2   r3

P2   APP1   r4

I want  to plot (project & Application) in x axis and count(requirement) in y axis.

X-axis       Y-axis

P1-APP1     2

P1-APP2     1

P2-APP1     1

I tried concat(project,application).It is not working. Can u please suggest a solution for this?

[Gysbert_Wassenaar · Accepted solution]

Create a new field in the load script that combines the two fields or use a calculated dimension that combines the two fields: project & '-' & Application

[#3]

Hi Gysbert,

Thank u for the reply.It is working fine.