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 TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.
From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
Request access to the private WebFOCUS User Group (login required) to network with fellow members.
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 firstname.lastname@example.org for further assistance. Reference the community FAQ to learn more about the community.
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,