When I run the following code, the chart generated takes only the hour part into consideration. Is there a way to show the exact time? If not, then at least the hour and the minute?
h2. SQL Job durations
{chart:title=SQL Job finish times by day|type=timeSeries|dateFormat=MM/dd/yyyy| dataOrientation=vertical|columns=StartDate,EndTime|legend=true|height=500|width=800|dataDisplay=true|yLabel=Time|xLabel=Date|categoryLabelPosition=up45|rangeAxisLowerBound=0|rangeAxisUpperBound=24|rangeAxisTickUnit=2}
| StartDate | EndTime |
| 12/26/2012 | 05:09:39 |
| 12/25/2012 | 04:52:47 |
| 12/24/2012 | 04:57:37 |
| 12/23/2012 | 04:37:42 |
| 12/22/2012 | 05:21:21 |
| 12/21/2012 | 06:29:20 |
| 12/20/2012 | 04:54:13 |
| 12/19/2012 | 06:36:23 |
| 12/18/2012 | 06:27:02 |
| 12/17/2012 | 09:48:31 |
| 12/16/2012 | 08:12:18 |
| 12/15/2012 | 12:37:35 |
| 12/14/2012 | 13:15:58 |
| 12/13/2012 | 09:39:34 |
| 12/12/2012 | 08:18:10 |
{chart}
I would have loved to be able to provide the datatype for y-axis in this case - whether a number or a time and let the chart macro handle it. I am not an administrator, so can't create macros.
No, it is numeric, so there is nothing you can do there. Suggest creating a user macro that converts a time to a number.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Bob,
Thanks for the quick reply. Showing EndTime as a numeric value is not an option. It confuses. 0.25 could be confused as 25 minutes when it actually would be 15 minutes. I tried forgive=false as well, but that did not help. Any other ideas?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
The y axis values are numbers (not dates) and the default is to forgive bad data if possible. Therefore it is only interpreting the number before the : as valid. You would need to express your end time value as a numeric value like 5.15
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.