This message was deleted.
# questionsb
brainy-london-213
09/26/2022, 5:10 PMThis message was deleted.
h
handsome-gold-61287
09/27/2022, 8:21 AMAre each "hit" recorded as row in a database, or is it just a tally that increases over time?
r
ripe-book-6760
09/27/2022, 12:52 PMEach press hit is a new record/row in the DB.
ripe-book-6760
09/27/2022, 12:54 PMAbove is a screenshot of how it looks now. I am trying to add additional chart boxes to show additional metrics (i.e. avg per month. total previous week, etc)
s
sticky-area-45739
09/27/2022, 1:34 PM
What are you using for your database @ripe-book-6760? Stacker Tables / Airtable / something else?
r
ripe-book-6760
09/27/2022, 1:44 PMAirtable
s
sticky-area-45739
09/27/2022, 2:07 PM
And when you say "total previous week" do you mean "In the last seven days"?
r
ripe-book-6760
09/27/2022, 2:41 PMYes
s
sticky-area-45739
09/27/2022, 2:56 PM
I think I can see how you would do it to show hits in the seven days
1. Go to Airtable and make sure the Press Hits has a "Created time" field
2. In Airtable create a Formula field (call it "Difference", say) and set it to be the difference of today's date and "Created time" in days - something like
(DATETIME_DIFF(TODAY(), Created, 'days')sticky-area-45739
09/27/2022, 3:30 PM
Let me know if you need a hand setting it up, happy to jump on a call or record a video. I'll have a think about average per month.
r
ripe-book-6760
09/28/2022, 12:09 AMThis worked perfectly. I have it showing press hits in the last 90, 30 and 7 days. I decided not to show average per month, it's not work the trouble. Thank you!
🙌🏻 1