CHARTS

[JJBMcGardd]

Have posted several questions in the iData section and the responses have been very helpful. Think this topic may be useful to a wider range of customers so adding it here also.

Have figured out how to create my chart data using my System I data ant get that information converted into an .htlm document transferred to the IFS drive.

While researching how to do this I came across Fusion Charts which has several different styles of graphs and charts. The sample you sent me appears to have the same tags and formatting as those in Fusion Charts.

In Fusion Charts they have a Multi Series chart example below. Have tried using this in the url for a chart but does not show the chart. You have stated that you plan to add additional chart features into Profound UI in the medium term future.

Has this feature been added in not when do you plan on adding this type of feature?


<graph caption="Monthly Review" xAxisName="Month" yAxisName="Revenue" yAxisMaxValue="60000" >
<categories>
<category name='JAN' />
<category name='FEB' />
<category name='MAR' />
<category name='APR' />
<category name='MAY' />
<category name='JUN' />
<category name='JUL' />
<category name='AUG' />
<category name='SEP' />
<category name='OCT' />
<category name='NOV' />
<category name='DEC' />
</categories>
<dataset seriesname="First Set">
<set value ='32226' />
<set value ='47552' />
<set value ='77609' />
<set value ='18023' />
<set value ='67156' />
<set value ='78411' />
<set value ='0' />
<set value ='0' />
<set value ='0' />
<set value ='0' />
<set value ='0' />
<set value ='0' />
</dataset>
<dataset seriesname="Second Set">
<set value ='56226' />
<set value ='54752' />
<set value ='30709' />
<set value ='68023' />
<set value ='57156' />
<set value ='58411' />
<set value ='32226' />
<set value ='32226' />
<set value ='32226' />
<set value ='32226' />
<set value ='32226' />
<set value ='32226' />
</dataset>
<Trendlines>
<line StartValue='18000' color='#660066 ' displayvalue='Goal ' thickness='5' />
</Trendlines>
</graph>

[Greg]

At the moment, we don't make it as simple to create a multi-series chart as we do a single-series chart. But it is possible if you write a custom CGI, PHP, or RPGsp program to output the XML. To do this:

- Drag a chart widget onto the canvas
- Under the "chart type" property, select Other, and type the name of Fusion Multi-Series chart. To see all of the chart types available, browse the IFS folder /www/profoundui/htdocs/profoundui/proddata/ichart/
- Specify the url to the program that outputs the XML using the "chart url" property

[JJBMcGardd]

That is how I created the sample I set did not work

[Rob]

Make sure the chart type property is set correctly. I was able to get your data to display by setting chart type to MSColumn3D. The chart type is actually in the RPGsp program that the wizard created for you. Search for swf to find it.

I also created an html file at /www/profoundui/htdocs/ch.html containing the xml data you supplied and set the chart url property to /ch.html

The chart then rendered the data within Profound UI.

Once you get this multi-series chart working with a static html file. We can tell you how call the RPGsp program directly from Profound UI. This will allow you to create any type of dynamic chart that the RPGsp wizard can create.

[JJBMcGardd]

I have the Multi-series chart working and building the html using RPGLE.

What would be really helpful would be the specification sheets for all of the different charts.

I am using the <trendLines> tag and it does work but the showOnTop= has no effect. Tired both 1 and 0 but line stays in the background.

Included a sample HTML document below, this is a working document inside of profound.

<graph caption="Pieces Per Labor Hour" xAxisName="Month" yAxisName="Pieces" yAxisMaxValue="11788" >
<categories>
<category name="JAN" />
<category name="FEB" />
</categories>
<dataset seriesname="2010" color="4D4DFF" showValues="0" >
<set value="17503" />
<set value="17696" />
</dataset>
<dataset seriesname="2009" color="45B46A" showValues="0" >
<set value="11288" />
<set value="22357" />
</dataset>
<trendLines>
<line StartValue='18027' color='660066' displayvalue='Goal' thickness='5' showOnTop='1' />
</trendLines>
</graph>

I found information about the different style and specification of graphs with Fusion Charts and the showOnTop work when used in Fusion Chart.

We currently have four project being developed using profound and spend a lot of time trying to figure out how to use the different widgets.

Is there any documentation other than the getting started guide?

Thanks,

John

[Rob]

Within RPGsp help (press F1 for help) there is a section on using charts including XML documentation.

The trendline is rendered behind the graph. It is actually a Y axis horizontal line. You may want to make the data elements slightly transparent if the trend line is completely hidden.

[JJBMcGardd]

Do not want it hidden would like it on top.