Dynamic params to use with Data Explorer

Data & reporting
1

I have a Data Explorer report using 2 date parameters with hard-coded default values.

-- [params]
-- date :start_date  = 2024-12-01
-- date :end_date    = 2025-01-01

The hard-coded default values work for most of the parameter types, but for the date parameters, I wish we could set dynamic values, like the Monday of current week as the starting date, and the Friday of current week as the ending date:

-- [params]
-- date :start_date  = cast(date_trunc('week', current_date) as date) + 0
-- date :end_date    = cast(date_trunc('week', current_date) as date) + 4

^ this of course didn’t work.

I’d very much like to keep the same report with those exposed date params so that I can continue to run the report manually for different dates if I need to. But I also want to use the same report with Automation plugin for recurring post updates on a topic using the “Schedule a post in a topic with Data Explorer results”.

Any suggestions how I could achieve this?

2 Likes