calculated dimension

[niha]

hi,

I have a dimension called task. it has say 12 tasl say a,b,c,d,e,f,g,h,i,j etc. I want to take only imp task for a calculation and say the imp task are a, b, c, d. I want to create a calculate column for that. Please suggest how to create and what will be the logic.

Thanks,

Niha

[JordyWegman · Accepted solution]

Hi Niha,

Try:

IF(Task = 'a' OR Task = 'b' OR Task = 'c' OR Task = 'd', 'IMP','Other')

Or in the script:

IF(Task = 'a' OR Task = 'b' OR Task = 'c' OR Task = 'd', 'IMP','Other') as NewDimension

Jordy

Climber

[niha]

Thanks . That really worked and one step ahead. so I have now a new dimension with two field IMP and Other. when I created bar chart, ( custom object- Bar and area chart),

I found like below bar-chart. 

But the requirements is to see only IMP_TASK as sliced. The IMP WORK only to be sliced like below . IMP_WORK which has been declared has to be shown like stacked bar chart as dimension.