Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)&')')
Are you using ActivityFeedTask_Type__c in Dimesion?
Set analysis can't do branching, only filtering. That means your nested if statement cannot be translated into a set analysis expression.
Set analysis is for filtering and selecting data. It is not a universal replacement for if statements.
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)&')')
Thank you Exprerts for the Promt response