Forum Discussion

Sarikap96's avatar
Sarikap96
New Contributor II
11 months ago

How to use dashboard parameters into BI-viewer calculated fields

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.

  • JackLacava's avatar
    JackLacava
    Honored Contributor

    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.

    • Sarikap96's avatar
      Sarikap96
      New Contributor II

      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.

       

       

       

      • JackLacava's avatar
        JackLacava
        Honored Contributor

        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!|