Forum Discussion
Help with relationships
Sounds like in your Weights database that the Part Group is not unique. Best way to tell: Add that column THREE times to a table visual. Leave the first one as it is, change the aggregation of the second to DISTINCT COUNT, and change the aggregation of the third to COUNT. Now look at the bottom numbers. If the COUNT = DISTINCT COUNT then the Part Group values are unique.
If you can get the Part Group values to be unique in the Weights database, then the relationship can be One-to-One, which makes sense for your mode.
You're right, I'll just go through each sources of the data quickly.
Above is the weights table data. The list is a lot longer but as you can see the part group is displayed alongside its relevant weight.
Above is the groupings table, Here the the part group is displayed alongside its relvant grouping, There are many different groupings as the list goes on such as Drive, Rack, Cards etc.
Finally, above is a snippet of the base data. The part group is displayed here also. Per my earlier line of questioning, you can see the actual returns are displayed in the base data on column R. Creating a table with groupings and returns thus turned out fine. The problem lies with displaying the weight by group effectively.
I think the best way to display the visual i am looking for is above. The returns dollar amount by grouping is the table on the left and that table is perfect. But on the right is the weights table which is for some reason displaying identical values.
What are Q1 and Q2? Calendar Quarters? Your Weights data is NOT dependent on time.
If you have a one-to-one relationship between Groups and Weights (on Part Group) and you build a table visual showing the Group and sum of (Weight), you should get correct data. Take the other columns out of the table.