Date Range

Tue, 04 Aug 2015 11:51:12 GMT

Hi Experts,

i have an Employee details table which has Startdate as a dimension.

from this, i have done the calendar to get month and year of start date.

i have done an expression as Date(Today())-STARTDATE to calculate the length of service in days.

i have the following chart to count the no. of employees with regard to length of service.

Now i need to change this chart like the days as range to make the chart user friendly. i.e., like 0-5, 10-20, 30-40, ...etc

similar to the below chart.

how can i do this.

please help me on this

Re: Date Range

krishna20 — Tue, 04 Aug 2015 12:29:05 GMT

Hi Rajendran,

Try by using Class() function.This may helps you...