Hi all, I have two tables, lets say Table1 and Table2, where Table1 references Table2. I need to count and visualize the entries in Table2 but only those that are found in Table1. How can I do that? If I drag and drop a field from Table2 in a bar chart, it will count only from Table2 (all entries) not those that are also in Table1. I cannot merge and flatten the two tables since I need Table2 as I use it in a metric to compare the values. Any help would be appreciated

IMO there are two relevant features for this use case: https://www.gooddata.com/docs/cloud/create-metrics/maql/aggregation/count/#two-parameter-version https://www.gooddata.com/docs/cloud/create-metrics/maql/aggregation/count/#COUNT-SpecifyingCOUNTContextResolutionwithUSING Let me know if it works for you.

Thanks Jan, it helped me solve the problem I had. Thnx