How to create a consumption BI report using with two time periods

Discussion in 'Business-Intelligence' started by Kövecses Balázs, May 2, 2018.

  1. Kövecses Balázs

    Kövecses Balázs Administrator Staff Member

    1. Time period: 21:00:00 – 23:59:59 (Start1 between End1)
    2. Time period: 0:00:00 – 07:00:00 (Start2 between End2)
    In this case we have to add the same quantity twice with two other time period settings in the Variables field:

    Screen01.PNG
    After this step we create a new Expression, where we add these two variables.





    Screen02.PNG

    Set the „Grouping period” to 1 hour:

    Screen03.PNG

    The report will show the consumptions from 21:00:00 to 0:00:00 and from 0:00:00 to 7:00:00.

    Screen04.PNG

Share This Page