This should be some basic stuff but lack of good documentation on SAQL is making it hard to figure out. I just want to do a simple math like ths-
Avg. Sale Price = Total Sale Price/Qty
The filters used for computing Total Sale Price and Qty are different. For example,
a = load ... b = filter a by ... //some filters here b = group b by all; b = foreach b generate sum('Sale_Price') as 'total_sale_price'; c = filter a by ... //some filters here (different from those used for b) c = group c by all; c = foreach c generate count() as 'qty';
Now, I just want to compute b.total_sale_price/c.qty. How can I do that?