Creating measures by channel

[ellakanu-165791]

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. 
 

[Dawid]

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”]

}

[ellakanu-165791]

The measures I created at first.  I don’t know if this is helpful to figure understand my previous asked.

[Dawid]

Now copy the measure, and apply the filter I mentioned before