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;	
)
  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Thank you Anonymous!!

     

    This worked out perfectly. Been struggeling for so long, thanks a lot.

  • 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