Here is an example context:
dir | operator | Call ID | context | B_number | code |
Вход (не усп) | O | 790320139 | 10841126052 | 5556133 | 606 |
Исх (не усп) | PDGI/TO-SIP-SS4-INT | 790320140 | 10841126052 | 5556133 | 502 |
Исх (не усп) | el/TO-SIP-SS4-INT | 790320146 | 10841126052 | 5556133 | 503 |
Вход (не усп) | O | 798778645 | 10841126192 | 5221195 | 487 |
Исх (не усп) | fon-PDGI/TO-SIP-SS4-INT | 798778646 | 10841126192 | 5221195 | 503 |
Исх (не усп) | PDGI/TO-SIP-SS4-INT | 798778658 | 10841126192 | 5221195 | 503 |
Исх (не усп) | anet/TO-SIP-SS4-INT | 798778663 | 10841126192 | 5221195 | 487 |
It is necessary to select only those contexts in which the unique B_number and the unique operator number is greater than 2. Calculate how many of these contexts contain a specific operator and are successful (ie dir =Исх (усп))
-----------------------------------------------------
my dimensions:
=Aggr(Count(Distinct operator)>2, context)and Aggr(Count(DistinctB_number)=1, context)
=operator
---------------------------------------------------
I can't write the expression!
Tried it like this but it is not correct:
if(Aggr(Count(Distinct operator)>=3, context)and Aggr(Count(DistinctB_number)=1, context)
,count(Aggr(Count({<dir={"Вход (усп)"}>}context), context)))
----------------------------------
I want to have such table.
operator | all calls | successful operator | successful context | context&503 |
atel | 33 | 11 | 20 | 0 |
irika | 28 | 9 | 0 | 28 |
ELINE-PDGI | 19 | 1 | 3 | 0 |
wer–PDGI | 14 | 1 | 0 | 12 |
K-PDGI | 13 | 1 | 2 | 1 |
S-PDGI | 9 | 4 | 4 | 2 |
ukanet | 6 | 2 | 2 | 0 |
T1 | 5 | 0 | 0 | 1 |
lycomm-PDGI | 3 | 2 | 0 | 0 |
mpelcom | 1 | 0 | 0 | 0 |