IBM Business Analytics

 View Only
Back to discussions
Expand all | Collapse all

Dashboard filter use function

  • 1.  Dashboard filter use function

    Posted Thu November 09, 2023 08:27 AM

    Hello,

    Do you know if it is possible to use functions in filters in dashboards?

    I need to filter data on the login user name like username = (#sq ( $account.personalInfo.userName  ) # )

    I also need another filter data = current_Date but when i drag a field date for create a filter I see the calendar and is not possible to use "current_date"

    in dashboards it is not possible to edit queries like in reports :(

    thanks

    Massimo



    ------------------------------
    Massimo
    ------------------------------


  • 2.  RE: Dashboard filter use function

    Posted Fri November 10, 2023 04:00 AM

    Hi Massimo,

    You need to use/update a data module. In your data module, you should be able to create a calculation, for instance:

    Then you will be able to filter using this new calculation.

    Regarding the current date, you will need to add relative date analysis in your data module. Then you will be able to select your current date before starting your dashboard.

    Best regards,



    ------------------------------
    Patrick Neveu
    Collaboration Betters The World (CBTW)
    IBM Champion
    ------------------------------

    Original Message