Calculation is not working using MIN and MAX

Question & Answer
, ,
1

Hi why MIN and MAX wont work in this calculation?

I already tried to tweak this by making this another calculated field but it wont work too

dateDiff(min({created_ts}), max({created_ts}), ‘MI’)

maxOver((
sumOver(ifelse(truncDate(‘DD’, {created_ts}) = truncDate(‘DD’, ${EndDate}), dateDiff(min({created_ts}), max({created_ts}), ‘MI’), NULL), [{client_region_name}], PRE_AGG)

Minus

sumOver(ifelse(truncDate(‘DD’, {created_ts}) = addDateTime(-1, ‘DD’, truncDate(‘DD’, ${EndDate})), dateDiff(min({created_ts}), max({created_ts}), ‘MI’), NULL), [{client_region_name}], PRE_AGG))

Divide /

sumOver(ifelse(truncDate(‘DD’, {created_ts}) = addDateTime(-1, ‘DD’, truncDate(‘DD’, ${EndDate})), dateDiff(min({created_ts}), max({created_ts}), ‘MI’), NULL), [{client_region_name}], PRE_AGG), , PRE_AGG)

2

Hi @danielreyes3rd

Can you elaborate this a little more by giving an example of the raw data and the output from your calculated field to show the issue?

You may have a visual with some filters applied; please include those details as well

3

Hi @danielreyes3rd,
It’s been awhile since we last heard from you, are you still in need of assistance regarding your case or were you able to find a work around?

If we do not hear back within the next 3 business days, I’ll close out this topic.

Thank you!

4

Hi @danielreyes3rd,
Since we haven’t heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for relevant information if needed.

Thank you!