Looking for a Sample Line Chart?

Im trying to do a report to show intranet usage in the company and i have managed to get a tabular report but would like to display this as a simple line chart. ive tried implementing this but i keep getting a blank gray screen. Could anyone shed any light on the query? A sample line chart would help greatly. i know a line chart requires a range of numbers but im not sure how to work this.thank you in advance...heres my code for a tabular report.. how do i create a line chart using this?SELECT a.UserId, a.Event, b.Name, b.FirstName, MAX(a.AuditDate)"m", b.LastName, Count(*) "Accesses by User" FROM DAudit a, Kuaf b WHERE a.UserId = b.Id AND a.Event like 'LOGIN' AND a.AuditDate > "Dec 12 2000" AND Deleted = 0 GROUP BY a.UserId, a.Event, a.DataId, b.Name, b.FirstName, b.LastName ORDER BY "Accesses by User" DESC, "m" DESC

Find more posts tagged with

Comments

eLink User

Message from Marie Lindsay via eLinkWhen making a line chart, the blanks to fill in for yourself are:I want the vertical axis to be ___I want the horizontal axis to be ___I want one line on the chart per ___...Once you've determined this, you can create a SELECT statement thatselects these things, in this order. I'm assuming that you want one line perevent, and it just so happens that the example we use for a line chart inthe LiveReports course is based on the audit trail, and here it is:select count(event) "events", trunc(auditdate) "audit_date",event from daudit where trunc(auditdate) >= %1 and trunc(auditdate) <= %2group by trunc(auditdate), event order by trunc(auditdate), eventIn class, we recommend that you first get the data to display as an AutoLiveReport, so that you can check it, then change the format to line chart.I hope this helps.Marie LindsayOpen Text Technical Education

Sam_Blunt

Im trying to display a very simple chart just showing me the mimetype that are in use on a test system using a code drop from the manuals:SELECT mimetype, count (*) as "count" from dversdata group by mimetypeand i am being told that in order to view this as a graph i need to have a column as a string, even though the manual shows that this will create a bar graph. can you tell me what simple thing i am doing wrong!? i am use 9.7.1.thanks

Bhupinder_Singh

Message from Bhupinder Singh <bsingh@opentext.com> via eLink

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">eLink

I was able to duplicate the problem. However, it returns valid data if the report format is set to "AutoLiveReport". This appears to be a bug then. I would recommend reporting the issue to support@opentext.com so that a bug can be entered. The SQL is valid for a pie chart or a bar graph:

"If you plan to present a LiveReport's results in a bar chart, make sure that the statement in the SQL field extracts data that lends itself to such a format. If you use aggregate functions like count or sum for the bars, include a select statement, as well as a group by clause.

One bar appears for each value from the first column you select. (If a group by clause is present, its argument must be the same column). The size of a bar corresponds to the value of the second selected column. "

- Bhupinder
----------------------------------------------
Bhupinder Singh, B.Math, B.Ed.
Senior Systems Analyst, Information Technology
Open Text, Waterloo, Ontario, Canada
----------------------------------------------

From: eLink Discussion: Livelink LiveReports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Tuesday, October 14, 2008 12:48 PM
To: eLink Recipient
Subject: problems with showing simple chart

problems with showing simple chart		Posted by sam.blunt@logica.com (Blunt, Sam) on 10/14/2008 12:46 PM
In reply to: RE Looking for a Sample Line Chart? Here's a sample		Posted by eLink on 07/24/2001 01:22 PM

Im trying to display a very simple chart just showing me the mimetype that are in use on a test system using a code drop from the manuals:

SELECT mimetype, count (*) as "count" from dversdata group by mimetype

and i am being told that in order to view this as a graph i need to have a column as a string, even though the manual shows that this will create a bar graph. can you tell me what simple thing i am doing wrong!? i am use 9.7.1.

thanks