Forum Discussion

tvaishnav's avatar
tvaishnav
Icon for Helper IV rankHelper IV
4 years ago

How do model data with different granularity?

I have a situation where I want to compare cost and revenue. My revenue number is just an aggregate, however cost has sub categories. How would you model this?   I can think of these ways.   1) P...
Need Help
tvaishnav's avatar
tvaishnav
Icon for Helper IV rankHelper IV
4 years ago

Thank you for your response. Do you think I can create this using matrix visual and two fact tables?

 

 

PaulDBrown's avatar
PaulDBrown
Icon for Community Champion rankCommunity Champion
4 years ago

Sure, but you will need a table with the row structure for the matrix. SImilar to this, but for rows instead of columns:

Custom Matrix