I am now creating a new Analytics report and have selected some columns from Subject Areas.
Could you teach me how I can override value of resulted data by setting condition.
Column Name : Opportunity Type Code
Result of data : Unassigned, Tech, Apps, SaaS..... etc.
Column Name : Opportunity Type Code (No change)
Result of data : U, T, A, S..... etc.
This means that "U" is Unassigned, "T" is Tech, "A" is Apps, "S" is SaaS and I would like only see U, T, A and S in the result.
Thank you so much !! Could you pls teach me the formula type for the case below too?
Column Name : Campaign Code (No change)
Result of data :
Unspecified ---> Unspecified (No change)
JPFM1 ---> Japan Local 1
JPFM2 ---> Japan Local 2
JPFM3 ---> Japan Global 1
JPFM4 ---> Japan Others
CNPG1 ---> China Local 1
CNPG2 ---> China Local 2
CNPG3 ---> China Others
AUAR1 ---> Australia Local 1
AUAR2 ---> Australia Local 1
in such cases you'd better create a database table and map it in the repository, if you can.
Anyway, I think that what you are looking for is the Bin.
Go to the Criteria page of the request definition. Edit the formula of the column you want. Go to the "Bin" tab and create labels as you like.
If you want, you may look at what this generates in the formula tab of the column, afterwards.
Hope it helps.