Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
How i will get [DumpOpen Date] is month
Percentage of Total number of call logs where Type is Incident, Source is Emails and (Email received date - Open date )<=10 mins by Total number of call logs where Type is Incident ,Source is Emails
and Open date is month
=count( {<Type={'Incident'},Source={'E-Mail'},[Call Log ID]={'=interval([Email Received Date]-[DumpOpen Date])<1/24/6'}>} [Call Log ID])
Thanks
You can't do this type of row by row comparison using set analysis; set analysis is performed once for the whole data set, and not on each row.
You can use count(if()) like this:
=count({<Type={'Incident'}, Source={'E-Mail'}>} If([Email Received Date] - [DumpOpen Date] < 1/24/6, [Call Log ID]))
/ count({<Type={'Incident'}, Source={'E-Mail'}>} [Call Log ID])
If that performs poorly, calculate [Email Received Date] - [DumpOpen Date] in a derived field in the load script:
LOAD ....
[Email Received Date] - [DumpOpen Date] As OpenInterval,
...
Then use the field like this
=count({<Type={'Incident'}, Source={'E-Mail'}, OpenInterval= {"<$(=1/24/6)"}>} [Call Log ID])
/
count({<Type={'Incident'}, Source={'E-Mail'}>} [Call Log ID])
Hi Jonathan,
Thanks for your reply but i need Open date is month in set analysis.
Thanks