Compare two series of data in histogram grouped

[flochsnt]

Hello,

I have a problem, i don't know why my histogram don't work, i have two series of data with real and budget data with mont see here :

Month	Budget
1	0,8
2	1
3	1,2
4	1,4
5	1,6
6	1,8
7	2
8	2,2
9	2,4
10	2,6
11	2,8
12	3
1	3,2
2	3,4
3	3,6
4	3,8
5	4
6	4,2
7	4,4
8	4,6
9	4,8
10	5
11	5,2
12	5,4

Month	Real
1	1
2	1,1
3	1,2
4	1,4
5	1,5
6	1,6
7	1,7
8	1,8
9	1,9
10	2
11	2,1
12	2,2
1	2,3
2	2,4
3	2,5
4	2,6
5	2,7
6	2,8
7	2,9
8	3
9	3,1
10	3,2
11	3,3
12	3,4

Its two table different, i just want compare the budget with real for each month in simple histogram grouped, i have disabled summarize, but i don't know why its don't work see the chart :

Please thank's for your help,

[kamalmsharma]

Hi,

It seems you have not created a relationship betwee the "Real" and "Budget" tables thats why you are seeing total of budget for each month.

As each month number is repaeting, you have to create columns with uniques month numbers for both tables e.g. 2018_1, 2018_2... 2018_12, 2019_1.. 2019_12. Then create a relationship between the two tables by using these unique columns. 

The visual will work fine then.

Let me know if you need further explaination.

Cheers,

kamal

www.addendanalytics.com

[flochsnt]

Hello,

Thank's for this solution i will test its but i have problem because i have this data too in my table see actualisation :

Entrepot	Month	Budget
A5	2019_1	0,8
A5	2019_2	1
A5	2019_3	1,2
A5	2019_4	1,4
A5	2019_5	1,6
A5	2019_6	1,8
A5	2019_7	2
A5	2019_8	2,2
A5	2019_9	2,4
A5	2019_10	2,6
A5	2019_11	2,8
A5	2019_12	3
B5	2019_1	3,2
B5	2019_2	3,4
B5	2019_3	3,6
B5	2019_4	3,8
B5	2019_5	4
B5	2019_6	4,2
B5	2019_7	4,4
B5	2019_8	4,6
B5	2019_9	4,8
B5	2019_10	5
B5	2019_11	5,2
B5	2019_12	5,4

Entrepot	Mois	Reel
A5	2019_1	1
A5	2019_2	1,1
A5	2019_3	1,2
A5	2019_4	1,4
A5	2019_5	1,5
A5	2019_6	1,6
A5	2019_7	1,7
A5	2019_8	1,8
A5	2019_9	1,9
A5	2019_10	2
A5	2019_11	2,1
A5	2019_12	2,2
B5	2019_1	2,3
B5	2019_2	2,4
B5	2019_3	2,5
B5	2019_4	2,6
B5	2019_5	2,7
B5	2019_6	2,8
B5	2019_7	2,9
B5	2019_8	3
B5	2019_9	3,1
B5	2019_10	3,2
B5	2019_11	3,3
B5	2019_12	3,4

Its correct now?

Thank's i wait your solution 😄

[kamalmsharma]

You can use the month columns in your table to create relationship. The relationship will look something like this.

[flochsnt]

Hello,

Yes, its what i have do but its don't work as you can see :

Can you please tell me what i need to do exactly? I don't understand sorry...

Thank's a lot.

[kamalmsharma]

I noticed the two sets of months are from same year so my earlier solution will not work. Pls see a step-by-step solution in attached document. This should work fine.

Step 1Step 2Step 3

Cheers,

Kamal

www.addendanalytics.com 

[flochsnt · Accepted solution]

Hello,

Thank's for this solution 🙂

I have a problem with the visual? I don't know why...

I have make all step correctly...

Thank's for your help !

[kamalmsharma]

Hi,

Is your problem related to visual fixed?

Regards,

Kamal

[kamalmsharma]

Do you have skype? If yes, pls ping me on kamalmsharma. It will be faster over a call. 

[flochsnt]

Hello,

Invitation sent.

Thank's

[flochsnt]

Hello,

Anyone can help me please?.. not solved 😞

Thank's a lot !