calculate incidents in a month

[Anonymous]

Hi guys,

I want to calculate cases by Branchcode/Ip_address,month wise in script level, Please find the sample data...Please help me out this issue.I'm manually calculate flag in attached data

[Anonymous]

Hi

try this pivot table ?

aggr(count(BranchCode),BranchCode)

[MindaugasBacius]

Try this:

Aggr(Count(BranchCode), BranchCode, IP_Address)

Outcome:

[MK_QSL · Accepted solution]

Input:
LOAD IP_Address, 
     BranchCode, 
     IP_Address & BranchCode as Key,
     [Case ID+], 
     [Down Since], 
     Month([Down Since]) as Month,
     [Up Since], 
     Flag
FROM
[222759.xlsx]
(ooxml, embedded labels, table is Sheet2);




Left Join (Input)
Load Key, Count(Month) as Flag2 Resident Input
Group By Key;

Drop Field Key;