How to write chart expression in background script ?

[#1]

Dear all,

I have huge expression in chart, due to which the chart is taking lot of time to load.

I need to write the same expression in backend script. How to do it?

This is  the expression that is needed to be in backend script

Count(distinct if(Num(SLA_MISSED_DATE)<Num(CalendarMonthStart),

          IF(CALL_REQ_OPEN_DATE < TIMESTAMP(CalendarMonthStart),

     If(LEN(CALL_REQ_RESOLVE_DATE1)<1 or CALL_REQ_RESOLVE_DATE1 >TIMESTAMP(CalendarMonthStart),

     IF(INCIDENT_STATUS<>'Cancelled' or (INCIDENT_STATUS='Cancelled' AND CALL_REQ_CLOSE_DATE >TIMESTAMP(CalendarMonthStart)),

     IF(INCIDENT_STATUS<>'Closed' or (INCIDENT_STATUS='Closed' AND CALL_REQ_CLOSE_DATE >CalendarMonthStart),

     IF(INCIDENT_STATUS<>'Closed-Unresolved' or (INCIDENT_STATUS='Closed-Unresolved' AND CALL_REQ_CLOSE_DATE >CalendarMonthStart)

     ,CALL_REQ_REF_NUM)))))))

Here CalendarMonthStart is calendar island, Which was created by me.

Thanks in advance.

Cheers,

Amay Patil

[#2]

Hi all,

Anyone please help on this?

Thanks in advance.

Cheers,

Amay Patil

[SunilChauhan]

hope this help u

     If(LEN(CALL_REQ_RESOLVE_DATE1)<1 or CALL_REQ_RESOLVE_DATE1 >TIMESTAMP(CalendarMonthStart),1) as Flag1

  IF(INCIDENT_STATUS<>'Cancelled' or (INCIDENT_STATUS='Cancelled' AND CALL_REQ_CLOSE_DATE >TIMESTAMP(CalendarMonthStart),1) as Flag2,

IF(INCIDENT_STATUS<>'Closed' or (INCIDENT_STATUS='Closed' AND CALL_REQ_CLOSE_DATE >CalendarMonthStart) ,1) as Flag3

IF(INCIDENT_STATUS<>'Closed-Unresolved' or (INCIDENT_STATUS='Closed-Unresolved' AND CALL_REQ_CLOSE_DATE >CalendarMonthStart),1) as Flag4

and now write at front end

Count(distinct if(Num(SLA_MISSED_DATE)<Num(CalendarMonthStart),

          IF(CALL_REQ_OPEN_DATE < TIMESTAMP(CalendarMonthStart),

     If(Flag1=1,

     IF(Flag2=1,

     IF(Flag4=1,

     IF(Flag3=1
     ,CALL_REQ_REF_NUM)))))))

[#4]

Hi Sunil,

Thanks for reply.

But still not able to do it,Since CalendarMonthStart and CALL_REQ_RESOLVE_DATE1 doesnt have any link.

Both are from different islands.

So how do i write the same in backend?

Cheers,

Amay Patil

[SunilChauhan]

can u share sample