Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have table with the below expressions. The below expressions are giving me bad performance while I am doing in selection
Is there any better way we can modify the below table expressions?
Unique Leads per Center:
avg(aggr(count(distinct CallerNumber), ShopNumber))
Lead Conversion %:
count(distinct IF(InvoiceDateDT - CallDateDT >= 0 and InvoiceDateDT - CallDateDT <= $(vConversionLimit), CallerNumber)) / count(distinct CallerNumber)
Conversion ARO:
avg(
aggr(
max(
IF(
InvoiceDateDT - CallDateDT >= 0 and InvoiceDateDT - CallDateDT <= $(vConversionLimit),
NetAmount
)
)
,InvoiceHeaderId
)
)
Thanks,
Siva
I would say, Make this InvoiceDateDT - CallDateDT as a field in the script
Or if you want the change in the frontend only then may be try
=count(distinct {<CallerNumber={'=$(InvoiceDateDT - CallDateDT)<= $(vConversionLimit)'}>}CallerNumber) / count(distinct CallerNumber)