Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Use this:
=if(wildmatch(Department,'Comp*','Mec*'), 'Dept1', if(wildmatch(Department,'Elec*','IT'), 'Dept2'))
Use this:
=if(wildmatch(Department,'Comp*','Mec*'), 'Dept1', if(wildmatch(Department,'Elec*','IT'), 'Dept2'))
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, | |
... |