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 community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.
This took a little longer than intended owing to request to add the chart header (title) and positioning of the legend (top or bottom only) - controlled from GUI options.
If you have any feedback, please provide this via GitHub only. Thank you.
T
This message has been edited. Last edited by: Tony A,
In FOCUS since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2
WebFOCUS App Studio 8.2.06 standalone on Windows 10
Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004
Thanks for the extension. I am going to currently fork it to just accepts 3 since that how i want for my survey . Btw did you have find way to send to drill separate reports for separate measures. Webfocus extension seems to have a limitation where it considers all the measure as the same series .
Thanks, Aswin Ravikumar
Webfocus 8.1 Windows x64 Excel
Posts: 39 | Location: Pittsburgh | Registered: July 25, 2017
The donor code was from the same chart type on D3js.org and, if you had been at my session in Orlando, you would have heard me say that the same series was intended - I wanted to demonstrate the limitation having them in one series and trying to assign more than one colour.
As for having to fork it to your own needs, be my guest, but I would be inclined to firstly see if making the first and fifth replies as zero, changing their titles to blanks and the colours to white or even try transparent (using rgba).
I have just tried the latter and it works fine - it will save you having to mess with a fork!
T
In FOCUS since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2
WebFOCUS App Studio 8.2.06 standalone on Windows 10
Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004
Originally posted by Tony A: Hmmm, just noticed that your signature states 8.1 - I do hope that is wrong and that you haven't updated it!!
We are still in the migration phase where generate excel from 8105 and dashboards/charts from 8205.
GRAPH FILE likert_data
SUM COMPUTE DUMMY1/D12.2 MISSING ON =0; AS ' '
LIKERT_DATA.SEG01.STRONGDISAGREE AS 'Disagree'
LIKERT_DATA.SEG01.NEITHER AS 'Neutral'
LIKERT_DATA.SEG01.STRONGAGREE AS 'Agree'
COMPUTE DUMMY2/D12.2 MISSING ON =0; AS ' '
BY LIKERT_DATA.SEG01.Q_NUM NOPRINT
BY LIKERT_DATA.SEG01.QUESTION
WHERE LIKERT_DATA.SEG01.SOURCE EQ 'Sample 2';
ON GRAPH PCHOLD FORMAT JSCHART
ON GRAPH SET VZERO OFF
ON GRAPH SET GRWIDTH 1
ON GRAPH SET LOOKGRAPH EXTENSION
ON GRAPH SET AUTOFIT ON
ON GRAPH SET STYLE *
*GRAPH_SCRIPT
setPieDepth(0);
setPieTilt(0);
setDepthRadius(0);
setPlace(true);
setCurveFitEquationDisplay(false);
*END
INCLUDE=IBFS:/FILE/IBI_HTML_DIR/ibi_themes/Warm.sty,$
TYPE=REPORT, PAGESIZE=A4, $
TYPE=DATA, COLUMN=N1, BUCKET= >Question, $
TYPE=DATA, COLUMN=N2, BUCKET= >Question, $
TYPE=DATA, COLUMN=N3, BUCKET= >replies, $
TYPE=DATA, COLUMN=N4, BUCKET= >replies, $
TYPE=DATA, COLUMN=N5, BUCKET= >replies, $
TYPE=DATA, COLUMN=N6, BUCKET= >replies, $
TYPE=DATA, COLUMN=N7, BUCKET= >replies, $
*GRAPH_SCRIPT
setReportParsingErrors(false);
setSelectionEnableMove(false);
*GRAPH_JS_FINAL
"extensions": {
"com.ibi.divergent": {
"useSeriesColours": false,
"colors": ["rgba(255,255,255,0)", "#f6a580", "#cccccc", "#92c6db", "#ffffff"]
}
},
"pieProperties": {
"holeSize": "0%"
},
"chartType": "com.ibi.divergent",
"agnosticSettings": {
"chartTypeFullName": "com.ibi.divergent"
}
*END
ENDSTYLE
END
Thanks for the code Tony. It works the way i wanted. I couldn't attend summit this year, but is there any way we could get around with the single series limitation ? . I build a versions of KPI charts where it accepts multiple rows of supporting measures ( Sample Image ) . Users wants to click on each measure to get different report outputs based on the measure they click and I can only provide one drill for the entire kpi.
Wish we had a proper documentation on moonbeans api.
Thanks, Aswin Ravikumar
Webfocus 8.1 Windows x64 Excel
Posts: 39 | Location: Pittsburgh | Registered: July 25, 2017
If I read your response correctly, you have 2 questions/requests -
Modification of Divergent to have 5 individual "reply" buckets rather than just the 1 it has been built with.
How-to add drilldown links into your version of the KPI extension.
If I have those correct then then first would require some thought and effort. What is your specific issue with only 1 bucket?
The second would need knowledge of the KPI extension that you are using (also, which one did you start with - I am guessing kpi_table?).
Neither of these are something that my current / upcoming work duties allow me
I did add drilldown potential to com.ibi.dendrorag which is configurable within the properties.json file. You could use that as an example to derive how you need to extend your code. It should not be too onerous (I think) as the KPI_table extension essentially creates an HTML table.
Good luck
T
In FOCUS since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2
WebFOCUS App Studio 8.2.06 standalone on Windows 10
Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004
Modification of Divergent to have 5 individual "reply" buckets rather than just the 1 it has been built with.
How-to add drilldown links into your version of the KPI extension.
Yes i used the KPI Table to create this extension and I am actually good with having just one bucket.I am able to create drill down in my extension but not able to have different drills for different measures, i.e I am not able pass which measure i clicked in an parameter to the targeted report.
Thanks, Aswin Ravikumar
Webfocus 8.1 Windows x64 Excel
Posts: 39 | Location: Pittsburgh | Registered: July 25, 2017