help me on below issue in combo chart?

[daisy1438]

Hi 

we need to create below combo chart .

For bar: count( { < Contract_Status = {'Attivo','Esteso'}>}distinct Contract_ID) it sshow perfectly.

2)LIne chart: need calculate the    Max(reference date(Avg goslos )per Month & Year

avg(aggr(sum({<End_Date_Monthname={">=$(VMAX_REF_MONTHNAME)"}>}GOSLOS),End_Date_Monthname)) 

MAX_REF_MONTHNAME=date(max(monthname(Reference_date)),'YYYY-MMM')

but we are not getting proper result.month and year dimension converted into only year.max reference date id 2021 june only.chart must should be start from 2021 june instaed of from 2013.see the below chart after using line expression.

Please help me out ,if anyone having some time.

Thanks

daisy

[sunny_talwar]

May be try adding the set analysis to the Avg() expression also

Avg({<End_Date_Monthname = {">=$(VMAX_REF_MONTHNAME)"}>} Aggr(Sum({<End_Date_Monthname = {">=$(VMAX_REF_MONTHNAME)"}>} GOSLOS), End_Date_Monthname))