Forum Discussion
1 Tab multiple facts
Hello
I have 3 fact in my model
I would like to create a tab visualisation with 1 column from each fact .
It's not working.
How can I do that ?
Any vidéos, ressources ,tutorial with similar case will be helpful
2 Replies
Hello ADVJ27 ,
you need to build your data model as a star schema where the common fields between the 3 fact tables will be in dimension tables that are then linked into the fact table.in this way you can the display fields from different tables along with the field in the dimension table that is linked to them.
check this to learn the concept of star schema data modeling
Hi ADVJ27
You need to create connections between those facts with dim tables by common fields.
Please refer to the linked tutorials:https://www.youtube.com/watch?v=TnyRsO4NJPc
https://www.youtube.com/watch?v=FMR4ZAWjvBE
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
