with parameter_settings as (

select

case

when '{{Days}}' = 'Last 30 Days' then 'Last 30 Days'

when '{{Days}}' = 'Last 60 Days' then 'Last 60 Days'

when '{{Days}}' = 'Last 90 Days' then 'Last 90 Days'

when '{{Days}}' = 'Last 180 Days' then 'Last 180 Days'

when '{{Days}}' = 'Last 365 Days' then 'Last 365 Days'

when '{{Days}}' = 'All Time' then 'All Time'

else 'Last 30 Days'

end as time_frame,

case

when '{{Date_Trunc}}' = 'Day' then 'Daily'

when '{{Date_Trunc}}' = 'Week' then 'Weekly'

else 'Daily'

end as date_trunc

select concat('👇🏻 Information in the [', (select time_frame from parameter_settings), '] and on a [', (select date_trunc from parameter_settings), '] Basis 👇🏻') as "Selected Parameters"