How to use the Dimensions with Max/Min aggregration

Hi I am trying to use the aggregation function in Dimension and it is giving error “is not a valid group by expression”, seems to be its expected, so I see this article https://help.looker.com/hc/en-us/articles/360041919653-How-to-Dimensionalize-a-Measure-in-Looker and it seems to be we can achieve this with derived table but I would like to know is there any way I can do this without using the derived tables

measure I have is
measure: ship_first_time {
type: date_time
sql: MIN(${shipped_first});;
convert_tz: no

}
This is giving the desired results but I want something like this

dimension: ship_first_time {
type: date_time
sql: MIN(${shipped_first});;
convert_tz: no

}

0 0 310
0 REPLIES 0
Top Labels in this Space
Top Solution Authors