 |
|||||
|
As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Join the TIBCO Community
Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community. | |||||
Focal Point 
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point Stacked Bar Graph with UNStacked Lines??
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point Stacked Bar Graph with UNStacked Lines?? Read-Only TopicGo | Search | Notify | Tools |
| Stacked Bar Graph with UNStacked Lines?? | Login/Join |
| Platinum Member |
Logged a case today, but was hoping someone might have figured this one out... We're building a stacked bar graph that also has some series that are plotted as lines. However, we want the lines to NOT be stacked. I can't figure out a way to tell WebFOCUS to do this -- it always wants to stack the lines even though it does appear to treat the bars and lines as their own stacks... The only idea I have at the moment is to "adjust" the values of the series that are lines to be the difference between the current series and the previous series. Then it would essentially "counteract" the stacking and plot them where they should be. This sounds pretty painful, so I'm hoping someone else has a great idea that I haven't thought of yet. Think it's possible to plot 2 different graphs (with transparent backgrounds) and stack the images on top of each other? Production: 7.6.6 WF Server <=> 7.6.6 WF Client <=> 7.6.6 Dev Studio Testing: <none> Using MRE & BID. Connected to MS SQL Server 2005 Output Types: HTML, Excel, PDF | ||
|
| Expert |
Trav, The way that I do this is to use a dual axis stacked bar chart - setGraphType(20); and then assign the data ranges to either the left or right axis changing the plot type as required - ON GRAPH SET GRAPHSTYLE * -* Graphtype is Vertical Dual-Axis Stacked Bars setGraphType(20); setAxisAssignment(0,1); setSeriesType(0,1); setAxisAssignment(1,1); setSeriesType(1,1); setAxisAssignment(2,0); setSeriesType(2,2); An additional item that I use is a calculation of what data range is the highest, round that up to the next 100 and then set the max for each vertical axis to that value. T
| |||||||||
|
| Platinum Member |
Tony, I had tried that and unfortunately it still stacks the lines too. If I only have one line, then it works just fine, but as soon as you start adding more series plotted as lines, it starts stacking them. In my case I have 4 series that are plotted as stacked bars and 6+ series plotted as lines... Unless I missed something in your method? Production: 7.6.6 WF Server <=> 7.6.6 WF Client <=> 7.6.6 Dev Studio Testing: <none> Using MRE & BID. Connected to MS SQL Server 2005 Output Types: HTML, Excel, PDF | |||
|
| Platinum Member |
Also, for what it's worth, my theory on adjusting the values to be the difference between series didn't work because it stacks negative values below zero and positives above zero... Production: 7.6.6 WF Server <=> 7.6.6 WF Client <=> 7.6.6 Dev Studio Testing: <none> Using MRE & BID. Connected to MS SQL Server 2005 Output Types: HTML, Excel, PDF | |||
|
| Virtuoso |
Trav, I do not have WF 7.6 but I THINK I remember hearing this particular issue discussed at Summit 1 or 2 years ago and that it was going to be added to the abilities of the graph engine. Unfortunately I do not have a WF 7.6 install to experiment with to see if it IS in the product. May be the GRAPH gurus at IBI can answer this one. Thanks! Mickey
| |||||
|
| Expert |
Trav, No, it was me who missed your requirements!  As you will see from my post I only have three data series, two bars and one line. Works fine with that, but not for your situation. I think that you have already identified the only solution - by realignment of the data series values - the downside of this is the mouseover popups with the series values will be incorrect so it would be best to turn them off. Of course, your users are bound to want them back!!! Instead of realigning the line series data, how about just have a clustered bar chart and messing with the width of the bars and the overlap? Might work ... Good luck T
| |||||||||
|
| Platinum Member |
I messed with 7.6.1 but didn't have any luck there either. I think I've basically realized that I'm going to have to have Excel do the graph. IBI will probably love that, but that's how it goes I guess... Production: 7.6.6 WF Server <=> 7.6.6 WF Client <=> 7.6.6 Dev Studio Testing: <none> Using MRE & BID. Connected to MS SQL Server 2005 Output Types: HTML, Excel, PDF | |||
|
| Platinum Member |
Oh, I wish they were always this simple... setForceSeriesAbsolute(getSeries(0),true); Got this back from techsupport on our open case. This is an UNDOCUMENTED function/property. I searched through the 1396 page graphics document and it is NOT there. DocServices, are you listening?  Apparently it IS in the new features document for 713 though. Anyway, now that I know the function call, if I search on techsupport, I can find plenty of results and the answers that I need. Oddly enough though, until I knew the function name, I wasn't able to find anything with the various searches I tried. Almost too obvious now that I see the search results... *frustrated but pleased* Production: 7.6.6 WF Server <=> 7.6.6 WF Client <=> 7.6.6 Dev Studio Testing: <none> Using MRE & BID. Connected to MS SQL Server 2005 Output Types: HTML, Excel, PDF | |||
|
| Expert |
Trav, Thanks for feeding back on this very useful setting T
| |||||||||
|
| Expert |
Thanks Trav for posting this issue AND for posting the solution. The only thing I'll add to this that the line needs to be added for each of the series used in the graph and that the "0" needs to be changed to match the associated series. setForceSeriesAbsolute(getSeries(0),true); Thanks again. I was going to go to Tech Support for the answer and found it here in the WebFOCUS World instead. -Doug
| |||||
|
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only TopicFocal Point Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point Stacked Bar Graph with UNStacked Lines??
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point Stacked Bar Graph with UNStacked Lines??Copyright © 1996-2020 Information Builders
| View $GS_USERNAME's Public Profile |
| Add $GS_USERNAME to my Ignore List |
| View Recent Posts by $GS_USERNAME |
| Notify me of New Posts by $GS_USERNAME |