cube-js / cube-js/cube

Rounding feature for SUM additive measure

Open
#9,065 1 comment 1 reaction 0 assignees View on GitHub
data modeling
Dominant language
Rust
Stars
20.8k
Forks
2.1k
Avg merge
1d 2h
Merged PRs (30d)
181

Description

In cube.js there is not a feature when you want to apply rounding after the additive measured value.
```
some_measure_1: {
sql: `
${CUBE}.col1 - ${CUBE}.col2
`,
type: `sum`,
}

```
we have to introduce another measure for its rounded value
```
some_measure_2: {
sql: `
ROUND(${CUBE.some_measure_1}, 2)
`,
type: `number`,
}

```

or we have to change the type to number and introduce our own sql
```
some_measure_3: {
sql: `
ROUMD(SUM({CUBE.some_measure_1}),2)
`,
type: `number`,
}
```
I am currently using this approach.

There should be some in additive measure object that should should accept rounding integer if required.
like
```
some_measure_1: {
sql: `
${CUBE}.col1 - ${CUBE}.col2
`,
type: `sum`,
round: 2
}

```

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.