cube-js/cube

Default TimeDimensions when Select Dimensions

Open

#5,279 建立於 2022年9月12日

在 GitHub 查看
 (1 留言) (0 反應) (0 負責人)Rust (19,563 star) (1,965 fork)batch import
help wanted

描述

Problem

I'm wondering if we can given a default timeDimensions when only selecting dimensions in one query. I mean, it look like cube won't offer a timeDimensions automatically if I firstly choose dimensions. However, if I select measures at the beginning, it will automatically give the first timeDimensions which is defined in backend Schema.

Below are two example, we can clearly see timeDimensions differed from each other.

Firstly choose measures

query  {"measures":["AlarmCodeHistory.count"],"dimensions":[],"segments":[],"timeDimensions":[{"dimension":"AlarmCodeHistory.startTime","dateRange":["2022-09-12T00:00:00.000","2022-09-12T23:59:59.999"]}],"filters":[],"order":[{"id":"AlarmCodeHistory.count","desc":false}],"timezone":"Asia/Taipei"}

image

Firstly choose dimensions

query  {"measures":[],"dimensions":["AlarmCodeHistory.code"],"segments":[],"timeDimensions":[],"filters":[],"order":[{"id":"AlarmCodeHistory.code","desc":false}],"timezone":"Asia/Taipei"}

image

My concern is if we don't give a timeDimension automatically, the query might take much time.

貢獻者指南

Default TimeDimensions when Select Dimensions · cube-js/cube#5279 | Good First Issue