Focal Point
[SOLVED] horizontal bar graph (bar graph values should to show at right side of bar)

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

November 07, 2017, 03:35 AM
Developer
[SOLVED] horizontal bar graph (bar graph values should to show at right side of bar)
Hi have req to show same as below graph code ,

but below code the value is showing left side of the bar graph ,but i want to show the values right side of the bar graph.

DEFINE FILE GGSALES
DIFFERENCE/D7M=BUDDOLLARS-DOLLARS;
END

TABLE FILE GGSALES
BY CITY
SUM BUDDOLLARS/D7M DOLLARS/D7M DIFFERENCE
ON TABLE SET PAGE-NUM OFF
ON TABLE SET STYLE *
GRID=OFF, $
GRAPHTYPE=DATA, COLUMN=N4, $
ENDSTYLE
END


Thank you

This message has been edited. Last edited by: FP Mod Chuck,


WebFOCUS 8202
November 07, 2017, 07:28 AM
Kofi
quote:
GRAPHTYPE=DATA, COLUMN=N4, $

This is being inline graph per data.

You want keep first DIFFERENCE column with making text "invisible" so inline graph show still. Then add DIFFERENCE to give value. This is being one way -
DEFINE FILE GGSALES
DIFFERENCE/D7M=BUDDOLLARS-DOLLARS;
END

TABLE FILE GGSALES
BY CITY
SUM BUDDOLLARS/D7M DOLLARS/D7M DIFFERENCE AS '' DIFFERENCE
ON TABLE SET PAGE-NUM OFF
ON TABLE SET STYLE *
GRID=OFF, $
TYPE=DATA, COLUMN=N4, SIZE=1, COLOR=WHITE, $ 
GRAPHTYPE=DATA, COLUMN=N4, $
ENDSTYLE
END

Kofi


Client Server 8.1.05: Apache; Tomcat;Windows Server 2012
Reporting Server 8.1.05; Oracle; MS SQL; Windows Server 2012
November 07, 2017, 08:16 AM
MartinY
Developer,

The feature that your are using is the WF data "Visualize" and, as far as I know, there is not option to change its position.

Kofi option is a good one but the Difference data is displayed twice : on left and right side of the visualisation. The only thing AS '' is doing is to "remove" the title and if you put NOPRINT the whole column (data and visualize) will be hidden.

Using Kofi suggestion, I made some changes. This is still not perfect but I think that it's the best we can do.

DEFINE FILE GGSALES
DIFFERENCE/D7M=BUDDOLLARS-DOLLARS;
END

TABLE FILE GGSALES
SUM  BUDDOLLARS/D7M
     DOLLARS/D7M
     DIFFERENCE AS ''
     DIFFERENCE
BY CITY
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE SET STYLE *
$
     GRAPHTYPE=DATA,
     COLUMN=N4,
$
TYPE=REPORT,
     GRID=OFF,
$
TYPE=DATA,
     COLUMN=N4,
     COLOR='WHITE',
$
TYPE=REPORT,
     COLUMN=N4,
     SQUEEZE=0.1,
$
ENDSTYLE
END



WF versions : Prod 8.2.0.1M gen 240, Dev 8.2.04 gen 48, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
November 07, 2017, 09:39 AM
Kofi
quote:
SIZE=1,

Like be said, SIZE important! - this time being reduce column "hidden"! Razzer

Kofi


Client Server 8.1.05: Apache; Tomcat;Windows Server 2012
Reporting Server 8.1.05; Oracle; MS SQL; Windows Server 2012
November 07, 2017, 10:34 AM
MartinY
quote:

TYPE=DATA, COLUMN=N4, SIZE=1, COLOR=WHITE, $


Right Kofi, I haven't pay attention to that line.
But it make the visualize really tiny. So I'll keep it at least at SIZE=4.


WF versions : Prod 8.2.0.1M gen 240, Dev 8.2.04 gen 48, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
November 07, 2017, 10:49 AM
Kofi
quote:
But it make the visualize really tiny.

Not being this for me on 8.2.01, only text being made small. Visualization still being size of same?

I not be try awkward but funny when say SIZE important. Many jokes be when this be said Razzer

Kofi


Client Server 8.1.05: Apache; Tomcat;Windows Server 2012
Reporting Server 8.1.05; Oracle; MS SQL; Windows Server 2012