Hey All, I've got an interesting scenario where I'm not sure if a metric can help me solve it. I have a fact that contains 3 values • Type_id • Estimated Hours (total for all of this type) • Actual Hours for this entry I'm trying to figure out how to group across of this such that • For each type_id, I can get the estimated_hours as a value I can sum • For each actual record, sum of actual hours is what I want Example: { Type_id: 1, Estimated_Hours: 100, Actual_Hours: 10, }, { Type_id: 1, Estimated_Hours: 100, Actual_hours: 15, }, { Type_id: 2, Estimate_Hours: 1000, Actual_hour: 100, } If I just do a sum, max or average on Estimated_Hours, I"m going to get • 100 + 100 + 1000 = 1200 (sum) • 1000 (max) • (100+100+1000)/3 = 400 (avg) But what I'm after is 1,100 because I want only 1 value for each type.

New message text here