Spotfire - How to Use Custom Expression to Pull Prior Quarter Data

Question

I have a Spotfire analysis built that was working for 2024 data, but is no longer working now that it is 2025.

Here is an example - this expression was built to pull volumes for both the previous 3 years in one column, and the previous quarter in another column:

Count(Case when ([Bucket Procedure]="CAB") and ([Bucket Rolling 3 Years]=1) then [STS Record ID] else null end) as [Rolling 3 Years], Count(Case when ([Bucket Procedure]="CAB") and ((Quarter(DateTimeNow()) - 1)=Quarter([Surgery Date])) and (Year(DateTimeNow())=Year([Surgery Date])) then [STS Record ID] else null end) as [Prior Quarter]

The first column that pulls the rolling 3 years data seems to be fine.

The second that should pull the prior quarter (Oct - Dec = Q4 2024 in this case) is pulling nothing but zeros when I can tell from the source that there should be data showing.

I have a whole series of tables that run on the same logic, but are specific to either the rolling 3 years or the previous quarter. Only the previous quarter ones seem to not work.

It seems like a simple fix, I just have not been able to figure it out just yet.

Any assistance would be appreciated.