Calculation for Target

[ShellyG]

Hi there, 

I have the following calculation:

sum({<IS_COMPLETED={'Open'},FM_TI_OFF={0}>}TICKET_CONV_VOLUME)+sum({<IS_COMPLETED={'Open'},FM_TI_OFF={0}>}TICKET_MAIL_VOLUME)

Where:

{<IS_COMPLETED={'Open'},FM_TI_OFF={0}>} is the open tickets for the current month. 

I need to calculate the target for this which is going to be the average of open items per month. Then I need to compare this target with the previous months.

Can you help me with the two calculations - one for calculating the target itself and second for comparing the target to the previous month? 

BR,

Shelly

[PrashantSangle]

post sample data with expected ouput

[Kushal_Chawda]

for average you can try something like below

avg(aggr(sum({<IS_COMPLETED={'Open'}>}TICKET_CONV_VOLUME)+sum({<IS_COMPLETED={'Open'}>}TICKET_MAIL_VOLUME),Month))

then you can compare it with previous month for which you can use the Flag which you have created for previous month