How to set time interval filter for a quantity in BI module:

Discussion in 'Business-Intelligence' started by kovecses.balazs, Mar 23, 2018.

  1. kovecses.balazs

    kovecses.balazs Administrator Staff Member

    We have the following data in the database:
    01.PNG
    Start BI module. Add new group, set the style file to MatrixReport1.rdlc, add new variable, quantity:
    02.PNG

    03.PNG
    Next

    04.PNG

    Next

    05.png
    Select Operand A - Time Period , Next

    06.PNG

    Save

    07.png
    Select operation: Between, and Set Operand B - Time Period

    08.PNG

    Save

    09.png

    Click to Add and Finish.
    10.PNG

    Create a new Expression with this quantity, Save.
    11.PNG

    Start Query

    12.PNG
    Last edited: Mar 23, 2018

Share This Page