Graphs

[Ily]

Hello Everyone,

I wanna say first thank you for all ur efforts, i have new issues  designing graphs. I have the below cases : 

The first , i need to calculate the evolution of a messure from year to year like this. so i have two  dimensions is year, which has values  1,2,3,4,5 and type_benif with values (Conjoint,Assure,Enfant) and measure called nbr_pop .

My problem is i need to show above every bar the evolution by percentage from the previous year for every type benif.

For example, for the green one in year = 2 , i need to show the percentage of evolution , compared to the year 1.

My second issue, is i need to design a graph with two measures and two dimensions like the picture below. 

Dimensions : 

• Année  with Values (2018,2019,2020)
• Type_Benif with Values (Assuré,Conjoint,Enfant)

Measures:

• FraisEngagé
• MontantRemboursé

 For every year, i need to show the measure FraisEngagé by the dimesion type_benif in the same bar, and second bar contains the measure montantremboursé with the same logic. At the end , we have two bar charts separated by the dimension type_benif for every year

Hope my wasn't too long and i was clear.

Thank you so much 

[Taoufiq_Zarra]

Bonjour @Ily ,

est ce que tu peux partager un exemple de donnée source avec le résultat attendu de ces données ?

j'ai pas très bien compris la requête

[Ily]

Hello, 

Thank you for your response.

I need to design a bar chart by two dimensions Year, Type Benif  and above evry bar the % evolution of the measure compare to the previous year 

Year	Type Benif
	Conjoint	Enfant	Assuré
1	15,2	18,7	23,5
2	32,5	31,5	16,4
3	19,2	54,7	39,5

Second Case : 

I have two measures  (Mtt Remb and FE ) and two dimensions (Year,Type benif)

Annee	Type Benif	Mtt Remb	FE
2017	Cjt	23,2	255,2
2017	Enfant	132,5	1457,5
2017	Assures	152,6	1678,6
2018	Cjt	17,2	189,2
2018	Enfant	24,8	272,8
2018	Assures	34,8	382,8
2019	Cjt	69,7	766,7
2019	Enfant	87,9	966,9
2019	Assures	11,6	127,6

I need to design bar chart, for every year two bar charts : 

Hope i'm clear 

Thank you so much @Taoufiq_Zarra