Inline interval dimensions

[#1]

Hi Everyone

I have below fields.

Load *,

as no_of_days_to_solve  // gives me number of days which is enddate - start date.

How can i create dimension that shows

Case took more then 15 days

Case solved in 15 days

case solved in 10 days

case solved in 5-10 days

case solved within 5 days

LOAD [Ticket Number],

     [Requestor Name],

     [Support Group],

     [Call Summary],

     [Call Status],

     [Call Severity],

     [Call Type],

    [Create Date],

     Year ([Create Date]) as year,

     month ([Create Date]) as Month,

     day([Create Date]) as day,

    [Closed Date]

FROM   

[SergeyMak]

Try to use IF

IF(no_of_days_to_solve<=5, '0-5 days',

     no_of_days_to_solve>5 and no_of_days_to_solve<=10, '6-10 days',

     no_of_days_to_solve>10 and no_of_days_to_solve<=15, '11-15 days',

'16+ days'

) AS YourDimension

[#3]

Thanks Sergey

I am getting syntax error after second statement where we are testing for 5 to 10.

no_of_days_to_solve>5 and no_of_days_to_solve<=10 // syntax error start from comma , '6-10 days',

[SergeyMak]

sorry... my mistake

IF(no_of_days_to_solve<=5, '0-5 days',

     IF(no_of_days_to_solve>5 and no_of_days_to_solve<=10, '6-10 days',

     IF(no_of_days_to_solve>10 and no_of_days_to_solve<=15, '11-15 days',

'16+ days'

))) AS YourDimension

[tresesco]

I recommend class().

[SunilChauhan]

use class function like below

Class(no_of_days_to_solve,5,'no_of_days_to_solve') as  fieldname

and use in dimension

hope this helps

[#7]

How to use Class () function for below example.

IF(no_of_days_to_solve<=5, '0-5 days',

     IF(no_of_days_to_solve>5 and no_of_days_to_solve<=10, '6-10 days',

     IF(no_of_days_to_solve>10 and no_of_days_to_solve<=15, '11-15 days',

'16+ days'

))) AS YourDimension

[SergeyMak]

IF(RIGHT(Class(no_of_days_to_solve,5),2)>15, '16+', Class(no_of_days_to_solve,5))  AS YourDimension

Or you can use directly in the chart as calculated dimension

IF(RIGHT(Class(no_of_days_to_solve,5),2)>15, '16+', Class(no_of_days_to_solve,5))