Date colors based on Condition??

[paulwalker]

Hi All,

I Have a Date field,

I want to calculate like this..

[Date]<=10,'0-10',

[Date]<=20,'11-20',

[Date]<=35,'21-35',

[Date]<=45,'36-45','Lapsed'

how to calculate..

--Paul

[swuehl]

Try something like this in your script or frontend

if( [Date]<=10,'0-10',

if([Date]<=20,'11-20',

if([Date]<=35,'11-35',

if([Date]<=45,'36-45','Lapsed'))))

[rustyfishbones]

Hi Paul,

Did you try looking at using the Class function

[paulwalker]

Hi Swuehl,

Suppose i am using Straight table..

here calculate 4 columns 0-10,11-35, 36-45 and Lapsed

[rustyfishbones]

Create a Calculated Dimension and add Swuehl IF statement

to add colors just add it in the background color

like below