Forum Discussion
LINE AND STACKED COLUMN CHART
Hi Julier ,
Thank you for your reply, the issue is due to the fact that you have duplicates in your data and the model is unable to create a relationship on that. You can create relationships with non-duplicated primary keys, for example you can create relationships based on event ids (non-duplicated)
Best regards,
Albert He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Thank you, i have had to total my daily sales into a monthly figure using a measure and plotted this into the graph, the S&OP figure is a also monthly figure but i cannot link these, i have provided the sample data which i have then amended in the query to give me these two tables which i cannot build any workable relationship
The first table is the sample S&OP and the second table is the sample sales by day which i have then totalled using a measure.
| Site | Cluster | ERP ID* | Customer Name | Customer Group | New Category | M2S Classification | FM ID | May-24 | Jun-24 | Jul-24 |
| north | North | 3219/0 | aaaaaaa | aaaaaaa | xx | 8,205 | 8,000 | 8,000 | ||
| north | North | 1963/0 | bbbbbb | bbbbbb | yy | 7,907 | 7,907 | 10,900 | ||
| north west | North | 600070 | ccccccc | ccccccc | xx | 26,130 | 31,816 | 16,784 | ||
| north west | North | 600006 | ddddd | ddddd | xx | 67,000 | 67,000 | 76,000 | ||
| north west | North | 600002 | eeeee | eeeee | zz | 45,000 | 45,000 | 55,000 | ||
| north west | North | 600001 | fffffff | fffffff | xx | 32,000 | 32,500 | 8,238 | ||
| north west | North | 600082 | ggggg | ggggg | xx | 450,000 | 450,000 | 400,000 | ||
| south | North | 600015 | hhhhh | hhhhh | yy | 48,620 | 44,453 | 48,660 | ||
| south | North | 600054 | iiiiiiiii | iiiiiiiii | yy | 250,000 | 250,000 | 200,000 | ||
| south | North | 600073 | jjjjjjjj | jjjjjjjj | xx | 380,000 | 385,000 | 400,000 | ||
| south | North | 17316/0 | kkkkk | kkkkk | xx | 310,000 | 400,000 | 5,000 | ||
| south | North | 3219/0 | llllllll. | llllllll. | zz | 45,500 | 40,470 | 55,617 |
| Plant Name | Customer | Plant Customer ERP ID | Ship To Customer Id ERP | Product Code | Volume (SQM) | Selling Plant | Ship-To Customer Name | Date Short | Calendar Month Name | Calendar Year |
| north | aaaaaaa | 3219/0 | 905 | aaaaaaa | 18/05/2024 | May | 2024 | |||
| north | bbbbbb | 14667/0 | 1,599 | bbbbbb | 19/05/2024 | May | 2024 | |||
| north west | ccccccc | 14667/0 | 1,936 | ccccccc | 20/04/2024 | April | 2024 | |||
| north west | ddddd | 14667/0 | 2,570 | ddddd | 21/06/2024 | June | 2024 | |||
| north west | eeeee | 14667/0 | 6,746 | eeeee | 22/05/2024 | May | 2024 | |||
| north west | fffffff | 14667/0 | 1,002 | fffffff | 23/04/2024 | April | 2024 | |||
| north west | ggggg | 14667/0 | 4,724 | ggggg | 24/05/2024 | May | 2024 | |||
| south | hhhhh | 14667/0 | 944 | hhhhh | 25/05/2024 | May | 2024 | |||
| south | iiiiiiiii | 14667/0 | 3,488 | iiiiiiiii | 26/04/2024 | April | 2024 | |||
| south | jjjjjjjj | 1968/0 | 3,171 | jjjjjjjj | 27/05/2024 | May | 2024 | |||
| south | kkkkk | 1968/0 | 8,262 | kkkkk | 28/06/2024 | June | 2024 | |||
| south | llllllll. | 1968/0 | 4,721 | llllllll. | 29/05/2024 | May | 2024 |