Parameter in calculated field syntax error

[auripol]

Hi,

I’m encountering an error while creating a calculated field that uses a parameter. The error message is: “Expression {{argumentName}} for function {{functionName}} has incorrect argument type {{incorrectArgumentType}}. Function syntax expects {{functionSignature}}.”

Here’s what I’m trying to achieve:

1. I have a parameter that acts as a filter for the last 20 trailing weeks (weeks 16-35)

2. This parameter is connected to week number column from my dataset

3. When a user selects a week, I want to calculate:

   • The year-over-year difference for the selected week (2025 vs 2024)

   • The year-over-year difference for the previous week

   • Then subtract these two differences

Here’s my current formula:

(
    sum(ifelse({year} = 2025 and {week} = ${Week1}, {value}, 0)) - 
    sum(ifelse({year} = 2024 and {week} = ${Week1}, {value}, 0))
) - 
(
    sum(ifelse({year} = 2025 and {week} = ${Week2}, {value}, 0)) - 
    sum(ifelse({year} = 2024 and {week} = ${Week2}, {value}, 0))
)

Can you help me identify what’s causing the error and how to fix it?

[Brett]

Hi @auripol and welcome to the Quick Sight community!
I understand what you’re trying to do but there are other functions available that may assist with this type of requirement a bit easier.
Here is some documentation to review regarding period over period computations; there are various ways to handle this based on what works best for your data/scenario.
Based on your scenario, there can be issues with the periodOverPeriodDifference; if so I would suggest looking further into the lag function; the second document below is a prior community post that discusses the use of it further.

Let me know if one of these options works towards your case or if you have any additional questions

periodOverPeriodDifference - Amazon QuickSight

Period Over Period Calculations

Hello everyone! I could not figure out period over period calculations since I am pretty new. Here is my dataset: [image] Basically value equals to numerator/denominator for percentage metrics but for decimals it directly passes. So it gets complicated for me to create a WoW column for both percentage and decimal metrics. For date part I have created final_report_date column from SQL by getting first date of the week. So my dates are only showing the first day of the week. For month part I…

Period Over Period and Other Date Comparison Calculations (YoY, MoM, YTD, Rolling 90 days, etc)

Often you may want to create tables and other visuals which display multiple fields that are all ‘filtered’ to different date periods, as well as period-over-period fields. However we can’t use normal filters for this since filters get applied to all fields in the visual. Conceptually in this solution we are building the filters directly into the calculated field itself (using the ifelse logic), so that each field can have a different ‘filtered’ time period. You can then do whatever math you wan…

[Brett]

Hi @auripol,

Following up here as it’s been awhile since we last heard from you; did you have any additional questions regarding your initial post or were you able to find a work around in the interim?

If we do not hear back within the next 3 business days, I’ll close out this topic.

Thank you!

[Brett]

Hi @auripol,

Since we have not heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community.

Thank you