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] Info Assist Multi-Graph
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] Info Assist Multi-Graph
 Login/Join
 
Gold member
posted
Hi, when graph data using multi-graph in info assist different graphs change the x axis if there is no data, this is a great feature however for this report i need it disabled.

Example:
on my x axis i have date (7 days) for example and on my y axis i have hours for example. I'm using the multi-graph feature to show different departments however i would like to show the same 7 day date on x axis across all graphs. if there a department with no hours it will remove that day.

where can i find the option to show all data on each graph?

This message has been edited. Last edited by: <Kathryn Henning>,


WebFocus 8.02, SQL Server 2008r2
 
Posts: 51 | Registered: November 30, 2012Reply With QuoteReport This Post
Member
posted Hide Post
You could try fixing the presented columns by forcing the across sort order to what you need. This can be done by using the ACROSS and COLUMNS command.

Like this..

GRAPH FILE CAR
SUM SALES
ACROSS COUNTRY
COLUMNS 'A' AND 'B' AND 'ENGLAND' AND 'FRANCE' AND 'ITALY' AND 'JAPAN' AND 'W GERMANY'
END


Erfan


WebFOCUS 77, Windows, HTML PDF EXCEL
 
Posts: 11 | Registered: November 28, 2011Reply With QuoteReport This Post
Gold member
posted Hide Post
hi ebaig,

That is perfect it works like a charm. I didn't see this option anywhere in info assist but when you code it in it works.

Thank you,


WebFocus 8.02, SQL Server 2008r2
 
Posts: 51 | Registered: November 30, 2012Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Info Assist Multi-Graph

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