cancel
Showing results for 
Search instead for 
Did you mean: 

PASTWEEK() & PASTYEAR() formulas in widget

Lars_Menken
7 - Data Storage
7 - Data Storage

Hello, I am having an issue creating a report looking at the week as defined by my dashboard filter versus the previous week as well as the equivalent week in the year before.

Basically, I get my 'original' week very easily. We use Last week in the dashboad filter on the TransactionDate for it to report on the latest (most current) completed week. I saved that as a 'TW Units' which basically comes just down to 'sum([Quantity])', likely the easiest formular available in Sisense.

Using the formula PASTWEEK(TW Units) I am getting the results for the previous week and they match what I pull via SQL from the raw data as well.

In my mind I should just need to use PASTYEAR(TW Units) and should be getting the results from the preceding year for the week I am actually looking at. Instead I am getting returned the same results of the week I am looking at for the current year.

Lars_Menken_0-1691417565151.png

Are those 2 formulas different somehow? There is noting in my elasticube that treats the dates any different.

 

 

 

0 REPLIES 0