I’m working on Topic Q and adding some calculated fields to the dataset.
We need to create a measure that dynamically compares the current year’s value to the previous year’s value. For example:
Conversion Rate (Current Year) – Conversion Rate (Previous Year)
The challenge is that users ask questions in plain language in Topic Q, such as:
“Show the gap(difference) in market conversion rate in Germany between 2024 and 2023.”
In this case, the LLM needs to understand “2024” as the base year (from the user’s input) and then automatically calculate the value for 2023 as the previous year.
So my question is:
How can we design a measure that uses the user’s input year as the base and dynamically calculates the difference from the previous year?
This way, users can get the right answer even when they specify a year in their question.
