Positive Numbers showing negative

K

kjmatt

I'm generating charts from a series of XML files using LogParser. One of the
XML fields is a file size. I'm summing the file sizes based on the Userid.
The problem is that when the summed numbers approach 2 gigabytes they start
going negative on the chart, so I end up with a chart with both positive and
negative bars. If I output to a CSV file the numbers are all positive, so I'm
thinking that it must be something with the way the chart itself is
generated. Here is a sample query:

logparser -i:xml -o:chart "select User, sum(size) as sumSize into
Fileslast30.jpg from \iislogfiles\*.xml where User like 'PA%' and Date >
'20090109' or User like 'NY%' and Date > '20090109' or User like 'GA%' and
Date > '20090109' or User like 'CA%' and Date > '20090109' or User like
'NV%' and Date > '20090109' or User like 'WA%' and Date > '20090109' or User
like 'NC%' and Date > '20090109' or User like 'AL%' and Date > '20090109' or
User like 'MO%' and Date > '20090109' group by User order by sumSize desc"
-charttype:barclustered3d -charttitle:"Files Transferred Last 30"
-groupsize:800x600 -fmode:tree

Unfortunately I am unable to submit any sample data as it is not for public
viewing and don't have a screen shot.

Any help is appreciated

KJ
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top