Logic Help

[abhaysingh]

Hi all,

I have to show day wise resolution time, in table,, but i a day resolution time can be so many so i have to put resolution time which took maximum time.

i have one calculative field called resolution time i.e. Datecreated- Dateresolved = ResolutionTime

I m trying to put Dimension as Day and measure as max(ResolutionTime)

but getting error..

also tried by max(frac(ResolutionTime))

can any one pls suggest in it..

Thanks

[sunny_talwar]

What is the exact error you are seeing?

[tresesco]

Have you checked if ResolutionTime has got numeric values or string or '-'?

[Mark_Little]

Hi,

As Sunny has asked, knowing the error would help advise.

Also as Tresesco has asked have you checked the values you are receiving?

On the back of there comment i would advise making a table with the ID field, Datecreated, Dateresolved and ResolutionTime on and check the results.

Also where you calculating the ResolutionTime in script or front end?

Mark

[Anonymous]

Does your Day as dimension associated with ResolutionTime which you have created from

Datecreated- Dateresolved

[#6]

Try Rangemax(ResolutionTime) as your expression.  If that works, then the data for ResolutionTime contains strings