02-02-2024
01:54 AM
- last edited on
02-02-2024
04:46 AM
by
JackLacava
Hi all, I have created some calculated fields into BI-viewer. I need to use the dashboard parameters into those calculation expressions as I have some calculations according to that. Any idea on how we can do that.
02-02-2024 09:44 AM - edited 04-02-2024 07:02 AM
It's actually super-simple, we just didn't have documentation on it for some time. But now we do!
Have a look at the Bi Viewer Tabs page in the docs, particularly the two sections on Parameter Name Value Pairs. It has examples and all. Should work fine on 7.x releases and above, I don't know about 6.x.
02-04-2024 11:14 PM
Hello
Thank you for the response.
Here in my case, I need to give some calculation in BI-viewer expression using dashboard parameters. For Example: Time (Current year - Prior year). I have two parameters |!CurrYear!| & |!PriorYear!| as literal value in dashboard.
Can we use them inside the calculation that is the concern.
02-05-2024 05:18 AM
You are almost there, just double-click on the parameter name to add it to the expression! 😅 It will appear in the expression as ?Parameter1 .
You can then wire it to Dashboard Parameters by setting the property Parameter Name Value Pairs in the Component Properties tab like this: Parameter1=|!CurYear!| . You can have multiple parameters set up there, separated by commas - eg. MyCurrYear=|!CurYear!|,MyNextYear=|!PriorYear!|