Forum Discussion

elliee's avatar
elliee
Frequent Visitor
3 years ago

values duplicated in a join

I'd like to create a KPI chart by joining two tables together (1-* relationship) through an unique identifier that is created based on concatenation of 3 column values. however, when i try to pull bo...
Need Help
Tutorial Requests
Idrissshatila's avatar
Idrissshatila
Icon for Super User rankSuper User
3 years ago

Hello elliee ,

 

Try making a seperate table that has the categories only, make a relationship between it and each of the two tables throught the category field.

Then use this field in the new table to show to show the data in the visuals.

 

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

 

Follow me on Linkedin

elliee's avatar
elliee
Frequent Visitor
3 years ago

Hi Idrissshatila , I'm using more than just category in the relationship.

 

For example:

CategorySub CategoryCustomerRevenue TargetPeriod
ShoppingAAlice10020002022Q4
TravelBBen20030002022Q4
DiningACharlotte30040002022Q4

 

I'm creating the relationship based on a concatenated field that joins Period, Category, Sub Category and Customer together. I will need the flexibility to report the performance at the different levels.

 

The option to add as new query is not available when i select all the dimensions used in the relationship. how can i achieve this report please?