Is there a way to exclude the value selected from a liquid parameter from a measure

For this issues I have a measure that will calculate the average rate based a users selection, since this will be customer facing(for corporate providers) the selection they chose might change so I used liquid parameters to account for this.

Is there a way to write a measure that will find the average rate for all other corporate providers thus exuding the provider selected in the filter?

Below is the LookML I wrote to find the rate for a specific provider, but also want one that exludes that selection from the filter.

  filter: Corporate_Provider_Account_Filter{
    description: "This Filter receives it values from the suggested dimension"
    type: string
    suggest_dimension: v_corporate_account_hierarchy.corprate_name
  }

  dimension: Corporate_Provider_Account_input {
    description: "This Dimension Takes input from Corporate Provider Account Filter "
    type: yesno
    hidden: yes
    sql: {% condition Corporate_Provider_Account_Filter %}  ${v_corporate_account_hierarchy.corprate_name} {% endcondition %} ;;
  }

  measure: average_rate_specific{
    description: "This measure calculates the avg rate based on the Corporate Provider Selected in the filter only field"
    type: average
    sql: ${amount} ;;
    filters: [Corporate_Provider_Account_input: "yes"]
    value_format: "0.##"
  }

Thank you

1 0 783
0 REPLIES 0
Top Labels in this Space
Top Solution Authors