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, Not Dreaming] Multiple Graphs From One GRAPH FILE Command. . .am I dreaming?
Go
New
Search
Notify
Tools
Reply
  
[SOLVED, Not Dreaming] Multiple Graphs From One GRAPH FILE Command. . .am I dreaming?
 Login/Join
 
Master
posted
I seem to recall that I was able to produce multiple graphs from a single GRAPH FILE command in the past, from judicious use of BY and ACROSS. HTML output. This would have been years back.

Am I just dreaming that? Don't hold back if I was. I seem to recall stumbling upon it and being pleasantly surprised.

I'm beginning the think I've forgotten more than I currently know.

This message has been edited. Last edited by: John_Edwards,



 
Posts: 894 | Location: At the Mast | Registered: May 17, 2007Reply With QuoteReport This Post
Expert
posted Hide Post
Do you mean something like this?

Select 'Chart' then, add State to Rows (under Matrix), and Product in Columns, and Dollar Sales in Color, and Unit Sales in Size?

You can select Multi-Pies from the Other icon on the formatting tab.

Or what?
 
Posts: 2914 | Location: Middle Tennessee [8204M Gen48 in Test&Prod] | Registered: February 23, 2005Reply With QuoteReport This Post
Gold member
posted Hide Post
Hi John,
are you referring to using GRMERGE settings
If you set it to ON you will see one garph while the bellow code will generate multiple graphs.

 GRAPH FILE CAR
SUM
SALES
BY CAR
ACROSS COUNTRY
ON GRAPH PCHOLD FORMAT JSCHART
ON GRAPH SET VZERO OFF
ON GRAPH SET GRWIDTH 1
ON GRAPH SET GRMERGE OFF
ON GRAPH SET LOOKGRAPH BAR
ON GRAPH SET AUTOFIT ON
ON GRAPH SET STYLE *
ENDSTYLE
END 


WF 8.2.04
Windows/Unix
All Formats
In Focus since 2006
 
Posts: 74 | Location: UK | Registered: September 17, 2018Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Don't know which version you are using but looking starting page 143 may help :
Creating HTML5 Charts


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: 1990 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013Reply With QuoteReport This Post
Master
posted Hide Post
quote:
Originally posted by Addy:
Hi John,
are you referring to using GRMERGE settings
If you set it to ON you will see one graph while the below code will generate multiple graphs.

ON GRAPH SET GRMERGE OFF
 


BooYah! I'm buying the next round for Addy!


.

This message has been edited. Last edited by: John_Edwards,



 
Posts: 894 | Location: At the Mast | Registered: May 17, 2007Reply With QuoteReport This Post
Master
posted Hide Post
I'll mention that I'm still getting an odd effect. This is a date driven report where I want to display each month as a separate graph (one bar per day). January works perfectly, starting January 1 and going through January 31. February starts on January 1 and shows no data for the first 31 bars, then shows February's days. March starts on January 1 and shows no data for the first 59 bars, then shows March's days.

So I need to figure out how to limit display to just the days shown in the month. But I'll work with that. Haven't gotten into debug mode on it yet. Edit -- Got it. Got rid of ACROSS and just used BYs, changed a few settings. Everything is trimmed up now.

Thank you Addy for reaffirming my sanity, I knew I remembered seeing multiple graphs from a single request in prior versions.

Thank you all!

This message has been edited. Last edited by: John_Edwards,



 
Posts: 894 | Location: At the Mast | Registered: May 17, 2007Reply With QuoteReport This Post
Expert
posted Hide Post
I'll join you for that next round, and buy the one after that...

John: Where's 'The Mast'?
Addy: Will Popeye be there too?


   See you at Summit! In FOCUS Since 1983 ~ from PC FOCUS to WebFOCUS.
   Currrently using 8204 Gen 48 in Test and Production.
   KGPCo at CenturyLink. October 2017 to Present...
 
Posts: 2914 | Location: Middle Tennessee [8204M Gen48 in Test&Prod] | Registered: February 23, 2005Reply With QuoteReport This Post
Master
posted Hide Post
quote:
Originally posted by Doug:
John: Where's 'The Mast'?


Right where you would expect it, about midway between the Stern and the Bow.

I was a competitive sailor for years on the Chesapeake Bay, generally worked the mast. Occasionally I was on the Bow (I'm big and kinda klutzy so this is a bad thing, but I knew the job) or was sometimes in the Pit. But I was the first stringer at the mast.

It's odd how you're "on" the Bow, but "at" the Mast, or "in" the Pit. But there it is.

Home is just outside of Annapolis Maryland. I'll buy you a drink at Middleton's if you're up this way.

This message has been edited. Last edited by: John_Edwards,



 
Posts: 894 | Location: At the Mast | Registered: May 17, 2007Reply With QuoteReport This Post
Expert
posted Hide Post
Thanks John, I (actually) knew where the mast would be. But didn't know, and thanks for, the details about your sailing experiences. I didn't do much, but, I was 'in the pit' / 'Gadget Man' on the Great South Bay of Long Island.
 
Posts: 2914 | Location: Middle Tennessee [8204M Gen48 in Test&Prod] | Registered: February 23, 2005Reply With QuoteReport This Post
Master
posted Hide Post
Nice part of the world to sail. I did the 'Round Long Island race a couple of times back in the 90s.



 
Posts: 894 | Location: At the Mast | Registered: May 17, 2007Reply With QuoteReport This Post
Gold member
posted Hide Post
quote:
Originally posted by Doug:
I'll join you for that next round, and buy the one after that...

John: Where's 'The Mast'?
Addy: Will Popeye be there too?


Oh Yes Popeye will be there with Sailor John.. the round after next to next is on me Smiler


WF 8.2.04
Windows/Unix
All Formats
In Focus since 2006
 
Posts: 74 | Location: UK | Registered: September 17, 2018Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED, Not Dreaming] Multiple Graphs From One GRAPH FILE Command. . .am I dreaming?

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