cube-js/cube

Default TimeDimensions when Select Dimensions

Open

#5,279 创建于 2022年9月12日

在 GitHub 查看
 (1 评论) (0 反应) (0 负责人)Rust (1,965 fork)batch import
help wanted

仓库指标

Star
 (19,563 star)
PR 合并指标
 (平均合并 5天 16小时) (30 天内合并 138 个 PR)

描述

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.

贡献者指南