PQL formula to calculate total records of yesterday run

Hi All,

There is a table name X with columns “table_Name”, “row_count” and “job_run_date”. Could you help me to write PQL formula to calculate records of yeterday job run(“yesterday records”). I am trying to use the OLAP table to have columns “table_name”, “yesterday records”, “today records”, “job_run_date”,

The SQL query(to clculate column “yesterday records” in OLAP table) could be in the form of below:

select sum(“row_count”)
from X
where “job_run_date”= (MAX(job_run_date) -1)