Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Adding Series To Stacked Graph

5 posts in Objects Last posting was on 2010-07-08 11:45:55.0Z
Roneno Posted on 2010-07-08 07:16:57.0Z
Sender: 603f.4c3579a2.1804289383@sybase.com
From: roneno
Newsgroups: sybase.public.powerbuilder.objects
Subject: Adding Series To Stacked Graph
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4c357b69.606b.1681692777@sybase.com>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="-=_forums-1-dub4c357b69"
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 8 Jul 2010 00:16:57 -0700
X-Trace: forums-1-dub 1278573417 10.22.241.41 (8 Jul 2010 00:16:57 -0700)
X-Original-Trace: 8 Jul 2010 00:16:57 -0700, 10.22.241.41
Lines: 2805
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.objects:10011
Article PK: 712563

Hello,

The attached picture is a painter of graph DW. When I mark
the series chekbox I get only one field to add a series.
The SQL of my datawindow require 2. how can I define another
series?

(There is a function: AddSeries but it's only for graph
object, not for DW graph)

Thank you

AddSeries.jpg

Ivaylo Ivanov Posted on 2010-07-08 08:13:04.0Z
From: "Ivaylo Ivanov" <n0_S_p_a_m_i.ivanov@isy-dc.com>
Newsgroups: sybase.public.powerbuilder.objects
References: <4c357b69.606b.1681692777@sybase.com>
Subject: Re: Adding Series To Stacked Graph
Lines: 28
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5931
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5931
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4c358890@forums-1-dub>
Date: 8 Jul 2010 01:13:04 -0700
X-Trace: forums-1-dub 1278576784 10.22.241.152 (8 Jul 2010 01:13:04 -0700)
X-Original-Trace: 8 Jul 2010 01:13:04 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.objects:10012
Article PK: 712567

Hi,

From what I know, to have different series in a DW with Graph presentation
style you have to adjust your SQL Select statement. There you should
retrieve a column by which you can distinguish different series. I mean, if
you have just 2 columns retrieved - one for the category and one for the
value axis, add 1 more group distinguishing column and retrieve all the
(category,value) pairs corresponding to both of your series as rows in the
query.

HTH,
Ivaylo

<roneno> wrote in message news:4c357b69.606b.1681692777@sybase.com...
> Hello,
>
> The attached picture is a painter of graph DW. When I mark
> the series chekbox I get only one field to add a series.
> The SQL of my datawindow require 2. how can I define another
> series?
>
> (There is a function: AddSeries but it's only for graph
> object, not for DW graph)
>
> Thank you
>


Roneno Posted on 2010-07-08 09:39:19.0Z
Sender: 63ac.4c359869.1804289383@sybase.com
From: roneno
Newsgroups: sybase.public.powerbuilder.objects
Subject: Re: Adding Series To Stacked Graph
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4c359cc7.6419.1681692777@sybase.com>
References: <4c358890@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 8 Jul 2010 02:39:19 -0700
X-Trace: forums-1-dub 1278581959 10.22.241.41 (8 Jul 2010 02:39:19 -0700)
X-Original-Trace: 8 Jul 2010 02:39:19 -0700, 10.22.241.41
Lines: 38
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.objects:10013
Article PK: 712568

Hi,

What do you mean a column that retrieve pairs as rows?
I tried to concatenate the 2 separate columns of the series
to one column, but it did not work.

> Hi,
>
> From what I know, to have different series in a DW with
> Graph presentation style you have to adjust your SQL
> Select statement. There you should retrieve a column by
> which you can distinguish different series. I mean, if
> you have just 2 columns retrieved - one for the category
> and one for the value axis, add 1 more group
> distinguishing column and retrieve all the (category
> ,value) pairs corresponding to both of your series as rows
> in the query.
>
> HTH,
> Ivaylo
>
> <roneno> wrote in message
> > news:4c357b69.606b.1681692777@sybase.com... Hello,
> >
> > The attached picture is a painter of graph DW. When I
> > mark the series chekbox I get only one field to add a
> > series. The SQL of my datawindow require 2. how can I
> > define another series?
> >
> > (There is a function: AddSeries but it's only for graph
> > object, not for DW graph)
> >
> > Thank you
> >
>
>