Need to get the list of reactivated accounts with in 14 days of account deactivation

Question & Answer
, , ,
1

I have a table with client_id , activation-type (says account is activated or deactivated) and date columns. I need to get the list of all the accounts that are reactivated with in 14 days of deactivation per selected month in redshift. Please advise
image

2

Hi @Madhu_Latha
you could use two filter.

  1. activation-type = “activation”
  2. a relative date filter
    grafik

BR

1 Like
3

Hi @ErikG , I wanted to get the accounts that are only activated after deactivating. Above will give the activated accounts list in the past 14 days. I wanted to filter the data by Month and need the list of retention accounts by month. Is there a way I achieve this in dataset instead of in Quicksight like using row number partition or other methods

Thanks,
Madhu

4

Sorry just read it again.

But what do you mean by “in the dataset instead of QuickSight”? Dataset instead of dashboard?

5

No worries, Managed to get the data

1 Like