Focal Point
[SOLVED] Info Assist Multi-Graph

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

May 15, 2013, 09:20 AM
cs_source
[SOLVED] Info Assist Multi-Graph
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
May 16, 2013, 02:16 PM
ebaig
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
May 17, 2013, 01:17 PM
cs_source
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