Forum Discussion
Helper IIITable stops working when columns are in a specific order
Super UserHi twofingertyper ,
If you are using a many to many relationship, this as a big impact on your model and visualizations performance, the fact that you get the value stop in middle or at the end depends on the aggregations and the way ou have the several columns because there can be a change in the way the Select statement is done and the result is an error or a correct calculation.
The two table visualizations below are exactly the same but they were built in a different order:
If you check the code for both of them you get the following:
You can see that the code is basically the same but the order of the columns is different. Of course this is just a very small example but you understand the context of this.
This implication is even more complex when adding relationships with many to many and filters on top of your model.
I would suggest to create a bridge table between you both table to have a 1 to many relationship between those tables.
Check this video were you have a complete explanation of this type of setup:
https://www.youtube.com/watch?v=wRSJ6TYjEu0
It's well worth the hour.
Helper III