Hello!
I have this project have been working with for the past few days now, which is to create a view from a table, and includes the dimensions and measures. I created the view and the dimensions already. The only issue I’m having now is creating the measures based on channels. I’m not sure on how to define a measure that will calculate a sum by channels. I’m confused about the Hours in Adherence Phone ,Hours in Adherence Email and the rest.
If you have Channel as your dimension then you need to create filtered measures like this (i’m just using the simple logic here as I don’t know what your data looks like):
measure: email_adherence_percentage {
type: number
sql: <your sql> ;;
filters: [channel: “email”]
}
The measures I created at first. I don’t know if this is helpful to figure understand my previous asked.
Now copy the measure, and apply the filter I mentioned before