I would like to use something like this so that I’m able to hide dimensions based on the name of the view. dimension_group: started_on { hidden: "{% if _view._name == 'VIEW NAME' %} yes {% else %} no {% endif %}" type: time timeframes: [ raw, time, d...

Getting some unexpected results when I attempt to pivot a measure by a dimension. I would like the pivoted measure to group under like value. Essentially to collapse on the null values and only have one column for each value of ‘Distance from Invoice...

measure: total_gross_revenue { type: sum sql: ${amount};; filters: [invoice_item_types.name: "-CREDIT_TYPE", invoice_item_types.name: "-DISCOUNT_TYPE" ] Does not make either of the filters work. measure: total_gross_revenue { type: sum sql: ${amount}...