We have a CSV fields set defined (shortening it here), Txn,Destination,Status test1,NY,Pass test2,NY,Pass test2,NY,Pass test2,NY,Pass test2,NY,Fail test1,NY,Pass test2,NY,Pass test1,NY,Fail test2,NY,Fail Destinations vary as well (taking a simpler case) Trying to get something very simple then will group by Destination later on TXN SUCCESS FAILURE RATE test1 count(Status=Pass) count(Status=Fail)/( count(Status=Pass)+count(Status=Fail)) Iam trying stuff but somehow i cant find a way to search in one search two different count values.. not sure if iam trying to do anything complex here thanks Prabhu ... View more