Question

Create Automated Custom Date Range in Dashboard

  • 10 July 2023
  • 1 reply
  • 35 views
N

Hi everyone,

 

We are looking into having a custom “12 rolling months” setting.

For example we are (day of posting) 07/10/23 and I would like to have some of my dashboards to automatically only show full month data: i.e 07/01/22 to 06/30/23.

When using the existing feature it will always take into account current month, despite the fact that we`re not even half-way done… which obviously skews the data.

We are also aiming for the same thing with different time ranges D-7 -­to- D+1 for specific dashboards.

 

Please let me know if this is possible. Any help or ways to circumvent that issue is welcome!

 

Thank you so much and hope you have a great day :) 

1 reply

T

Hi,

There’s probably a way to write it in the dashboard, but I’ve usually written it into the BAQ, using the phrase build, table criteria. 

The Filter value allows you to use a specified expression - then choose a BAQ Constant (like LastDayOfPrevMonth or FirstDayOfMonth).

This will limit what you can pull into the dashboards, though. So the user won’t be able to change the date range beyond that year.

There’s probably another way of doing it, but this seems to work for us.

 

Trudie Coons

Reply


Terms & Conditions