I have a derived table on view, the sql goes like:
with events AS (
select create_time, export_duration, upload_duration from datasets
)
select ‘export’ AS phase, min(export_duration), max(export_duration) from events
UNION
select ‘upload’ AS phase, min(upload_duration), max(upload_duration) from events
Since min and max are aggregate function, I cannot put create_time within the outside select clause, but I need to define a dimension based on create_time (so I can add a filter on top of that).
Best answer by Dawid
View original