Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] horizontal bar graph (bar graph values should to show at right side of bar)
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] horizontal bar graph (bar graph values should to show at right side of bar)
 Login/Join
 
Gold member
posted
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
 
Posts: 57 | Location: India | Registered: March 24, 2014Reply With QuoteReport This Post
Platinum Member
posted Hide Post
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
 
Posts: 103 | Registered: April 06, 2009Reply With QuoteReport This Post
Virtuoso
posted Hide Post
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
 
Posts: 2192 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013Reply With QuoteReport This Post
Platinum Member
posted Hide Post
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
 
Posts: 103 | Registered: April 06, 2009Reply With QuoteReport This Post
Virtuoso
posted Hide Post
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
 
Posts: 2192 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013Reply With QuoteReport This Post
Platinum Member
posted Hide Post
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
 
Posts: 103 | Registered: April 06, 2009Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] horizontal bar graph (bar graph values should to show at right side of bar)

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.