I'm using LogParser to make beautiful graphs. Typically using our database logs and statistic files as input, showing how many times a certain event has happened each hour over a day.
There are however hours when no activity has taken place and i can't get theese to show in the graph. If I output to a the default table format or a DATAGRID I can see the empty hours.
This is the SQL question I use:
SELECT
QUANTIZE(EventStart,3600) AS Time,
SUM(CASE Action when 'Login' THEN 1 ELSE 0 END) As Login,
SUM(CASE Action when 'Search' THEN 1 ELSE 0 END) As Search,
SUM(CASE Action when 'Query' THEN 1 ELSE 0 END) As Query,
SUM(CASE Action when 'Raise' THEN 1 ELSE 0 END) As Raise
into stat.gif
from 'c:\statistics\Actions_070610.log'
where User<>'' AND SUBSTR(User,0,3)<>'WWW'
group by Time
This results in a nice graph from the time the actions start until they end, but the hours prior and after, and more importent, any empty hours in the middle of the sample just aren't displayed.
Can any one help me on what to do to see the empty samples?
Thanks in advance,
Clas