Field "Duration" mostly empty?

[Anonymous]

Hi all!

Just ran GovernanceDashboard against a customer's QV11.20SR2 Server&Publisher.

For some reasons only some Publisher tasks have a "Duration". Has anyone seen this before? I think I got the Publisher Date/Time-Format correct (M*/D*/CCYY HH24:MI:SS for 4/3/2014 04:03:15.5474414 ) , however in column "StartedAt" I have mixed notations!

Thx,

Roland

[Tyler_Waterfall]

Try one of these (not sure if you need to add the period):

M*/D*/CCYY HH24:MI:SS[sssssss]

or M*/D*/CCYY HH24:MI:SS.[sssssss]

[Anonymous]

HI Tyler!

Thx, M*/D*/CCYY HH24:MI:SS.[sssssss] worked for me!

Unfortunately now the Field "[Task Duration Bucket]" (used on the Dashboard upper left barchart) is always empty!

Any ideas why this happens?

[#4]

Hi,

Is this the same field?

[Tyler_Waterfall]

Good to hear that the format worked!

[Task Duration Bucket] is a separate field, based on [Duration], as follows:

IF(Duration<61,dual('< 1 Min',1),

     IF(Duration<301,dual('1 - 5',2),

      IF(Duration<601,dual('6 - 10',3),

       IF(Duration<1801,dual('11 - 30',4), dual('> 30',5)

)))) as [Task Duration Bucket]

I'm not sure why that would not be calculating. You could replace the dimension in that chart with a calculated dimension (not great for performance, but should work). In place of Duration, you might try the nested if statement:

IF(Duration<61,dual('< 1 Min',1), IF(Duration<301,dual('1 - 5',2),  IF(Duration<601,dual('6 - 10',3),  IF(Duration<1801,dual('11 - 30',4), dual('> 30',5)))))

Or the class() function - though this function does not easily allow you to set upper bounds.