Focal Point Banner


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.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Sankey Chart in Webfocus

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] Sankey Chart in Webfocus
 Login/Join
 
Leela Krishna
Silver Member
posted
Hi Everyone,

I have a requirement to create a Sankey chart in Webfocus, I was wondering if it is possible to create a Sankey in Webfocus. Has anyone done this before? Any advise or input on how to create Sankey would be helpful and greatly appreciated.

Regards
Leela krishna

This message has been edited. Last edited by: FP Mod Chuck,


WebFOCUS 8
Windows, All Outputs
 
Posts: 29 | Registered: January 07, 2016Report This Post
jcannavo
Platinum Member
posted Hide Post
Don't have experience with it, but I vaguely remembered reading something about WF extensions and Sankey. Dug up this post from 2017, maybe it will be helpful...good luck!

http://forums.informationbuild...1057331/m/1437042686


JC
WebFOCUS Dev Studio / App Studio
8.2.01
Windows 7
 
Posts: 146 | Registered: November 09, 2015Report This Post
Frans
Guru
posted Hide Post
Yes this is working, I haven't figured out so far how to get connecting nodes, only source and target nodes so far.


Test: WF 8.2
Prod: WF 8.2
DB: Progress, REST, IBM UniVerse/UniData, SQLServer, MySQL, PostgreSQL, Oracle, Greenplum, Athena.
 
Posts: 454 | Location: Europe | Registered: February 05, 2007Report This Post
Dave
Master
posted Hide Post
I once made one with Google-graphs...

-HTMLFORM BEGIN
<!DOCTYPE html>
<html>
<body>
<head>
<script type="text/javascript"
  src="https://www.google.com/jsapi?autoload={'modules':[{'name':'visualization','version':'1.1','packages':['sankey']}]}">
</script>
<div id="sankey_basic" style="width: 400px; height: 600px;"></div>

<script type="text/javascript">
google.setOnLoadCallback(drawChart);

   function drawChart() {
    var data = new google.visualization.DataTable();
    data.addColumn('string', 'From');
    data.addColumn('string', 'To');
    data.addColumn('number', 'Weight');
    data.addRows([
-HTMLFORM END

SET NODATA = 'null'
SET HOLDLIST = PRINTONLY

-* Generate Javascript data
DEFINE FILE CAR
	SEP/A2 = ', ';
END

TABLE FILE CAR
SUM
	COMPUTE LINESTART/A13 = '['; AS ''
	COMPUTE AXIS1/A80 = '''' || EDIT(FST.SEATS) || '''' ; AS ''
	SEP AS ''
	COMPUTE AXIS2/A80 = '''' || FST.COUNTRY || ''''; AS ''
	SEP AS ''
	SALES/D12c	AS ''
	COMPUTE LINEEND/A3 =  '],'; AS ''
	BY	SEATS NOPRINT
	BY	COUNTRY NOPRINT
ON TABLE PCHOLD FORMAT ALPHA
END
-RUN

-HTMLFORM BEGIN
		    ]);

    // Set chart options
    var options = {
      width:400,
	  height:600,
    };

    // Instantiate and draw our chart, passing in some options.
    var chart = new google.visualization.Sankey(document.getElementById('sankey_basic'));
    chart.draw(data, options);
   }
</script>
</head>
</html>


_____________________
WF: 8.0.0.9 > going 8.2.0.5
 
Posts: 668 | Location: Veghel, The Netherlands | Registered: February 16, 2010Report This Post
Leela Krishna
Silver Member
posted Hide Post
Hi Dave,

Thanks for sharing the sample code, that's a good one.

Regards
Leela krishna


WebFOCUS 8
Windows, All Outputs
 
Posts: 29 | Registered: January 07, 2016Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Sankey Chart in Webfocus

Copyright © 1996-2020 Information Builders