cube(`monthly_retention`, {
// ...
dimensions: {
months_since_signup: {
sql: `DATEDIFF('month', ${CUBE}.signup_month, ${CUBE}.activity_month)`,
type: `number`,
},
signup_date: {
sql: `(signup_month AT TIME ZONE 'America/Los_Angeles')`,
type: `time`,
},
},
});
cubes:
- name: monthly_retention
# ...
dimensions:
- name: months_since_signup
sql: "DATEDIFF('month', signup_month, activity_month)"
type: number
- name: signup_date
sql: "(signup_month AT TIME ZONE 'America/Los_Angeles')"
type: time
cube(`monthly_retention`, {
// ...
dimensions: {
months_since_signup: {
sql: `DATEDIFF('month', ${CUBE}.signup_month, ${CUBE}.activity_month)`,
type: `number`,
},
signup_date: {
sql: `(signup_month AT TIME ZONE 'America/Los_Angeles')`,
type: `time`,
},
},
});
DangerBox
InfoBoxInfoBox
SuccessBoxSuccessBox
WarningBoxWarningBox
Send Send Yes No
Send Send Yes No
You can implement the element directly by using inline Button component.
SQL query SELECT * FROM users
.
- TODO
Field | Value | Description |
---|---|---|
Host | demo-db.cube.dev |
Foo |
Port | 5432 |
Bar |
Database | ecom |
Baz |
Username | cube |
More Foo |
Password | 12345 |
More Bar |
<Grid cols={2} imageSize={[undefined, 50]}>
<Grid imageSize={[56, 56]}>
Playground is available in Cube Cloud on all tiers.
<EventPromoBlock coverUrl="https://ucarecdn.com/46e9fed6-51af-4ba6-9956-028a205e639f/" startsAt={(new Date()).setDate((new Date()).getDate() + 30)} title="How Rittman Analytics delivers the semantic layer today with Cube" linkText="Register Now" linkUrl="#" />
<EventPromoBlock coverUrl="https://ucarecdn.com/46e9fed6-51af-4ba6-9956-028a205e639f/" startsAt={(new Date()).setDate((new Date()).getDate() + 3)} title="How Rittman Analytics delivers the semantic layer today with Cube" linkText="Register Now" linkUrl="#" />
<EventPromoBlock coverUrl="https://ucarecdn.com/46e9fed6-51af-4ba6-9956-028a205e639f/" startsAt={(new Date()).setDate((new Date()).getDate() - 1)} endsAt={(new Date()).setDate((new Date()).getDate() + 1)} title="How Rittman Analytics delivers the semantic layer today with Cube" linkText="Register Now" linkUrl="#" />
<EventPromoBlock coverUrl="https://ucarecdn.com/46e9fed6-51af-4ba6-9956-028a205e639f/" startsAt={new Date('2023-03-29')} title="How Rittman Analytics delivers the semantic layer today with Cube" linkText="Register Now" linkUrl="#" />
How RamSoft built its users native embedded analytics—in two weeks. Read the case studies.