Selecting several columns for the Y axis for a graph

 

When inserting a graph in a ClicknDECiDE Builder report, it is sometimes necessary to select more than one column for the Data Series (Y axis).

 

image\choosecolumns_y.gif

 

This is now possible via a new wizard which enables you to click the Browse ... button to select the required fields that will appear in the Data Series box separated by a semi-colon.

 

image\choosecolumns_y2.gif

 

New in version 4: Note that this wizard allows also defining, for the data series if needed, a main axis and a secondary axis for the Y axis. Select the required column and click on the radio button of your choice to apply the Y axis you need.

 

New Feature in Version 4.10: Please note that the Wizard enables you to display all the fields in the current report in order to feed the graph directly with data from the report without needing to run an additional query. This optimizes performance. The Wizard also displays the column names of the query feeding the current report and the internal names of the current report's items which can be used for the graph. From left to right the following are displayed: the Name, Type, Origin (Report or Query) along with a description (which for the report's items is the name of the blocks including each item - Detail, Report Header, Group Header, Group Footer etc...).

 

Please note that you can sort the above information by clicking the column headers in the following window:

 

image\choosecolumns_y3.gif