Calculating % for specific combinations

Fri, 16 Nov 2012 09:44:17 GMT

I have a dataset listing events happening at a plant:

the goal is:

- find cases where A+B happened on the samen day at a plant

- calculated the % of the total of events at that plant

Grouping in the script is not the way to go, as there are other details in the dataset that need to be analysed.

Any hints on how to achieve this ?

Re: Calculating % for specific combinations

swuehl — Fri, 16 Nov 2012 09:55:21 GMT

You could calculate your A+B same day column using this expression:

=sum(aggr(if(count(distinct event)=2,1,0),plant,date))

Hope this helps,

Stefan