Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
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
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