I am trying to create a measure of type count_distinct and I want to use it in another measure using type sum. In short I am trying to sum the count_distinct measure.
For Example,
My first measure is "ABC" (type: count_distinct) , second measure is "XYZ" (type: sum on measure ABC). Please see below example:
1. Measure ABC
measure: ABC{
type: count_distinct
sql: ${TABLE}.abc
}
2. Measure XYX
measure: XYZ{
type:sum
sql:ABC
}
I cannot perform this aggregation as it is throwing error. Could you please confirm whether the double aggregation (like example above) can be performed in looker?