notification using filters with variable

Hello

People created a notification for a report on which date range is filtered with variables (data is filtered on the past 8 weeks)

The problem is that the notification takes into account the 8 weeks from the day this notification was created and not from the current date.

How can I correct this ? I want every day to extract the data from 8 weeks.

Than you for your help

Find more posts tagged with

Comments

Dan Rosen

One way around this is to build a BQL filter directly on the report (or an alternate version of the report) that dynamically filters on the past 8 weeks. Then your notification does not need a separate filter

Erick Chabenat

smart

thank you

Dan Rosen

no problem. if you want to take it a step further, one thing I've done is add a prompt filter to the dashboard with an integer input. then, in the report, set the report to go the number of weeks back based on that number. still dynamic, but now users can individually choose how many weeks for their notifications

Wichtige Lösungen in der Wissensdatenbank Februar 2013.pdf

Erick Chabenat

fine, how do you do that ? i'm not very comfortable with Birst

Copyright © 2025 Infor. All rights reserved.