![]() |
||||||||||||
Go ![]() | New ![]() | Search ![]() | Notify ![]() | Tools ![]() | Reply ![]() | ![]() |
Gold member |
Hi Folks, 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, WebFOCUS 8201, SP 0.1, Windows 7, HTML | ||
|
Virtuoso |
ENGINE INT CACHE SET ON SET PAGE-NUM=NOLEAD -DEFAULTH &WF_HTMLENCODE=OFF; SET HTMLENCODE=&WF_HTMLENCODE SET ARGRAPHENGINE=JSCHART -DEFAULTH &WF_EMPTYREPORT=ON; SET EMPTYREPORT=&WF_EMPTYREPORT SET EMBEDHEADING=ON SET GRAPHDEFAULT=OFF -DEFAULTH &WF_STYLE_UNITS='PIXELS'; -DEFAULTH &WF_STYLE_HEIGHT='405.0'; -DEFAULTH &WF_STYLE_WIDTH='770.0'; -DEFAULTH &WF_TITLE='WebFOCUS Report'; GRAPH FILE retail_samples/wf_retail -* Created by Info Assist for Graph SUM WF_RETAIL.WF_RETAIL_SALES.REVENUE_US WF_RETAIL.WF_RETAIL_SALES.GROSS_PROFIT_US WF_RETAIL.WF_RETAIL_SALES.QUANTITY_SOLD BY WF_RETAIL.WF_RETAIL_TIME_SALES.TIME_DATE_DAY_COMPONENT 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 * *GRAPH_SCRIPT setPieDepth(0); setPieTilt(0); setDepthRadius(0); setCurveFitEquationDisplay(false); setPlace(true); *END INCLUDE=IBFS:/FILE/IBI_HTML_DIR/ibi_themes/Warm.sty,$ 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), $ *GRAPH_SCRIPT setReportParsingErrors(false); setSelectionEnableMove(false); setSeriesType(2,3); *GRAPH_JS_FINAL "pieProperties": { "holeSize": "0%" }, "agnosticSettings": { "dual": true, "chartTypeFullName": "Bar_Clustered_Dual_Axis" } *END ENDSTYLE END -RUN WebFOCUS 8204, Unix, Windows | |||
|
Gold member |
Great... thank you... Thanks for the fish but teach me how to fish... please? Kidding... I'm sure you used some kind of resource for this. What is it? I need some good documentation where I can see what is possible. WebFOCUS 8201, SP 0.1, Windows 7, HTML | |||
|
Virtuoso |
It was all done in InfoAssist. https://webfocusinfocenter.inf...pdfs4/wfinfoasst.pdf Select Format Tab, Other, Vertical Dual Axis Clustered Bar chart type. Put Revenue and Profit on the Vertical Axis 1, Quantity on the Vertical Axis 2. Put Date on X Axis. Click Series Tab Select Quantity Sold and change it's Chart Type to Area. WebFOCUS 8204, Unix, Windows | |||
|
Gold member |
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, WebFOCUS 8201, SP 0.1, Windows 7, HTML | |||
|
Powered by Social Strata |
![]() | Please Wait. Your request is being processed... |
|