Hello community,
This may seem pretty basic, but I can’t find how to do this. I have three tables related to the user table like in the following image:
Each of the tables have different scores for each user.
I want to show in the model-driven app an aggregate of the scores of each table for the logged user. This aggregate can be a sum or an average. I can’t find how to do this.
Any help would be kindly appreciated.
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
EDIT:
This is what the expected output would look like:
User 0001 | Table 1 | Score average |
User 0001 | Table 2 | Score average |
| User 0001 | Table 3 | Score average |
| User 0002 | Table 1 | Score average |
| User 0002 | Table 2 | Score average |
| User 0002 | Table 3 | Score average |
