Input parameter in Analytical View

[former_member205144]

Hi,

   I have a requirement, where user will enter a year in input parameter.But, the result will have the data of year entered by user and year-1 .

  Can can I achieve this??

Regards

Lavanya

[anindya_bose]

Hi Lavanya

I would prefer to do it in Calculation View.

Either I would create a fresh calculation view or I shall put already existing analytic view in a graphical calculation view.

This is because Calculation View supports complex filter eka Filter Expression.

Step 1:  Attach the Analytic View in Projection Node.

Step 2.  Creation Input Parameter on the Cal View

Step 3;  In filter expression put the following syntax

"YEAR" = '$$USER_YEAR$$' OR  "YEAR" = ( '$$USER_YEAR$$' - 1 )

Let me know for any issue.

Cheers

Anindya

[lucas_oliveira]

Hi,

I don't see why not. You can build two calc attributes based on the input parameter, one for the first day of the previous year and another for the last day of the year selected, and finally use them for filtering the date you need to filter.

BRs,

Lucas de Oliveira