Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
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..
Hi,
Please reduce some data and attach the file, currently the file size is very huge.
Regards,
Jagan.
Hi Jagan..
Please find following attachment...
Hi Jagan..
Can you help me...
Thanks,
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.
Hi Jagan..
Thanks for your reply..
Its working fine for me..
Thanks,
Chandini