Forum Discussion

amelia's avatar
amelia
ETL
05-25-2022
Solved

PREV query getting error

Hi Sisense community,  My goal here is to calculate the total number of subscriptions churned between the current week and the last 4 weeks. However, I am getting an error that says there is an iss...
dashboards & reporting
Data Models
  • harikm007's avatar
    harikm007
    05-26-2022

    Hi amelia ,

    Please try advanced filter as below:

    -Hari

     

  • harikm007's avatar
    harikm007
    05-26-2022

    Hi amelia ,

    Not sure why RANGE function is not working. Please try below formula instead (sum up values of 4 weeks).

    ([Total Subscription churned], PREV([Weeks in Date of Joining], 0)) + 
([Total Subscription churned], PREV([Weeks in Date of Joining], 1)) + 
([Total Subscription churned], PREV([Weeks in Date of Joining], 2)) + 
([Total Subscription churned], PREV([Weeks in Date of Joining], 3))

    -Hari

     

amelia's avatar
amelia
ETL
05-26-2022

Hi Hakim, thanks for the reply! However, when I do this, I do not get a rolling 4 weeks, and only get the last 4 weeks from the most current date. Is there a way to get a rolling 4 weeks based on the current week that I am looking at instead? Thank you 😄

 

harikm007's avatar
harikm007
Data Warehouse
05-26-2022

Hi amelia ,

Not sure why RANGE function is not working. Please try below formula instead (sum up values of 4 weeks).

([Total Subscription churned], PREV([Weeks in Date of Joining], 0)) + 
([Total Subscription churned], PREV([Weeks in Date of Joining], 1)) + 
([Total Subscription churned], PREV([Weeks in Date of Joining], 2)) + 
([Total Subscription churned], PREV([Weeks in Date of Joining], 3))

-Hari

 

  • amelia's avatar
    amelia
    ETL
    05-26-2022

    Nice, this works! Thanks so much for your kind help Hari!!