Please, does anyone have any ideas on how I can increase my reach. I just do not think it is that difficult, but few people are looking at it.
I have now managed to get some results if and only if:
The DATEDIFF calculation has to be done on the primary data source.
I encounter the same problem. I want to calculate the difference between records when they meet a Goal.
So when Goal=0 then there's a datetime.
When Goal=4 then there's another datetime.
The records can be traced based on the same transaction id but I don't seem to manage to calculate the difference between the 2 datetimes.
Is the data source from the same Database?. Are joining tables or blending. Did you try using the above ATTR, MAX, MIN and AVG ?
I solved my case using DATEDIFF on the first primary (first) data source and did not have to use any ATTR,...
Please post the workbook or give more information about your situation.