Forum Discussion
Creating order amount and shipped amount Measures for Matrix visual
It's a good start
- Products is a dimension table and should control Orders in a 1:* relationship. Looks like you have duplicates in the Products table though, you may want to clean that up
- I would argue that Orders and Invoices are independent facts, don't join them directly. Unless you can guarantee that you only ever have one invoice for one order. Or refute my assumption
- Add a calendar table to your data model. You always, always need a claendar table. Link it to the order date (active) and the ship date (inactive)
It's a good start
- Products is a dimension table and should control Orders in a 1:* relationship. Looks like you have duplicates in the Products table though, you may want to clean that up
- I would argue that Orders and Invoices are independent facts, don't join them directly. Unless you can guarantee that you only ever have one invoice for one order. Or refute my assumption
- Add a calendar table to your data model. You always, always need a claendar table. Link it to the order date (active) and the ship date (inactive)
Thank you, It worked.
I need to create a bar graph using the shipped amount and ordered amount. which should be like this.
But when I am trying to achieve this I got graphs like below
I am not sure exactly how can I solve this. My date_table code is