Datetime parameter - default relative datetime and hour control

[alj_pacho]

Hi,

Is there a way to set a default relative date and hour of day for a datetime parameter?

I want to have two parameters so that I’m able to have the default start date set at 8am the previous day and the end date as 8am of the current day.

Alternatively, there could be a workaround with just choosing the day and having a calculated field to create the datetime range I need.

See the screenshot below.

Thanks for any help in advance.

[Max]

I would suggest making a calculated field that subtracts 8 hours from your original timestamp field.

addDateTime(-8,'HH',{timestamp})

Then filter on this field ^

[alj_pacho]

Is there a way to implement that to apply to several visuals, where it gets the last 7 days of data relative to now, and then apply the calculated field you suggested where each graph would correspond to a different day within the last 7 days?

[Max]

Yes you can do this with small multiples in a line chart.

Each small multiple would be the extracted week day.

extract('WD', {date})

Extract - Amazon QuickSight