Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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]
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?
Hi,
Is this the same field?
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.