Multiple Average/Sums on same data, based on another column in another table

UI Builder
1

I want to show multiple average columns based on the same data in one table (A), based on the corresponding drop down value from another table (B).

My table A:
Result: Number

My table B:
Type: Drop Down (“X”,“Y”,“Z”)

So I want to get a result that is:

Average (X.Number), Average (Y.Number), Average (Z.Number)

Is this at all possible using views or tables straight out of the box, or do I need to iterate over a result set and create this instead?

I have a feeling the answer is the latter, but I want to check… :slight_smile:

2

@Egil_Helland

I did not quite understand.
Can you show an example pls. Example table A and B.
Do you want to have data in table A based on all data from table B?