Table Calculation Query (aggregate numbers within custom date range)

[Cathy_Huang]

Hi everyone,
I am looking for some ideas on custom table calculation and really appreciate your help!

I used diff_day functions as filter to select Post URI that have been created for a certain numbers of days (differ_day (Created Date, Traffic Data Date). Now I would like to custom a table calculation that can aggregate Total z_pv from Created Date to Traffic Date Date for each Post URI.

Could anyone share some ideas on how should I create such a table calculation?

Screen Shot 2020-07-08 at 1.43.22 PM|690x79

Many thanks in advance~