sort on sum field

is there any way we can sort the SUM field in Graph,
here is my GRAPH Request, it's producing Attaiment Bars for each DIVISION.
bars are sorting on DIVISION, But i want to sort on ATT01.
Thanks in advance.

GRAPH FILE HOLDS
HEADING
"SUM ATT01 AS ''
ACROSS DIVISION AS ' '
BY CUSTOMER
ON GRAPH SET LOOKGRAPH HBAR
ON GRAPH SET GRAPHEDIT SERVER
ON GRAPH SET BARNUMB ON
ON GRAPH SET 3D OFF
ON GRAPH SET VZERO ON
ON GRAPH SET GRID ON
ON GRAPH SET VAXIS 400
ON GRAPH SET HAXIS 800
ON GRAPH SET GRWIDTH 0
ON GRAPH SET GRAPHSTYLE *

-* Graph style

ENDSTYLE
END

Env Prod:WebFOCUS 7702 ,Windows xp on 64, SQL Server 2008, IRF Tool
Env 1 Local: DevStudio 7702 - MS Windows XP SP2 - Apache Tomcat 5.0.28
Output: HTML, Excel and PDF

Posts: 52 | Location: NJ,USA | Registered: May 26, 2004

Francis Mariani

Expert

posted

Hide Post

Here's what we've done:

TABLE FILE HSALR2
SUM
COMPUTE CTR/I1 = CTR + 1; NOPRINT
COMPUTE RGNX/A57 =
IF CTR EQ 1 THEN '''' || RGN || '''' ELSE ' AND ' | ('''' || RGN || '''');

BY HIGHEST AMOUNT NOPRINT

ON TABLE SAVE AS HSORTORD
END
-RUN

GRAPH FILE HSALR2
SUM
AMOUNT AS ''
ACROSS RGN AS ''

COLUMNS
-INCLUDE HSORTORD

ON TABLE HOLD AS GEIDS1 FORMAT HTMTABLE
...

I'll explain if it's required.

Cheers.

Francis

Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server

Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005

Ignored post by Francis Mariani posted

Show Post

wf1998

Gold member

posted

Hide Post

Hi francis,

it will work for one Graph, but it's not working multiple graphs in a single graph request, is there any dynamic way to do it.
-Raj

Env Prod:WebFOCUS 7702 ,Windows xp on 64, SQL Server 2008, IRF Tool
Env 1 Local: DevStudio 7702 - MS Windows XP SP2 - Apache Tomcat 5.0.28
Output: HTML, Excel and PDF

Posts: 52 | Location: NJ,USA | Registered: May 26, 2004

Ignored post by wf1998 posted

Show Post

Kerry

Expert

posted

Hide Post

Hi Raj,

Has this issue been resolved on your side?

I am wondering, when you say "it will work for one Graph, but it's not working multiple graphs in a single graph request", will it work if you run one request for each graph? Will the output be the same as expected?

Here is some info from our product management, which may be of interest:
Customize Graph dynamically
https://forums.informationbuilders.com/eve/forums/a/tpc/...421084941#2421084941

Hope it helps.