Cube Js | calculate difference between 2 Dates

Question

In cube js finding the count between days is not working for mysql database. Please help me to resolve. While calculating the balance days between....

measures: {
  balanceDays: 
    {
      type: count,
      sql: DATEDIFF(day, '${NmOrder.show_date}', '${NmOrder.booked_date}')   
    },
},

This is also not working

measures: {
      balanceDays: 
        {
          type: count,
          sql: TO_DAYS(${show_date}) - TO_DAYS(${booked_date}) 
        },
    },

@RobG no. Please check once again my question. i made some changes — ramprakash jagadeesan, Sep 18 '19 at 20:34

score 0 · Accepted Answer · edited Sep 18 '19 at 23:30

0

Don't need to mention MySQL keywords. Just simply like below

measures: {
      balanceDays: 
        {
          type: countDistinct,
          sql: show_date - booked_date 
        },
    },

edited Sep 18 '19 at 23:30

avermaet

1,543
12
33

answered Sep 18 '19 at 21:38

Tech Key

101
2

score 0 · Answer 2 · answered Jul 15 '21 at 08:29

0

This works for me.

measures: {
      balanceDays: 
        {
          type: `number`,
          sql: `DAY(${show_date} - ${booked_date})` 
        }
    },

answered Jul 15 '21 at 08:29

halloju

1

Cube Js | calculate difference between 2 Dates

2 Answers2