RE: Multiple Series from single column of data

[Software FX]

No. You would need to create a crosstab. 

We will provide an add-in to ChartFX in the future that will allow you to this but at this time you will have to create the crosstab.

Regards, 

Juan Cegarra 

Software FX, Inc. 

http://support.softwarefx.com 

-----Original Message----- 

From: Robyn Hoole [ mailto:robyn.hoole@umgeni.co.za] 

Posted At: Thursday, May 11, 2000 9:51 AM 

Posted To: Server 

Conversation: Multiple Series from single column of data 

Subject: Multiple Series from single column of data 

Hi 

I wish to display multiple series based on the value of a Name field. 

e.g. I currently have a query like this: 

Select Name, Date, Value from Table 

where date between param1 and param2 

This returns, say 20 records where Name = UG1, 20 records where Name = UG2, 

etc. 

I wish to display one series for UG1 and another series for UG2, etc. 

Is there any way to do this, without trying to create a view to make 

multiple pseudo columns ? 

Thanks