Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Count occurrences in a time interval

Hi everyone, Have been struggeling with this for a while so I have to ask if someone can help me. Been going through many forum threads but I can't get anything to work.   I need to count the occu...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Try this and let me know if it works:

    Count = 
VAR TwoWeeksafter = [Date] + 14
VAR TwoWeeksbefore = [Date] - 14
VAR PHtoCheck = [PhoneNumber]
RETURN
CALCULATE (
	COUNTROWS (Table);
	ALL (Table);
	Table[PhoneNumber] = PHtoCheck;
	Table[Date] <= TwoWeeksFromDate;
	Table[Date] >= TwoWeeksbefore;	
)
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Try this and let me know if it works:

Count = 
VAR TwoWeeksafter = [Date] + 14
VAR TwoWeeksbefore = [Date] - 14
VAR PHtoCheck = [PhoneNumber]
RETURN
CALCULATE (
	COUNTROWS (Table);
	ALL (Table);
	Table[PhoneNumber] = PHtoCheck;
	Table[Date] <= TwoWeeksFromDate;
	Table[Date] >= TwoWeeksbefore;	
)
LRiley's avatar
LRiley
Frequent Visitor
7 years ago
Hi Ross,
Maybe you can help I'm looking to use the same technique as above however using two tables the first table will have phone number and date then I need to use the same logic but getting the number of occurrences from the second table

Thanks in advance