Hi All,
I have a sheet composed by the following columns :
YEAR MONTH DAY HOUR MINUTE
2010 02 15 14 58
2010 02 15 14 57
2010 02 15 14 54
2010 02 15 14 54
2010 02 15 14 46
2010 02 15 14 46
2010 02 15 07 21
2010 02 15 06 47
2010 02 15 06 47
2010 02 15 06 41
2010 02 15 06 12
2010 02 15 06 10
2010 02 11 14 46
2010 02 11 14 45
2010 02 11 14 45
2010 02 11 14 45
2010 02 11 14 44
2010 02 08 21 09
2010 02 08 21 09
2010 02 08 21 08
2010 02 08 21 08
2010 02 08 21 07
2010 02 08 20 04
This corresponds to incidents that are logged in a table for an application. anyway, this is just to give you the context.
Now I would like to setup a graph which have as X axis the days of february, and as Y, a value 1 when for each date+time in my columns, and a 0 when no date+time is in my columns.
Can you help on this ?
Thanks by advance.
Vincent.
Bookmarks