How to automate date selector to reflect rolling dates

[Gabriel Yeong]

Hi, I generate daily reports in the form of a table that requires the following info:

a. Yesterday's data

b. Past 3 days data

c. Past 7 days data

d. Past 30 day data

Everyday, I will open the information link and select the past 30 days data, eg. From: 1 Jan 2020; To: 30 Jan 2020

The Spotfire report have been configured by separate tabs (each unaffected by the filter of the other tabs), each tab are separate and have a date slider which I have to manually shift one date to the latest date.

Is there a way to automate this process

For Example, Today:

a. 30 Jan

b. 28 Jan - 30 Jan

c. 24 Jan - 30 Jan

d. 01 Jan - 30 Jan

 

Tomorrow: (Manually change the slider for dates of each tab)

a. 31 Jan

b. 29 Jan - 31 Jan

c. 25 Jan - 31 Jan

d. 02 Jan - 31Jan

[Fabian Duerr]

Possible workaround: Just ask whoever is responsible for the data load to add four new columns to the report that tell you that your data is within one of the four desired date ranges (TRUE/FALSE). Then you could simlply filter the respective columns on each page.

 

So data from two days ago will have TRUE, TRUE, FALSE, FALSE. From today TRUE, FALSE, FALSE, FALSE and so on