LookML Dashboard generate ratio

view: conversations {
sql_table_name: "PUBLIC"."CONVERSTATIONS"
;;

dimension: conversationId {
type: string
sql: ${TABLE}."CONVSERSATIONID" ;;
}

dimension: userId {
type: string
sql: ${TABLE}."USERID" ;;
}

dimension: phrase {
type: string
sql: ${TABLE}."PHRASE" ;;
}

dimension_group: endtime {
type: time
datatype: epoch
sql: ${TABLE}."ENDTIME"/1000 ;;
}

dimension_group: starttime {
type: time
datatype: epoch
sql: ${TABLE}."STARTTIME"/1000 ;;
}

dimension: conversationDuration {
type: number
sql: ${endtime_raw} - ${starttime_raw} ;;
}

measure: count {
type: count_distinct
sql: ${conversationId} ;;
}
}

Using this view I can create a lookML dashboard to get the total `count` of conversations per `userId`. Let’s call this `count_per_user`.
I can also add a `phrase` filter and get the total `count` per `userId`.  Let’s call this `phrase_count_per_user`.

Is there a way I can get the ratio of `count_per_user` / `phrase_count_per_user` on a looker dashboard using some lookML? I want to enable filters on `userId` and `phrase`. 

0 1 427
1 REPLY 1
Top Labels in this Space
Top Solution Authors