Calculated field for number views in the last 90 days?

Q&A
, ,
1

I’m looking for a calculated field to count the number of view UUIDS with in the last 90 days. I’ve tried the following formulas with no luck:

  1. count(ifelse(dateDiff({{View Created At},now()) <= 90, {View UUID} = 0, {View UUID}))

2.count(
ifelse(
dateDiff({View Created At},‘now()’) <=90,{View UUID} 0)
{View UUID},
NULL
)
)

I can’t use the relative date filter because I need this in a table next to the total number of views. All help is appreciated

2

Hi @Quicksightnewguy,

Can you try this?

countIf({View UUID}, dateDiff({View Created At}, now()) <= 90)
2 Likes
3

Thank you, my man. That worked