Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all.
Am showing sum of duration for different call type
Now we have to avoid one particular category called ST domestic. ST interinternat etc .. Which will start with ST only.
Please send me the procedure for doing this .
Dimension name is call_type and exp is sum(duration)
Try this? And you want one particular category or string that starts with ST?
= Sum({<call_type -= {“$(=wildmatch(call_type, ‘ST*’)>0”} >}Duration)
try this
sum({<call_type -={'Your excluded call types'}>}duration)
Hi Vishal,
try this:
= Sum({<call_type -= {‘ST*'} >}Duration)
Br,
KC
=sum({<call_type-={"ST*"}>}Duration)
value should be in double quotes.
Thanks all for the reply
How to avoid these ST category in dimension as well.
=if(not wildmatch(call_type,'ST*'),call_type)