I have the column Group, in which there are several entries with the same name as Banana1. As soon as all statuses of a group (e.g. Banana1) are on ready, I want to calculate the average cycle time of the whole group Banana1.
Ready: Load Groups Where GroupStatus = 'ready'; Load Groups, if(Only(Status)='ready','ready') as GroupStatus Resident YourTable Group By Groups; Left Join Load * Resident YourTable;
Drop Table YourTable;
You can then use the Ready resident table to do whatever calculations you want, since it only contains lines for which all statuses for Group are ready. Note that you could also do this by using Exists on the Ready table without left joining the lines if you prefer.
