Please send an example page.
On Mon, Oct 18, 2010 at 7:06 PM, Anky <[email protected]> wrote:
> Hi,
>
> I have implemented a chart that displays stacks for each x axis
> component with multiple values. For example, If I apply two level of
> grouping on x axis (say A, B fields) then A's data grouped by B's data
> will be displayed on the A's values which are x Axis coordinates. To
> illustrate, lets assumea table with columns as Name, Designation,
> Address, Department EmailD. I want to display the chart data based on
> grouping of department and designation. So the chart will be plotted
> with Department - Account having stack values as Account-Manager,
> Account-Clerk, Account-Accountant. This represents one bar in the
> column chart. The other bar may have some other department ,say,
> Library with stack values Library-Checker, Library-issuer etc...
> Consider that Y Axis has a count field that represents the count of
> each department-designation
>
> I am able to plot this chart but the problem comes with display of
> legends. Legend color is displyed but the legend text is not
> displayed.
>
> Here is the datatable method which I am using to set the values
>
> <code>
> public DataTable getDataTable() {
> dataTable = DataTable.create();
> int maxSize = getMaxColumns();// represents how many stacks
> will be
> created for each x Axis field.
> // rowSize - get the number of fields on x Axis.
> int rowSize =
> chartTableObject.getDataTableValuesObjList().size();
>
> dataTable.addColumn(ColumnType.STRING,
> chartTableObject.getxAxisTitle());
> // add the x Axis fieds
> for (int index = 0; index < maxSize; index++) {
> dataTable.addColumn(ColumnType.NUMBER, "");
> }
>
> dataTable.addRows(rowSize);
> for (int index = 0; index < rowSize; index++) {
> // set the x Axis field
> dataTable.setValue(index, 0, chartTableObject
>
> .getDataTableValuesObjList().get(index).getxAxisField());
> // this MAP holds the key (x axis field) and value(all the values for
> this field)
> Iterator<Map.Entry<String, Double>> mapIterator =
> chartTableObject
>
> .getDataTableValuesObjList().get(index)
>
> .getValuesPerXAxisField().entrySet().iterator();
>
> while (mapIterator.hasNext()) {
> try{
> Map.Entry<String, Double> pair =
> (Map.Entry<String, Double>)
> mapIterator
> .next();
> String colDisplay = pair.getKey();
> int hyphenIndex = colDisplay.indexOf("-");
> colDisplay =
> colDisplay.substring(hyphenIndex+1,
> colDisplay.length());
> // using -> public final native void setCell(int rowIndex, int
> columnIndex, double value, String
> // formattedValue,Properties properties)
> dataTable.setCell(index, count, pair.getValue(), colDisplay+"
> "+pair.getValue(), null);
> // it wil display xaxis field something like Account-> 'Manager-12',
> 'Clerk-15'
>
> }catch (Exception e) {
> System.out.println("Exception while
> iterating map to add values
> to datatable "+e.getMessage());
> }
> }
> }
> return dataTable;
> }
> </code>
>
> --
> You received this message because you are subscribed to the Google Groups
> "Google Visualization API" group.
> To post to this group, send email to
> [email protected].
> To unsubscribe from this group, send email to
> [email protected]<google-visualization-api%[email protected]>
> .
> For more options, visit this group at
> http://groups.google.com/group/google-visualization-api?hl=en.
>
>
--
You received this message because you are subscribed to the Google Groups
"Google Visualization API" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/google-visualization-api?hl=en.
