Calculated Dimensions

[#1]

Hi Friends,

load Inlin [

Department,

if(wildmatch(Department,'Comp*','Mec*'),Department) as Dept1,

if(wildmatch(Department,'Elec*','IT'),Department) as Dept2

]

I created two Calculated Columns while I was loading the file. Dimensions are "Dept1,Dept2 ". Now my Problem is I want to show those Columns as Calculated Dimensions in a barchart. Is it Possible....?

In a bar chart 1st bar should be Dept1 and 2nd is Dept2.  can you please tell me how is this?

[jonathandienst · Accepted solution]

Use this:

=if(wildmatch(Department,'Comp*','Mec*'), 'Dept1', if(wildmatch(Department,'Elec*','IT'), 'Dept2'))

[jonathandienst]

But I suggest that you add this as a derived field in your load script rather than using a calculated dimension.

LOAD

	Department,
	if(wildmatch(Department,'Comp*','Mec*'), 'Dept1', if(wildmatch(Department,'Elec*','IT'), 'Dept2')) As Dept,
	...