issue on Dates

[#1]

hi

I have two date fields i.e Submit Date and Resolved Date

for example : if Submit date is 20/06/2016 and resolve date is 26/06/2016 now i need to calculate duration between the dates

and with  i need to plot a graph like <.1 days ,1-2 days,3-7 days,>30days like that

Dimension :complaint Number

[swuehl]

classify your tickets in your load script, creating a new field like

LOAD

     [Submit Date],

     [Resolved Date],

     Class( [Resolved Date]- [Submit Date] +1, 5) as [Duration Class],

     ...

(or using if() statements to create the buckets you need). Then use Duration Class as dimension and a count of your ticket ids as expression.

See also

Buckets