Value from yesterday

shielmunroe ⚪️
edited January 4 in Beastmode & Analytics

Hi guys,

Im trying to pull in the value from yesterday to fit into a broader formula. The value is followers (social media). Pulling it in from yesterday gives me the latest total followers figure.

Here is my latest attempt:

SUM(`Followers'), DATE()-1)

And broader formula is to achieve daily client account engagement rate by dividing total engagement by number of posts and further divided by the total number of followers on the account on that day:

((SUM(`Likes`) + SUM(`Comments`) + SUM(`Saves`)) / COUNT(DISTINCT `Media Type`)) / SUM(`Followers'), DATE()-1)