Set Analysis

[#1]

Hi All,

Please help me convert below mentioned expression into set analysis.

Expression:

Count(if((Account_Table_ACSAT.Responded='yes' or Account_Table_ACSAT.Responded='Yes') and (Account_Table_ACSAT.Q2_Score=6 or Account_Table_ACSAT.Q2_Score=7),1))
/Count(if((Account_Table_ACSAT.Responded='yes' or Account_Table_ACSAT.Responded='Yes'),1))

Thanks in advance!

Regards,

Ankita

[CELAMBARASAN · Accepted solution]

Hi,

Count({<Account_Table_ACSAT.Responded={'yes', 'Yes'}, Account_Table_ACSAT.Q2_Score={6, 7}>} Account_Table_ACSAT.Responded)

/ Count({<Account_Table_ACSAT.Responded={'yes', 'Yes'}>} Account_Table_ACSAT.Responded)

[#3]

Hi,

Could you plz covert below if condition into set analysis.

Expresion:

if

(isnull(Count(if(Account_Table_Pulse.Responded='Yes' and (Account_Table_Pulse.Q2_Score=6 or Account_Table_Pulse.Q2_Score=7),1))/Count(if(Account_Table_Pulse.Responded='Yes',1))),0,(Count(if(Account_Table_Pulse.Responded='Yes' and (Account_Table_Pulse.Q2_Score=6 or Account_Table_Pulse.Q2_Score=7),1))/Count(if(Account_Table_Pulse.Responded='Yes',1))))

[CELAMBARASAN]

Probably this

Alt(Count({<Account_Table_Pulse.Responded={'Yes'}, Account_Table_Pulse.Q2_Score={6, 7}>} Account_Table_Pulse.Responded) / Count({<Account_Table_Pulse.Responded={'Yes'}>} Account_Table_Pulse.Responded), 0)

[#5]

Hi,

I am getting error "Drawing of chart internally failed" when am using above expression without dimension.