Unable to use filter by parameter selected year - 1

Question

I have created parameter using date - year.

Trying to create below calculation to put it as parameter for one of the table for previous year. E.g. when choosing 2024, the table will then be filter by 2023 and so on. However, error is prompt. Could any expert help? Thank you.

Rajakumar Burra · Answer

This new filter has limitations. It works only for list filters.

May be that is the reason for error.

You can refer below thread.

Parameter Binding option should be available for new Parameter - Derived dates filter. — Oracle Analytics

Kenneth_W · Answer

Hi Gianni

Thanks for prompt reply.

What I am trying to retrieve is

There are 4 purchase order records:

#1 PO Date=2024/11/1; Price=$100; Supplier=ABC

#2 PO Date=2024/12/1; Price=$90; Supplier=XYX

#3 PO Date=2023/11/1; Price=$60; Supplier=ABC

#4 PO Date=2023/12/1; Price=$70; Supplier=XYX

I would like to have dashboard to find out the latest and last year latest price.

So I have created dashboard filter using PO Creation Date - Year to allow user to choose which year they would like to see.

I don't have the issue for the latest price of the selected Year. The Price will be changed based on why user select in the parameter.

However, for last year latest record. The filtering is not work as expected. What ever I choose, the filter just ignore it. In the filter, i just use parameter (…) - 1.

Gianni Ceresa · Answer

Actually I believe you also have an error in the formula you used:

EXTRACTYEAR returns a timestamp for January 1st for the year in which the input value occurs.

That's not what you want, you want just the year, as a number (and not a timestamp), for your date: you should use the YEAR(<date>) function instead.