Ask Search:
Aparna PuvvadaAparna Puvvada 

Need Case statement On Stage Duration field which is involved in Opportunity object in wave analytics.

Hi Guys,

I am trying to write a case statement in Wave analytics. i am trying to create like bucket field whic are creating in Salesforce, but in wave their is no option to create a bucket field directly.

On Stage Duration field, i wanna get the result like (Case when
Stage-Duration < 30 then '# RED'
Stage-Duration > 30 and < 59 then '# Green
END)
like this i am trying to write in SAQL query.
but i am enable to write this case statement properly.

Can you please help me to achieve this requirement.

Thank you.
 
Best Answer chosen by Aparna Puvvada
J. SteadmanJ. Steadman

Aparna,
 

You are able to create buckets when you create a recipe from an existing dataset.  Have you experimented with this approach?

User-added image

J.

All Answers

J. SteadmanJ. Steadman

Aparna,
 

You are able to create buckets when you create a recipe from an existing dataset.  Have you experimented with this approach?

User-added image

J.

This was selected as the best answer
Aparna PuvvadaAparna Puvvada
Hi Stead,

I just see that option, and i will use this to create a Bucket field in Recipe.

Thank you so much for your help.
J. SteadmanJ. Steadman

Aparna,
 

Great! Please consider marking a best answer to close out this question.
 

J.