How to show sum grouped by field in a transitively related table?

[gk2go]

I have the following three tables, and i would to create a visual that shows PVs grouped by Tag.

How shall i set the relationships to achieve that?

I expected the following would do it:

1. One-to-many relationship between Pages_DimTable and Page-Tags Table on Page field

2. Many-to-one relationship between PV_FactTable and Pages_DimTable on Page field

But when I put them in a visual it just shows with equal sized boxes, not reflecting the actual sum of PVs per Tag.

What's wrong?

1. PV_FactTable

|| Date | Page | PVs ||

14-02-2021 | Page A | 14

15-03-2021 | Page B | 15

16-03-2021 | Page C | 16

2. Pages_DimTable

|| Page | Att1 | Att2 ||

Page A | A1 | A2

Page B | B1 | B2

3. Page-Tags Table

|| Page | Tag ||

Page A | Tag-1

Page A | Tag-2

Page B | Tag-3

Page B | Tag-2

Page C | Tag-1

Page C | Tag-2

[gk2go · Accepted solution]

The solution was to set the first relationship to filter in both directions

[Anonymous]

it is not clear to me what you expect. but perhaps this could bring us closer.