Calculated field that counts the number of views within the last 90 days

Question & Answer
1

Hi everyone. I’m trying to do a calculated field that counts the number of view IDs, if they were viewed in the last 90 days.

Here’s what I entered and keep getting errors on. Any help is appreciated. Thanks!

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

Hello @Quicksightnewguy, welcome to the Quicksight community !

What was error that you received from Quicksight?

I would try this:
count(ifelse(dateDiff({{View Created At},now()) <= 90, {View UUID} = 0, {View UUID}))

I would also try it with count_distinct instead of count.

Let me know if that helps!