calculated dimension query?

[#1]

Hi Everyone ,

I have following columns:- name, employee id , joining date, resigned date, days worked i.e.(resigned date - joined date)

now i want to show in a funnel chart or pie chart, percentage of guys who resigned with dimension being junior, intermediate, seniors (based on days worked if less than 365 then junior, more than 1000 then senior else intermediate)

Can anyone explain me what should i use dimension , ithink i need to use calculated dimension ,, but i am getting the desired result

[#2 · Accepted solution]

Use Calsulated dimension as

if((resigned date - joined date)<=365,'Junnior'

if(((resigned date - joined date))>365 and ((resigned date - joined date)<1000), 'Intermediate'

if(((resigned date - joined date))>1000 , 'Intermediate' , ''

)

)

)

Regards

Arun Goel

[#3]

Thanks that works well . One more thing can you explain value list in this context if applicable here.

[#4]

Sorry..didt get you....??