2 Replies Latest reply on Jun 29, 2016 1:12 AM by harris.tsr

# Create value groups

Hi Everyone,

I want to visualise in a table (such as the one below) the number of the opportunities coming from direct or partner accordingly, but groupped according to the average number of days that has been stuck to a particular status.  Let's say all of this information is stored to a measure called "Stuck_Lead". What statement should I build in a calculated field that would calculate the number of the opportunities based on the below groupping?

Could I say for example:

Direct
PartnerTotal
0-100 days50025525
101-200 days150100250
201-300 days155100255
301+ days503686

Perhaps I'm not exaplaining it very well but hopefully you understand what I'm trying to do.

• ###### 1. Re: Create value groups

You're creating a dimension, so your formula would need to look like

IF AVG([Stuck_Lead]) <100 then '0-100 days'

ELSEIF AVG([Stuck_Lead]) < 200 then '101-200 days'

ELSEIF AVG([Stuck_Lead]) < 300 then '201-300 days'

ELSE '301+ days'

END

• ###### 2. Re: Create value groups

Thank you Tom! Just what I was looking for. Appreciate that