Date parameter value in results table?

[kuopaz]

Is it possible to get date parameter values into the results table? Say, a user selects a start date and end date - can the selected date range be displayed in the results.

[Ben_Zitney]

Not sure how it would be different for a parameter vs a filter, but here’s how you would do it with a filter:

  filter: date_range {
    type: date
    sql: {% condition date_range %} ${activity_date} {% endcondition %} ;;
  }

  dimension: date_range_value {
    type: string
    sql: ${start_date} || ' to ' || ${end_date}  ;;
  }

  dimension: end_date {
    hidden: yes
    type: date
    sql: {% date_end date_range %} ;;
  }

  dimension: start_date {
    hidden: yes
    type: date
    sql: {% date_start date_range %} ;;
  }

[kuopaz]

Thanks Ben. 

I’ve tried similar but when I put those dimensions into the results table I get an error (SQL Server): “Each GROUP BY expression must contain at least one column that is not an outer reference.” I think because I am trying to put start / end date variables, rather than column names, into the GROUP BY.