Dimension using GROUP BY from View

[gan1]

Hi all, I have a

view: my_app {

…

dimension: time { #… }
dimension: device_id { #… }
dimension: todo {
# SELECT sum(time) FROM my_app GROUP BY device_id
}
}

I would like to ask how I can format the SELECT statement above using LookML.

Thank you for your help!