05-27-2015 06:19 AM
I am creating a dashboard with SAS BI Dashboard 4.3, that contains a prompt through which the user can choose the year of competence.
The dashboard also contains a KPI that should show the results of the year chosen by the user and the previous year.
I need the source data of the KPI is an Infomap or a query on the table.
Is there a way to dynamically calculate the year preceding the one chosen by the prompt? Or a way to pass the query parameter chosen?
I apologize if I was not clear.
Thanks for your answers.