You're welcome.
On Tuesday, January 8, 2013 12:59:43 PM UTC-5, Michelle Stewart wrote:
>
> That works beautifully! Thank you!
>
> On Tuesday, January 8, 2013 12:08:41 PM UTC-5, asgallant wrote:
>>
>> The "calc" parameter expects a function, and you are giving it the return
>> value of a function. So when you have "calc: getAvail(4,6)", it is
>> equivalent to having "calc: 0.6". Looking at your set up, it seems that
>> what you want is this:
>>
>> calc: function (dt, row) {
>> return getAvail(dt.getValue(row, 4), dt.getValue(row, 6));
>> }
>>
>> On Tuesday, January 8, 2013 11:42:27 AM UTC-5, Michelle Stewart wrote:
>>>
>>> I got that solved. I just forgot the new. It was something to the
>>> effect of "Cannot call setColumns on undefined".
>>>
>>> I do need help however on figuring out why it seems the values being
>>> used for the calculations are the column numbers instead of the column
>>> values.
>>>
>>> var view = new google.visualization.DataView(non_grouped);
>>> /* Non_grouped Columns
>>> 0 - Date, 1 - Shift, 2-Press, 3- Mold,
>>> 4 - Downtime, 5 - Scheduled, 6 - Uptime,
>>> 7 - Target, 8- Scrapped, 9- Made
>>> */
>>> view.setColumns([0,1,2,3,
>>> {calc: getAvail(4,6), type: 'number'},
>>> {calc: getPerf(9,7,6), type: 'number'},
>>> {calc: getQual(9, 8), type: 'number'},
>>> {calc: getOEE(4,7,6,9,8), type: 'number'}]);
>>> /* View Columns
>>> 0 - Date, , 1 - Shift, 2 - Press, 3 - Mold
>>> 4 - Availability, 5 - Performance, 6 - Quality, 7 - OEE
>>> */
>>> showThis = new google.visualization.data.group(view, [0],
>>> [{column: 4, aggregation: google.visualization.data.avg, type: 'number'},
>>> {column: 5, aggregation: google.visualization.data.avg, type: 'number'},
>>> {column: 6, aggregation: google.visualization.data.avg, type: 'number'},
>>> {column: 7, aggregation: google.visualization.data.avg, type:
>>> 'number'}]);
>>> var chart = new
>>> google.visualization.LineChart(document.getElementById('chart-oee'));
>>> chart.draw(showThis, options);
>>> $(curTab).show();
>>> }
>>> });
>>> }
>>> function getAvail(d,u){
>>> return u/(u+d);
>>> }
>>> function getPerf(p,t,u){
>>> return (p*t)/u;
>>> }
>>> function getQual(p, s){
>>> return (p-s)/p;
>>> }
>>> function getOEE(d,t,u,p,s){
>>> var avail = getAvail(d,u);
>>> var perf = getPerf(p,t,u);
>>> var qual = getQual(p,s);
>>> return avail*perf*qual;
>>> }
>>>
>>> On Tuesday, January 8, 2013 11:35:44 AM UTC-5, asgallant wrote:
>>>>
>>>> What is the exact error being thrown here?
>>>>
>>>> On Tuesday, January 8, 2013 11:28:50 AM UTC-5, Michelle Stewart wrote:
>>>>>
>>>>> I am doing something very similar so I was using this code, but
>>>>> apparently I am missing something obvious because my view isn't working.
>>>>>
>>>>> I am using arrayToDataTable because of the data I have, but
>>>>> <code>
>>>>> var non_grouped = google.visualization.arrayToDataTable(oeeChartsData);
>>>>> var view = google.visualization.DataView(non_grouped);
>>>>> /* Non_grouped Columns
>>>>> 0 - Date, 1 - Shift, 2-AAA, 3- BBB
>>>>> 4 - Downtime, 5 - Scheduled, 6 - Uptime,
>>>>> 7 - Target, 8- Scrapped, 9- Made
>>>>> */
>>>>> view.setColumns([0,1,2,3,
>>>>> {calc: getAvail(4,6), type: 'number'},
>>>>> {calc: getPerf(9,7,6), type: 'number'},
>>>>> {calc: getQual(9, 8), type: 'number'},
>>>>> {calc: getOEE(4,7,6,9,8), type: 'number'}]);
>>>>> </code>
>>>>> errors on the setColumns line because the view never got created! All
>>>>> my functions work, any ideas what could be wrong?
>>>>> non_grouped is a dataTable just fine.
>>>>>
>>>>> Thanks in advance,
>>>>> Michelle
>>>>>
>>>>> On Wednesday, June 29, 2011 3:43:15 AM UTC-4, Viz Kid wrote:
>>>>>>
>>>>>>
>>>>>> Hi
>>>>>>
>>>>>> I stated that this can be done using a DataView, but I did not say
>>>>>> that it would be as clean as you would like, especially satisfying your
>>>>>> request to use the general existing weighted average function as is. If
>>>>>> the
>>>>>> WeightedAverage function is indeed what you wrote (I did not see any
>>>>>> normalization there so I wasn't sure), you can indeed get the desired
>>>>>> outcome using first a DataView to create the weighted columns [2,5,6,7]
>>>>>> (by
>>>>>> multiplying their value by the weight) and then applying the group call
>>>>>> as
>>>>>> you did it where replacing the WeightedAverage with the sum function.
>>>>>>
>>>>>> I agree that it would be more natural to have the syntax as you wrote
>>>>>> it available for this use case but currently it simply does not exist.
>>>>>>
>>>>>> Here is a snippet of the code:
>>>>>>
>>>>>> view = new google.visualization.DataView(table);
>>>>>> view.setColumns([
>>>>>> 0,
>>>>>> 1,
>>>>>> {calc: weightedColumn(2, 4), type: 'number'},
>>>>>> 3,
>>>>>> 4,
>>>>>> {calc: weightedColumn(5, 4), type: 'number'},
>>>>>> {calc: weightedColumn(6, 4), type: 'number'},
>>>>>> {calc: weightedColumn(7, 4), type: 'number'}]);
>>>>>>
>>>>>> bySector = new google.visualization.data.group(view, [1],
>>>>>> [ {column:0, aggregation:AllSameOrMany, type:'string'}
>>>>>> ,{column:2, aggregation:google.visualization.data.sum,type:'number'}
>>>>>> ,{column:3, aggregation:google.visualization.data.sum,type:'number'}
>>>>>> ,{column:4, aggregation:google.visualization.data.sum,type:'number'}
>>>>>> ,{column:5, aggregation:google.visualization.data.sum,type:'number'}
>>>>>> ,{column:6, aggregation:google.visualization.data.sum,type:'number'}
>>>>>> ,{column:7, aggregation:google.visualization.data.sum,type:'number'}
>>>>>> ]
>>>>>> );
>>>>>>
>>>>>> function weightedColumn(dataColumnIndex, wightsColumnIndex) {
>>>>>> return function(dataTable, rowNum) {
>>>>>> return dataTable.getValue(rowNum, dataColumnIndex)
>>>>>> * dataTable.getValue(rowNum, weightsColumnIndex);
>>>>>> }
>>>>>> }
>>>>>>
>>>>>> Best,
>>>>>> Viz Kid
>>>>>>
>>>>>> On Wed, Jun 29, 2011 at 5:04 AM, NA <[email protected]> wrote:
>>>>>>
>>>>>>> VIz Kid, can you post that example?
>>>>>>>
>>>>>>> On Jun 24, 9:58 pm, NA <[email protected]> wrote:
>>>>>>> > So can you present an example using DataView? I can't see a
>>>>>>> > straightforward way to do this, but I'll give you the benefit of
>>>>>>> the
>>>>>>> > doubt. Show me how you'd do the following:
>>>>>>> >
>>>>>>> > table has these columns:
>>>>>>> >
>>>>>>> > 0 1 2 3 4 5 6 7
>>>>>>> > id, sector, price, shares, weight, f1, f2, f3
>>>>>>> >
>>>>>>> > I want to aggregate this by sector. The aggregation functions for
>>>>>>> > price, f1, f2, and f3 is a weighted average. The aggregation for
>>>>>>> > shares and weight is a sum. The aggregation for id and sector is
>>>>>>> to
>>>>>>> > return the string "Many" if there are multiple values in that
>>>>>>> column,
>>>>>>> > or if all the entries are the same return that value.
>>>>>>> >
>>>>>>> > Such aggregation functions might look like:
>>>>>>> >
>>>>>>> > function WeightedAverage(q,w) {
>>>>>>> > var wsum = 0;
>>>>>>> > for (i=0;i<w.length;i++) {wsum+= w[i]*q[i];}
>>>>>>> > return wsum;
>>>>>>> >
>>>>>>> > }
>>>>>>> >
>>>>>>> > function AllSameOrMany(c) {
>>>>>>> > var r = c[0];
>>>>>>> > for (var i=0;i<c.length;i++) {if (r !=c[i]){return 'Many';}};
>>>>>>> > return r;
>>>>>>> >
>>>>>>> > }
>>>>>>> >
>>>>>>> > Note that the WeightedAverage function is a general function that
>>>>>>> > doesn't require the weight to always be in column 4. It also
>>>>>>> doesn't
>>>>>>> > know what Tables are. It's used in many places; its existence
>>>>>>> > predates the google visualization API. This is important for
>>>>>>> > reusability, maintainability, and interoperability across many
>>>>>>> > libraries.
>>>>>>> >
>>>>>>> > What I'd like to do is;
>>>>>>> >
>>>>>>> > bySector = new google.visualization.data.group(table,[1],
>>>>>>> > [ {column:0, aggregation:AllSameOrMany, type:'string'}
>>>>>>> > ,{column:[2,4],aggregation:WeightedAverage,type:'number'}
>>>>>>> > ,{column:3,
>>>>>>> aggregation:google.visualization.data.sum,type:'number'}
>>>>>>> > ,{column:4,
>>>>>>> aggregation:google.visualization.data.sum,type:'number'}
>>>>>>> > ,{column:[5,4], aggregation:WeightedAverage,type:'number'}
>>>>>>> > ,{column:[6,4], aggregation:WeightedAverage,type:'number'}
>>>>>>> > ,{column:[7,4], aggregation:WeightedAverage,type:'number'}
>>>>>>> > ]
>>>>>>> > );
>>>>>>> >
>>>>>>> > Since this syntax doesn't exist, can you show me how to do this
>>>>>>> with
>>>>>>> > google.visualization.data.group or with DataViews, without having
>>>>>>> to
>>>>>>> > create special versions of my aggregation functions?
>>>>>>> >
>>>>>>> > In my case, I used currying to wrap functions like WeightedAverage
>>>>>>> in
>>>>>>> > a way to accommodate the grouping and DataView APIs.
>>>>>>> >
>>>>>>> > But I'd like to learn a cleaner way of doing this.
>>>>>>> >
>>>>>>> > thanks,
>>>>>>>
>>>>>>> --
>>>>>>> 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.
>>>>>>>
>>>>>>>
>>>>>>
--
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/-/nhIn8XPJJlsJ.
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.
