Suggest me the set analysis format for If statement

[Anonymous]

Hi,

Suggest me the set analysis format for the below If statement

if(only(ActivityFeedTask_Type__c)='Call', 'Call'  & ' ( ' & count(ActivityFeedTask_Type__c)& ' ) ',

if(only(ActivityFeedTask_Type__c)='SalesApp activity', 'SalesApp Activity'  & ' ( ' & count(ActivityFeedTask_Type__c)& ' ) '

)

)

For improving the perfomacne i want present this expression with Set Analysis

In-Advance

Thank You

[Kushal_Chawda]

Are you using ActivityFeedTask_Type__c in Dimesion?

[Gysbert_Wassenaar]

Set analysis can't do branching, only filtering. That means your nested if statement cannot be translated into a set analysis expression.

[jonathandienst]

Set analysis is for filtering and selecting data. It is not a universal replacement for if statements.

[Kushal_Chawda · Accepted solution]

Instead of IF you can use, Pick, match with set analysis

pick(match(ActivityFeedTask_Type__c,'Call','SalesApp activity'),

ActivityFeedTask_Type__c&'('&count({<ActivityFeedTask_Type__c={'Call'}>}ActivityFeedTask_Type__c)&')',

ActivityFeedTask_Type__c&'('&count({<ActivityFeedTask_Type__c={'SalesApp activity'}>}ActivityFeedTask_Type__c)&')')

[Anonymous]

Thank you Exprerts for the Promt response