Expression in chart

[QSense]

Hi,

I have an expression below.

=avg ({$<TipDetay= {'Hizmet noktası'} >}Availability)

But I want to show last six months value of above expression

Sum({<[Rapor Tarihi]={'>=$(=MonthStart(Max([Rapor Tarihi]), -5))<=$(=MonthEnd(Max([Rapor Tarihi])))'},[Arıza Rapor Yılı]=>} [Karşılanan Çağrı Oranı]) -->

İn this expression as I understood The field '[Karşılanan Çağrı Oranı] ' will be replaced by 'Availability' field.

But it doesnt work.

Sincerely regards,

[jagan]

Hi,

You can use this expression for finding the last six months average

=avg ({$<[Rapor Tarihi]={'>=$(=MonthStart(Max([Rapor Tarihi]), -5))<=$(=MonthEnd(Max([Rapor Tarihi])))'}, TipDetay= {'Hizmet noktası'} >}Availability)

Hope this helps you.

Regards,

Jagan.

[QSense]

It didnt work for six months

in attached file as you see 4 months value is shown

[jagan · Accepted solution]

Hi,

This expression works, check whether you have data for all the six months.  If you have any month/year fields exclude the selection by using the YearFieldName=, MonthFieldName=.  Try below expression

=avg ({$<YearFieldName=, MonthFieldName= [Rapor Tarihi]={'>=$(=MonthStart(Max([Rapor Tarihi]), -5))<=$(=MonthEnd(Max([Rapor Tarihi])))'}, TipDetay= {'Hizmet noktası'} >}Availability)

Regards.

Jagan.