Graph error messages!

Robert_Power_(crhadmin_-_(deleted))

Hi, when trying to display a line chart the report brings up this error message: "***Parameter Error*** Lineset1: item(1): attr(1):Illegal DATE/TIME Unit entry."my code is..select Count(Event) "events", Name, Event from DAudit, KUAF where UserID = ID and Event like 'LOGIN' group by Name, Event order by "events" DESC, Name, Eventif anyone can help thank you very much...Cormac

eLink User

Message from Marie Lindsay via eLinkYou might want to check with Support on this one, but I believe the problemis that the second column you're selecting is not numerical or date/time.When creating a line chart, the first column selected should be for the y(vertical) axis, the second should be for the x (horizontal) axis, and thethird should be for the lines. The x and y axis values should be numericalor date values, so that they can be "plotted".Hope this helps,Marie Lindsay> -----Original Message-----> From: knowledge@opentext.com [mailto:knowledge@opentext.com]On Behalf Of> eLink Discussion: Livelink LiveReports Discussion> Sent: Friday, August 03, 2001 4:35 AM> To: eLink Recipient> Subject: Graph error messages!>>> Graph error messages!> Posted by CRHAdmin on 08/03/2001 05:31 AM>> Hi,> when trying to display a line chart the report brings up this> error message: "***Parameter Error***> Lineset1: item(1): attr(1):> Illegal DATE/TIME Unit entry.">> my code is..> select Count(Event) "events", Name, Event from DAudit, KUAF where> UserID = ID and Event like 'LOGIN' group by Name, Event order by> "events" DESC, Name, Event>> if anyone can help thank you very much...> Cormac>> [To reply to this thread, use your normal e-mail reply function.]>> ============================================================>> Discussion: Livelink LiveReports Discussion> https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2249677&objAction=viewLivelink Server:https://knowledge.opentext.com/knowledge/livelink.exe