Based on sort value, assign data to graph series

Focal Point

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/1551048172

February 15, 2008, 07:46 PM

dballest

Based on sort value, assign data to graph series

Is there a way, based on the sort value, to assign the data to a particular series?

e.g.

Stacked graph (merge on status)
GRAPH FILE TEMPHOLD
SUM PCT.MINUTES
ACROSS DAY
BY STATUS

STATUS field contain data like RUNNING, IDLE, MAINTENANCE.

When I run the graph, my stacked bar for 1 day is having RUNNING, MAINTENANCE, IDLE sequence. I want the sequence to be from the top: MAINTENANCE, IDLE, RUNNING.

I checked the WF76 graphic reference and was not successful.

Thanks,
Dan

Dev: WebFOCUS 7.6.10, Data Migrator 7.6.10
QA: WebFOCUS 7.6.10, Data Migrator 7.6.10
Prod: WebFOCUS 7.6.2, Data Migrator 7.6.8
Windows 2K3, Tomcat 5.5.17, IIS 6
Usage: HTML, PDF, Excel, Self-serve, BID and MRE

February 16, 2008, 05:48 AM

FrankDutch

try

BY STATUS ROWS 'MAINTENANCE' AND 'IDLE' AND 'RUNNING'

	*Frank*
	prod: WF 7.6.10 platform Windows, databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7 test: WF 7.6.10 on the same platform and databases,IE7

February 19, 2008, 01:37 PM

dballest

Thanks Frank. That's what I need.

BY fielname ROWS fieldvalue OVER fieldvalue...