Difference between two dates with aggr()

[#1]

Hi all!

I'm having a problem while trying to read the difference between two dates

I am using the following formula:

"Interval(fabs(Date#(MQCREATED, 'DD/MM/YYYY hh:mm:ss'))

-

fabs(Date#(aggr(min(MQCREATED),APPT_NUMBER), 'DD/MM/YYYY hh:mm:ss')),'DD')"

But it doesn't show any result.

I've tested 2 things: changing "MQCREATED" for a date (Column 2) and changing "aggr(min(MQCREATED),APPT_NUMBER)" for a date (Column 3). In both cases I've got a result.

I'd like to do only  "MQCREATED - aggr(min(MQCREATED),APPT_NUMBER)". Any thoughts ?

[sunny_talwar]

Would you be able to share a sample to look at?

[#3]

Sure!

What I am trying to do is calculate the time difference between a specific occurrence and the first time this occurrence happened.

Thanks in advance.

[swuehl · Accepted solution]

Maybe like

[#5]

Hey Stefan!

I really liked your approach and yes, it works for my case.

Do you know why my approach was wrong ? Did I miss something ?

Thanks!!!

[swuehl]

In your dimension, you were mixing two different kind of granularities, row based vs. APPT_NUMBER.

I think this grain mismatch causes your issues.