Hi all, I know that LogParser uses the MS Office Web Component (OWC) to create chart images. Does anybody know which version is it using exactly? Or does it vary on different computers, depends on version installed? If it does, it may be interesting for LP to have different charting capability on different...

a year or so ago I found 2 good word documents I believe written by Igor on manipulating the charts with some advanced techniques. I am trying to find those documents but all the links I find on the site go to logparser.com and are not valid. Mainly I recall they had ways to adjust the colors of certain...

Sorry about the original post, I tried to re-edit but couldnt save the changes. Hope this is clearer Hi, Im new to logparser and my SQL is gained by reading the logparser help file, so please go easy :) I have a huge CSV file that I have managed to split into unique CSVs using a SELECT DISTICT statement...

I believe someone else posted a solution to this a while back. Do some searching here on the forums for chart and grouping.

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...

Jeff, Thank you very much for the assistance. You are correct. Here is the final Resolution: logparser "Select TO_STRING(Hour) AS theHour, count(*) as distinctuser INTO Unique_HITS_PER_HOUR_03_TESTING.gif from nigel.log group by theHour" -q -i:csv -o:CHART -values:off -chartType:BAR3d -chartTitle:"TESTING...

I think to_string() is what you need to do. Logparser likes to graph numbers so forcing it to not be a number should fix your problems (assuming I read it all correctly).

Sample graphs included. -Nigel

Problem: When selecting via the input format CSV, it charts differently than reading from the IISW3C. The subsequent graphs do not come out as expected. 1) This works fine and creates a wonderful graph: query 1: logparser "SELECT TO_STRING (TO_localtime( to_timestamp ( date, time) ), 'HH' ) AS Hour,...

i got just about everything else i need, but just cannot figure out how to get a 45 degree angle for my x axis time labels using a config script . anyone?