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.
New TIBCO Community Coming Soon
In early summer, TIBCO plans to launch a new community—with a new user experience, enhanced search, and expanded capabilities for member engagement with answers and discussions! In advance of that, the current myibi community will be retired on April 30. We will continue to provide updates here on both the retirement of myibi and the new community launch.
What You Need to Know about Our New Community
We value the wealth of knowledge and engagement shared by community members and hope the new community will continue cultivating networking, knowledge sharing, and discussion.
During the transition period, from April 20th until the new community is launched this summer, myibi users should access the TIBCO WebFOCUS page to engage.
I've spent too much time on this. I think it should be simple enough, but I can't figure it out. I would like to show three measures, the first series should be an Area graph, while the other two are vertical bars. The first series should also have its own axis on the right side of the graph otherwise it dwarfs the rest of the data.
I've seen several examples on how to do this, such as Francis' right here, but I would also like to see a scroll bar along the x-axis. I have many labels along the x-axis, so instead of things getting too small/tight, I need to be able to scroll the x-axis. The bars need to be clustered too, not stacked like in Francis' example above.
I got pretty far in what I wanted to do, but I couldn't get the bar chart to be horizontal, with both axes, and with the scroll bar. I'm working off code generated in InfoAssist to get me the scroll bar, but I can't seem to merge that into Francis' example above (or vice versa). I think my problem lies with the what shows up after ON GRAPH SET GRAPHSTYLE vs GRAPH_SCRIPT. I believe I can't use the same code between those two different wrappers.
Again, I've spent just too much time on this. Its silly really. Sometimes a change turns Francis' vertical bars into horizontal. Other times the graph is huge. Other times I have vertical bars (which is good), but I lose the second y-axis. I did create an example with CAR, but there aren't enough labels (x-axis) labels to warrant a scroll bar, so that isn't a good example anyway. Francis' example in that thread above should recreate most of what I'm trying to do, however I want to 1) show clustered bars (which I was able to pull together 2) show one of the series on a separate axis and 3) this series should also be an Area graph (or line) and 4) I need that scroll bar Is this something I can create a ticket for?
Here's a more general question. I've taken quite a bit of training, but I don't see me using much of it. The gui interface training I had is fine, but I always hit some kind of roadblock there, so I'm forced to use the code. I like using code (more control and what not), but its hard to know what is possible with only code. And of course, once I start mucking around with the code I can't use the gui anymore. So I guess my question is, what training should I be looking for? For example what's the difference of GRAPHSTYLE vs GRAPHSCRIPT vs ON GRAPH STYLE? Or perhaps one of you could direct me to some good documentation for such things?This message has been edited. Last edited by: Shingles,
ENGINE INT CACHE SET ON
-DEFAULTH &WF_TITLE='WebFOCUS Report';
GRAPH FILE retail_samples/wf_retail
-* Created by Info Assist for Graph
ON GRAPH PCHOLD FORMAT JSCHART
ON GRAPH SET VZERO OFF
ON GRAPH SET GRWIDTH 1
ON GRAPH SET UNITS &WF_STYLE_UNITS
ON GRAPH SET HAXIS &WF_STYLE_WIDTH
ON GRAPH SET VAXIS &WF_STYLE_HEIGHT
ON GRAPH SET LOOKGRAPH BAR
ON GRAPH SET AUTOFIT ON
ON GRAPH SET STYLE *
TYPE=REPORT, TITLETEXT=&WF_TITLE.QUOTEDSTRING, ORIENTATION=LANDSCAPE, $
TYPE=DATA, COLUMN=N1, BUCKET=x-axis, $
TYPE=DATA, COLUMN=N2, BUCKET=y-axis(1), $
TYPE=DATA, COLUMN=N3, BUCKET=y-axis(1), $
TYPE=DATA, COLUMN=N4, BUCKET=y-axis(2), $
WebFOCUS 8206, Unix, Windows
Posts: 1853 | Location: New York City | Registered: December 30, 2015
Ah... I see it now... I didn't pay close enough attention to the list of bar chart types. I just picked the first vertical cluster bar chart. I kept trying to look for an option or setting to change in IA to add the second axis.
I come from the Cognos world and that's how things worked there. More specifically, we choose the general chart type and then customize it to meet our needs. But this is easier. Thank you very much.This message has been edited. Last edited by: Shingles,