quote:I kinda wonder if at this point it would be easier to just use google charts to build it...
quote:D3 Charts are IBI approved and are actually easily added in 8.2..
-* File timeline.fex -* -* Create test data. -* APP FI BASEBALL DISK BASEBALL.MAS (LRECL 80 -RUN -WRITE BASEBALL -WRITE BASEBALL FILE=BASEBALL,SUFFIX=FOC -WRITE BASEBALL SEGNAME=SEG1 -WRITE BASEBALL FIELD=TEAM,,A20,A20,$ -WRITE BASEBALL FIELD=PLAYER,,A20,A20,$ -WRITE BASEBALL FIELD=BEGDATE,,A10,A10,$ -WRITE BASEBALL FIELD=ENDDATE,,A10,A10,$ -RUN CREATE FILE BASEBALL MODIFY FILE BASEBALL FIXFORM TEAM/A20 PLAYER/A20 BEGDATE/A10 ENDDATE/A10 DATA CHICAGO WHITE SOX Bill Melton 2015-01-012015-02-01 CHICAGO CUBS Ron Santo 2015-04-012015-05-25 MILWAUKEE BREWERS Cecil Cooper 2015-01-012015-04-01 MINNESOTA TWINS Herman Killebrew 2014-11-192015-11-19 MINNESOTA TWINS Rod Carew 2014-11-192015-06-19 MINNESOTA TWINS Rod Carew 2015-07-042015-07-04 MINNESOTA TWINS Rod Carew 2015-09-042015-09-10 MINNESOTA TWINS Rod Carew 2015-11-012015-11-30 END -RUN -* -* Create JSON for Google Timeline Chart Data Table. -* TABLE FILE BASEBALL PRINT TEAM NOPRINT COMPUTE OUTPUT/A511 = '[''' | TEAM || ''',''' || PLAYER || ''',' || 'new Date(''' || BEGDATE || '''),' || 'new Date(''' || ENDDATE || ''')],'; ON TABLE SET HOLDLIST PRINTONLY ON TABLE HOLD AS HLDDATA FORMAT ALPHA END -RUN -* -* Create Google Timeline chart and present to user. -* -HTMLFORM BEGIN <html> <head> <title>Star Players and Time Active</title> <script type="text/javascript" src="https://www.gstatic.com/charts/loader.js"></script> <script type="text/javascript"> google.charts.load("current", { packages: ["timeline"] }); google.charts.setOnLoadCallback(drawChart); function drawChart() { var container = document.getElementById('mytimeline'); var chart = new google.visualization.Timeline(container); var dataTable = new google.visualization.DataTable(); dataTable.addColumn({ type: 'string', id: 'Position' }); dataTable.addColumn({ type: 'string', id: 'Name' }); dataTable.addColumn({ type: 'date', id: 'Start' }); dataTable.addColumn({ type: 'date', id: 'End' }); dataTable.addRows([ !IBI.FIL.HLDDATA; ]); chart.draw(dataTable); } </script> </head> <body> <div id="mytimeline" style="height: 400px;"></div> </body> </html> -HTMLFORM END
SET LOOKGRAPH=GANTT Provides a visual representation of project oriented time critical events. Gantt charts require six display fields and one sort field, in that order. Conditional styling and drill-down are not supported for GANTT charts.
In FOCUS Since 1983 ~ from FOCUS to WebFOCUS. Current: WebFOCUS Administrator at FIS Worldpay | 8204, 8206 |
-* -* Create test data. -* APP FI BASEBALL DISK BASEBALL.MAS (LRECL 80 -RUN -WRITE BASEBALL -WRITE BASEBALL FILE=BASEBALL,SUFFIX=FOC -WRITE BASEBALL SEGNAME=SEG1 -WRITE BASEBALL FIELD=TEAM,,A20,A20,$ -WRITE BASEBALL FIELD=PLAYER,,A20,A20,$ -WRITE BASEBALL FIELD=BEGDATE,,A10,A10,$ -WRITE BASEBALL FIELD=ENDDATE,,A10,A10,$ -RUN CREATE FILE BASEBALL MODIFY FILE BASEBALL FIXFORM TEAM/A20 PLAYER/A20 BEGDATE/A10 ENDDATE/A10 DATA CHICAGO WHITE SOX Bill Melton 2015-01-012015-02-01 CHICAGO CUBS Ron Santo 2015-04-012015-05-25 MILWAUKEE BREWERS Cecil Cooper 2015-01-012015-04-01 MINNESOTA TWINS Herman Killebrew 2014-11-192015-11-19 MINNESOTA TWINS Rod Carew 2014-11-192015-06-19 MINNESOTA TWINS Rod Carew 2015-07-042015-07-04 MINNESOTA TWINS Rod Carew 2015-09-042015-09-10 MINNESOTA TWINS Rod Carew 2015-11-012015-11-30 END -RUN -* -* Create JSON for Google Timeline Chart Data Table. -* TABLE FILE BASEBALL PRINT TEAM NOPRINT COMPUTE OUTPUT/A511 = '[''' | TEAM || ''',''' || PLAYER || ''',' || 'new Date(''' || BEGDATE || '''),' || 'new Date(''' || ENDDATE || ''')],'; ON TABLE SET HOLDLIST PRINTONLY ON TABLE HOLD AS HLDDATA FORMAT ALPHA END -RUN -* -* Create Google Timeline chart and present to user. -* -HTMLFORM BEGIN <!DOCTYPE html> <html> <head> <meta http-equiv="X-UA-Compatible" content="IE=edge" /> <title>Star Players and Time Active</title> <script type="text/javascript" src="https://www.gstatic.com/charts/loader.js"></script> <script type="text/javascript"> google.charts.load("current", { packages: ["timeline"] }); google.charts.setOnLoadCallback(drawChart); function drawChart() { var container = document.getElementById('mytimeline'); var chart = new google.visualization.Timeline(container); var dataTable = new google.visualization.DataTable(); dataTable.addColumn({ type: 'string', id: 'Team' }); dataTable.addColumn({ type: 'string', id: 'Player' }); dataTable.addColumn({ type: 'date', id: 'Start' }); dataTable.addColumn({ type: 'date', id: 'End' }); dataTable.addRows([ !IBI.FIL.HLDDATA; ]); chart.draw(dataTable); } </script> </head> <body> <div id="mytimeline" style="height: 400px;"></div> </body> </html> -HTMLFORM END