Thanks for replying bowesmana, There's actually another Compute unit I forgot named Host, but essentially with same logic. SPL is: | inputlookup my_lookup | stats dc(eval(if(NodeType="A",NodeID,null()))) as TtlSmallNodes dc(eval(if(HostType="B",HostD,null()))) as TtlSmallHost by LargeComputeUnit MidComputeUnit SmallComputeUnit | join type=left [| inputlookup my_lookup | stats dc(eval(if(NodeType="A",NodeID,null()))) as TtlMidSizeNodes dc(eval(if(HostType="B",HostD,null()))) as TtlMidSizeHost by LargeComputeUnit MidComputeUnit ] | join type=left [| inputlookup my_lookup | stats dc(eval(if(NodeType="A",NodeID,null()))) as TtlLargeNodes dc(eval(if(HostType="B",HostD,null()))) as TtlSmallHost by LargeComputeUnit ] I expect to see 3 Description text columns: LargeNodeDesc MidSizeNodeDesc SmallNodeDesc , then numeric columns TtlSmallNodes , TtlMidSizeNodes, TtlLargeNodes, and similar 3 numeric columns for Hosts, grouped by their respective descriptions. Something like: LargeComputeUnitDesc MidComputeUnitDesc SmallComputeUnitDesc TotalLargeNode TatalMidSizeNodes TotalSmalNodes TotalLargeHosts TatalMidSizeHosts TotalSmalHosts g3.4xlarge C5 t2.micro 9 1 12 8 8 10 H1 M4 t2.nano 7 2 14 2 7 1 D2 X1e etc. 5 3 19 3 5 6 R5 C4 etc. 2 4 9 8 6 8 R5n R4 etc. 3 7 7 9 7 4
... View more