Solved: Dynamic Parameter Filter not working for Date Time... - Page 2

Rams1 · 04-11-2022 08:07 PM

Hi

need help on below issue, I’m trying to pick the filters from one dashboard page and trying to pass those filters to another dashboard which i’m using Link parameters

I’m able to pass for string fields, but I’m not able to do it for Year as my Date dimension is created as below

dimension_group: actual_del {
type: time
timeframes: [
raw,
date,
week,
month,
quarter,
year
]
convert_tz: no
datatype: date
sql: ${TABLE}.actual_del_date ;;
}

=========================Below im using in measure part======================
when i use another column like string data type its working, but when i’m trying to use Year its not working may be bec of timeframes or dont know need support on this

measure: total_Measure {
type: sum
sql: ${Revenue} ;;
link: {
label: "Total Revenue"

"https://xxxxxx.cloud.looker.com/dashboards/675?Year={{_filters['actual_del_date '] | url_encode }}"

}

alrternately i used filters in the url by giving below as well but not worked at all

1.) Year={{_filters['actual_del .year'] | url_encode }}

2.) Year={{_filters['actual_del_date .year'] | url_encode }}

Pleas help how to achive.

dbrinegar

I would check out the link documentation, as it is explained in more depth there than I ever could!

But, taking their example from the “Example: Passing an existing filter value to linked content” section, I think your measure would look something like:

measure: total_Measure {
    type: sum
    sql: ${Revenue} ;;
    link: {
    label: "Total Revenue"
    url: "https://xxxxxx.cloud.looker.com/dashboards/675?Year={{_filters['VIEW_NAME.actual_del_year'] | url_encode }}"
 }
}

where “VIEW_NAME” is the view you defined/wrote the “actual_del” dimension group in.

View solution in original post

Dynamic Parameter Filter not working for Date Timeframes