Forum Discussion
Solved
Countx w/ Date Filter
I created this measure to count the number of media arriving for every last hour, but the count isn't accurate. My thinking was to capture the current date/time - 1 hour and simply count the rows gre...
stvn43 , Try if this can help
Hourly Arrival Rate =
VAR AsperaIngestWindow =
NOW() - time(1,0,0)
RETURN
COUNTX(FILTER(AsperaUploads,AsperaUploads[CreateDate] > AsperaIngestWindow), AsperaUploads[SessionID])
stvn43 , Try if this can help
Hourly Arrival Rate =
VAR AsperaIngestWindow =
NOW() - time(1,0,0)
RETURN
COUNTX(FILTER(AsperaUploads,AsperaUploads[CreateDate] > AsperaIngestWindow), AsperaUploads[SessionID])