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