Below is portion of code for InfoAssist Bar Graph displaying BUSINESS_UNIT ON X Axis and SUM.VTotalHrs on Y Axis. Is there a way to sort the Graph by SUM.VTotalHrs across the chart descending to ascending?
DEFINE FILE F4801 VTotalHrs/D12.2=J0.F3112.ACTUAL_SETUP_HOURS + J0.F3112.ACTUAL_RUN_LABOR + J0.F3112.ACTUAL_RUN_MACHINE ; VStart/MDYY=F4801.F4801.COMPLETED ; VStop/MDYY=F4801.F4801.COMPLETED ; VDesc/A30=SUBSTR ( 30 , F4801.F4801.DESCRIPTION , 1 , 4 , 3 , 'VDesc' ) ; END GRAPH FILE F4801 -SET &SECTION='WHERE'; -INCLUDE swomfgo5/mrv/new_reporting_object.fex -* Created by Info Assist for Graph SUM SUM.VTotalHrs AS 'Work Center Hrs' BY J0.F3112.A__BUISNESS_UNIT WHERE F4801.F4801.BRANCH EQ ' 10160'; WHERE F4801.F4801.DESCRIPTION CONTAINS '&DESCRIPTION.Enter Description.'; ON GRAPH PCHOLD FORMAT PDF ON GRAPH SET HAXIS 770 ON GRAPH SET VAXIS 405 ON GRAPH SET UNITS PIXELS ON GRAPH SET LOOKGRAPH VBAR ON GRAPH SET HTMLENCODE ON ON GRAPH SET GRAPHDEFAULT OFF ON GRAPH SET VZERO OFF ON GRAPH SET GRMERGE ADVANCED ON GRAPH SET GRMULTIGRAPH 0 ON GRAPH SET GRLEGEND 0 ON GRAPH SET GRXAXIS 1 ON GRAPH SET GRAPHSTYLE *
setReportParsingErrors(false); setSelectionEnableMove(false); setDepthRadius(5); setCurveFitEquationDisplay(false); setDisplay(getDataText(0),false); setDisplay(getDataText(1),false); setDisplay(getDataText(2),false); setDisplay(getDataText(3),false); ------ setDisplay(getDataText(62),false); setDisplay(getDataText(63),false); setPlace(true); setTextRotation(getO1Label(),1); setTextString(getO1Title(),"Work Center"); setDisplay(getO1Title(),true); setTextString(getY1Title(),"Total Hrs by Description"); setDisplay(getY1Title(),true); ENDSTYLE ON GRAPH SET STYLE * INCLUDE=IBFS:/CFG/FILE/IBI_HTML_DIR/javaassist/intl/EN/ENIADefault_combine.sty,$ TYPE=REPORT, ORIENTATION=LANDSCAPE, $ ENDSTYLE ENDThis message has been edited. Last edited by: Kerry,
Dennis Parish
WebFOCUS 7.6 Windows, All Outputs
August 25, 2011, 05:26 PM
Kerry
Hi Dennis,
From our expert: if you want to display and sort by the same field, please try to drag the field to both the X and Y areas of the graph.
Cheers,
Kerry
Kerry Zhan Focal Point Moderator Information Builders, Inc.