When referencing a parameter, don’t use double {<!-- -->{. Just {% parameter param_name %} view: test_table { derived_table: { sql: SELECT * FROM {% parameter table_filter %} } filter: table_filter { type: string }}

You have some case mismatch. Your “Measure_fo_filt” value is revenue, not Revenue. I would also avoid anything but lowercase for param names. Try this measure: revenue { label: "Revenue" type: sum sql: ${TABLE}.revenue ;; value_format:"$#,##0;($#,##0...

We just released this open source period over period block. It’s not just one button, but it might do what you need. It also has a series of filters similar to what you described, with the ability to filter current day, yesterday, and last full week ...

Assuming you are using a PDT, you could use a parameter. Example: parameter: max_date { type: date } derived_table: { sql: select * from sometable where the_date &lt;= {% parameter max_date %};; } -- Or you could add an if to still show a value if there...

You could use a parameter (acts like a filter) and put it at the top of the page. Something like parameter: date_selection { allowed_value: {label: "Order Date", value: "order_date"} allowed_value: {label: "Ship Date", value: "ship_date"}}Then in you...