Forum Discussion
Responsive ResidentHow to show records without historical data?
Check out your example file here:
https://drive.google.com/drive/folders/1AjePk7NUXAloXHr42BEa2lDOr5dQr2Wg
I'd also suggest you make consideration about where certain attributes belong. Is the product group an attribute of the sale or is it an attritube of the product? Is the customer type and attribute of the sale of is it an attribute of the customer?
In the provided example i moved the customer type into the customer table. Consider removing the separate customer type table and the customer type id from the sales table.
Responsive ResidentNot a sales amount indeed, but customers similar to Jane (like Joe who is in the same customer type) bought vegetables so I would like to see a value for 'sales similar customers'. And the 'sales similar customers' is also not dispalyed. And this is while the sales Joe did, are taken into account for the sales similar customers total so somehow it is taken into account. Seems like it just not displayed.
Solution SageCheck out your example file here:
https://drive.google.com/drive/folders/1AjePk7NUXAloXHr42BEa2lDOr5dQr2Wg
I'd also suggest you make consideration about where certain attributes belong. Is the product group an attribute of the sale or is it an attritube of the product? Is the customer type and attribute of the sale of is it an attribute of the customer?
In the provided example i moved the customer type into the customer table. Consider removing the separate customer type table and the customer type id from the sales table.
- Smalfly
NickolajJessen That works. Thank you so much for your help!
You are 110% right on the number of attributes in the fact table by the way. I am aware of that but I do appreciate that you try to warn me for it.