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..

Please find following attachment..

In that the issue is last column(agent transferred) in straight table.

Thnaks,

[Anonymous]

Hi Sujeet..

Thanks for your reply..

actually in script i made lots of joins,so i want to make entire formula into set analysis formula with out if conditions..

Thanks,

[Anonymous]

Hi Jagan..

Is there any luk..

Thanks..

[Anonymous]

Hi Jagan..

Can you please help me...

Thanks,

[Anonymous]

Hi Perumal..

  Thanks for your response...

Please find following attachment here agent trasferred expression is =count({$<DISPOSITION={"XA"}>} if(LASTMENUACCESSED=MENUID,MENUID,null()) ).

Can you give me any solution with out using if condition how to write above expression.

I used your formula its not working fine..

please help me...

[jagan]

Hi,

Try this expression

=count({$<DISPOSITION={"XA"}, LASTMENUACCESSED=P(MENUID)>} MENUID)

Regards,

Jagan.

[Anonymous]

Hi Jagan ..

Thanks for your reply..

Please find following attachment in this my formula gives 169118 count.But when i apply your formula it gives different result.Actual count is 169118 please help me..

Thanks,

[Anonymous]

Hi jagan..

Can we used replace function..

=count({$<DISPOSITION={"XA"}, LASTMENUACCESSED={$(replace(MENUID,LASTMENUACCESSED,MENUID))>}MENUID)

i used this but its not work please help me

[Anonymous]

Hi Jagan ..

Please Help me....

Thanks,

[jagan]

Hi,

I am unable to open the attached file, can you attach it again.

Regards,

Jagan.