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] Need To Create A "Status" Tracking Pie Chart

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] Need To Create A "Status" Tracking Pie Chart
 Login/Join
 
Member
posted
In a similar fashion to how Pizza Hut has their tracker that lets you know what step the pizza is on as it is delivered to you, one of my clients wants to have a pie chart that tracks their work status. We have a piece of work that will move through a process, where it will receive a different "status" as it reaches certain criteria. Unfortunately I am unable to use Info Assist functionality to recreate this. Either it creates multiple pie charts for each status, or it only lets me use one at a time.

I am able to to make this happen with a bar chart, but my client is strongly pushing a pie chart.

I believe this will have to be done with a calculated field, where all of the different statuses are lumped into one field, and will be conditionally selected.

Any ideas or direction would be appreciated.

This message has been edited. Last edited by: FP Mod Chuck,
 
Posts: 3 | Registered: November 08, 2019Report This Post
Virtuoso
posted Hide Post
There are few chart extensions but I haven't seen one that fits this exact scenario. If you can find the chart type in github you could probably write a D3 extension for this spec.

What version of WebFOCUS are you using? It's not in your signature.


WebFOCUS 8206, Unix, Windows
 
Posts: 1853 | Location: New York City | Registered: December 30, 2015Report This Post
Expert
posted Hide Post
Here is a little something I cooked up.

You will need to set up an ajax call to get the status and update the chart accordingly.

Tested in v8.1.04 and v8.2.06

-MRNOEDIT EX -LINES * EDAPUT MASTER,PIZZA,CV,FILE
FILENAME=PIZZA, SUFFIX=FIX,$
SEGNAME=PIZZA, $
  FIELD=EVENT ,ALIAS=  ,A20,A20 ,$
  FIELD=TIME  ,ALIAS=  ,I9 ,A9 ,$
EDAPUT*

-MRNOEDIT EX -LINES * EDAPUT FOCTEMP,PIZZA,CV,FILE
1 Order Received            1
2 Order Prepared            1
3 Cooking                   1
4 Ready                     1
EDAPUT*

-RUN

FILEDEF PIZZA DISK pizza.ftm (LRECL 29 RECFM V

-RUN
GRAPH FILE PIZZA
SUM TIME AS ''
ACROSS EVENT AS ''
ON GRAPH PCHOLD FORMAT JSCHART
ON GRAPH SET LOOKGRAPH PIE
ON GRAPH SET HAXIS 600
ON GRAPH SET VAXIS 500
ON GRAPH SET STYLE *
*GRAPH_JS
introAnimation: {
   enabled: true,
   duration: 1000
},
pieProperties: {rotation:315},
series: [
   {series: 0, color: 'cyan', showDataValues:true, explodeSlice: 30},
   {series: 1, color: 'bisque', showDataValues:false},
   {series: 2, color: 'slateblue', showDataValues:false},
   {series: 3, color: 'red', showDataValues:false},
],
dataLabels: {
   visible: true, 
   formatCallback: function(d,s,g){var lbl = this.getSeries(s).label;return lbl ;}
}
*END
ENDSTYLE
END

-RUN

-HTMLFORM BEGIN
  <script>
	var myChart = null ;
	var pollNum = 1 ;
	setTimeout(getChart(), 5000);
	function getChart() {
		myChart = document.getElementById("jschart_HOLD_0").chart ;
		setTimeout(function() {poll();}, 5000);
	}
	function poll() {
		pollNum++;
		// ajax call to get current status goes here
		myChart.pieProperties.rotation = (myChart.pieProperties.rotation-90<0)?315:myChart.pieProperties.rotation-90;
		for (var s=1;s<myChart.series.length;s++) {
			myChart.series[s].explodeSlice=(s==pollNum)?30:0;
		}
		myChart.series[pollNum].showDataValues = true ;
		myChart.redraw(myChart.documentRoot);
		if (pollNum<4) setTimeout(function() {poll();}, 5000);
	}
  </script>

-HTMLFORM END
-RUN



Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
Member
posted Hide Post
@BabaNYC, we are running 8.2.3? I hope I am saying that right. I will definitely take a look at GitHub.
@Waz, I will give that a try and get back to you if I am stuck.
Thank you so much for the replies!
 
Posts: 3 | Registered: November 08, 2019Report This Post
Guru
posted Hide Post
Not sure if 8203 has this option but there is a feature to turn on "Real-time refresh" on a chart built using Designer. We see it on 8206 for sure.


-********************
Sandbox: 8206.10
Dev: 8201M
Prod:8009
-********************
 
Posts: 289 | Location: Houston,TX | Registered: June 11, 2004Report 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] Need To Create A "Status" Tracking Pie Chart

Copyright © 1996-2020 Information Builders