Thanks for the reply. I think that was rightly understood by you. If please
you can explain how can group by the columns then taking the difference
return the result, that will be helpful.
thanks
On Monday, November 26, 2012 4:02:34 AM UTC+5:30, asgallant wrote:
>
> I'm not sure I understood this quite right, but lets see if this works for
> you. It sounds like you need to group datatable2 on EmpNo and CostID to
> get the sum of BudgetNo, then join the grouped data with datatable1. The
> join would have EmpNo, BudgetNo, and CostID from datatable1 and BudgetNo
> from the grouped data. You can then create a DataView based on the joined
> data which has a column calculated as the difference between the two
> BudgetNo columns.
>
> On Sunday, November 25, 2012 1:06:02 PM UTC-5, sats wrote:
>>
>>
>> Hello All,
>> I am new to google visualization. I want to display data from two lists
>> combinely as output to Column Chart.
>> I have two lists master and parent list and based on the data from
>> that, I want to create a column chart. I created a javascript file added
>> google and required reference.
>> I created two datatables
>> datatble1 (master data unique rows ) and datatble2 (child rows data
>> multiple entries) as
>> var dataJobNumber = new google.visualization.DataTable();
>> dataJobNumber.addColumn('number', 'Emp No');
>> dataJobNumber.addColumn('number', 'Budget Amount');
>> dataJobNumber.addColumn('number', 'CostID');
>>
>> The data I am getting in format as for both datatables
>> row : 12345,111111,4444444.11111 and similarly data in other rows
>>
>> In datatable 2 there are multiple entries for empno and costID (e.g:
>> 12345 as empno and 4444444.11111).
>> I want to have a datatble that will be created based on the datable1 and
>> datatble2 say as dattable3 which will actually generate columnchart.
>> datatble2 e.g:
>> EmpNo BudgetNo CostID
>> 12345,111111,4444444.11111
>> 12345,111111,4444444.11111 //// and other rows
>> In this case (I tried group function) I want output as
>> 12345,222222,4444444.11111 (since all multiple entries based on empno and
>> costId should get added for budget amount value).
>> Then this Budget amount for example 222222 for empid 1234 and costid
>> 444444.11111 I want to substract from master table datatble and get that
>> value output in datatble3
>>
>> final datatble should be (emp no , budget amount (master table budget
>> emount - sum (all budget amount for empid and costid), costid
>>
>> The data in example is dummy, but it will be in that very same format
>> like (11111,111111.2222224,13232)
>>
>> Please help me on this
>> thanks in advance
>>
>>
>
--
You received this message because you are subscribed to the Google Groups
"Google Visualization API" group.
To view this discussion on the web visit
https://groups.google.com/d/msg/google-visualization-api/-/yTMqe7Gib7MJ.
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.
