Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
I have a expression which returns the 119 seconds:
Interval((Sum(TOTAL{<FirstAgent={'<>0'}>}conv)/Count(TOTAL{<FirstAgent={'<>0'}>}ID)/Count(DISTINCT(Date))) +(Sum(TOTAL{<FirstAgent={'<>0'}>} wrap)/Count(TOTAL{<FirstAgent={'<>0'}>}ID)/Count(DISTINCT(Date))),'ss')
Now I have to convert that 119 secs into 119 as a number so that I can continue my formula.
Any idea how I can do it.
Thanks,
Hasvine
Multiply your expression by: (24*60*60)
Divide all the expression by:
(24*60*60)
Try like this
NUM(
Interval((Sum(TOTAL{<FirstAgent={'<>0'}>}conv)/Count(TOTAL{<FirstAgent={'<>0'}>}ID)/Count(DISTINCT(Date))) +(Sum(TOTAL{<FirstAgent={'<>0'}>} wrap)/Count(TOTAL{<FirstAgent={'<>0'}>}ID)/Count(DISTINCT(Date))),'ss')
)
Hi Avinash & Mindaugas,
Unfortunately, I do not get the right answer.
Thanks,
Hasvine
Multiply your expression by: (24*60*60)
You need it in the NUM format or what is the output your excepting ?? could you please explain us the same with an example ? so that it will help us to understand
Thanks Amit.
It works.
KR,
Hasvine