how to avoid if condition in Dashboard

[Anonymous]

Hi..

I have formula like =count({$<DISPOSITION={"XA"}>} if(LASTMENUACCESSED=MENUID,MENUID,null()) ) in dash board..

but i have to avoid if(LASTMENUACCESSED=MENUID,MENUID,null()) in dashboard.

Please help me..

please find following attachment..

Thanks,

[Anonymous]

Hi Jagan..

Thanks for your response..

Please find attachment in this my formula gives 169118 but when i apply your formula it gives different count..

Please help me..

[jagan]

Hi,

Please reduce some data and attach the file, currently the file size is very huge.

Regards,

Jagan.

[Anonymous]

Hi Jagan..

Please find following attachment...

[Anonymous]

Hi Jagan..

Can you help me...

Thanks,

[jagan · Accepted solution]

Hi,

Try this in script

IVRREPORTDATA_CALLINFO:

LOAD
*
FROM IVRREPORTDATA_CALLINFO;

Temp:
LOAD
*
FROM IVRReportdata_Menu;

LEFT JOIN(Temp)
LOAD
SessionID,
LASTMENUACCESSED AS TempField
RESIDENT IVRREPORTDATA_CALLINFO;

IVRReportdata_Menu:
LOAD
*,
If(MENUID = TempField, 1, 0) AS Flag
RESIDENT Temp;

DROP TABLE Temp;
DROP FIELD TempField;

Now in chart just use

Count({<Flag = {1}>} DISTINCT MENUID)

OR

Count({<Flag = {1}>} MENUID)

Hope this helps you.

Regards,

Jagan.

[Anonymous]

Hi Jagan..

Thanks for your reply..

Its working fine for me..

Thanks,

Chandini