MySQL Bugs: #37236: Dashboard -> Graph missing default date to today

Bug #37236	Dashboard -> Graph missing default date to today
Submitted:	5 Jun 2008 18:33	Modified:	13 Nov 2008 21:08
Reporter:	Diego Medina	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Enterprise Monitor: Web	Severity:	S3 (Non-critical)
Version:	2.0.0.7001	OS:	Any
Assigned to:	Josh Sled	CPU Architecture:	Any

Description:
When you are on the dashboard ->Graph page. If you change the "Time display" from interval to "From/To", you are force to enter today's date if the range of hours you need is for today.

If you are monitoring your server(s) several times a day, I do not think you want to enter today's date every time.

How to repeat:
1- install agent and monitor
2- Let the monitor collect some data
3- Go to the Dashboard->Graph
4- Change "Time Display" from "Interval" to "From/To"
5- Enter some hours for today in the from and to fields for time
6- click on Filter
7- See the error

Suggested fix:
Default to today's date if the option "From/To" is selected.

eric's first UI bug!  w00t

I don't see defaulting the from date today as being useful. If you're looking for today's data, you should be using the interval rather than from/to. From/to is designed to give you access to arbitrary dates in the past and, in most cases, the 'from' field should be a day other than today.

The way I found this was because I wanted to see activity "between" 1am and 3 am this morning. In which case interval was not useful for me.

how about that if I leave the date fields empty, it will assume I mean today?

While this may be your common scenario, I'm not confident that it is the most common intention of our customers. It is certainly a valid use case but it's equally valid to assume that someone would want to default to this week rather than today.

Aside from that, given the design of our date range tools, what you are actually saying when you have no values in to or from is that this is a completely open ended search. In other words, that you want graphs assembled from the earliest collected date to the latest collected date. This would be entirely valid but we report it as an error due to performance constraints.

The Query Analysis page has a different behavior, leaving the dates fields empty does a search (not sure what range though, maybe from beginning to end))

So I think we should have both pages (quan and the graph pages) do the same under the same circumstances.

(I like the query analyzer way of dealing with dates)

*if you enter only the start date and time, it will assume the end date and time to be now (the Graph page gives you an error)

Empty is useless, it is not even something that I change and edit, I have to think and retype stuff.

When going to interval to from/to please a) translate current interval into from/to range or b) fill in useful defaults such as To: today, current time and From: today, midnight.

revno: 6481
revision-id: jsled@asynchronous.org-20081111185207-wmmj3e530gfqh68w
parent: jsled@asynchronous.org-20081111172733-bkirl27cjdfgzyn7
committer: Josh Sled <jsled@asynchronous.org>
branch nick: 2.0
timestamp: Tue 2008-11-11 13:52:07 -0500
message:
  Bug#37236: set the from/to values on the Graph and Browse Queries pages based on the interval and the current time.

Verified fixed on 2.0.0.7094