Calculating % for specific combinations

[#1]

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 ?

[swuehl · Accepted solution]

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