This content has been marked as final. Show 2 replies
load Inlin [
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?