I have created a relationship between a table which has a unique set of asset codes (A) with two other tables on asset code (B and C).
If I put a field from B into a visualisation table it works but as soon as I add a field C I get a relationship error. Or the other way around.
I have attached two screenshots - one of the error message and one of the relationships I've set up.
The formating for asset code in all three tables is Text.
I've run out of ideas and cannot seem to find a similar issue in the forums.
Hi @ajprosser,
I'm afraid we can't use it like that. It's quite clear in the example below. What's the result that you were going to achieve?
Now, we create a table visual.
asset code asset classification product type
computer electricl equipment ??? (type 1? type 2? type 3? type 4?)
Best Regards,
Dale
Hi @ajprosser,
I'm afraid we can't use it like that. It's quite clear in the example below. What's the result that you were going to achieve?
Now, we create a table visual.
asset code asset classification product type
computer electricl equipment ??? (type 1? type 2? type 3? type 4?)
Best Regards,
Dale
