3 Replies Latest reply on Aug 16, 2018 3:59 AM by Jim Dehner

# min and max CountD(field)'s date

Hi All!

This one is a little tricky for me. I am unable to get the min/max [countDChats]'s date.

So in this above instance, the highest count is 81, on 03 Aug 2018...

And if i select it on 05 Aug, it should show me that the highest count was 2 days ago... (i think i can get this one)

Hope someone can shed some help for this! Thank you...

Zhouyi Zhang

• ###### 1. Re: min and max CountD(field)'s date

Good morning - see the attached

I will take you through the MAX side you can recreate to min side (good practice for you)

YOu will need to determine the max counts as

the date is

the date diff is (note this will produce + and - numbers you can use a conditional statement to determine weather the "Ago" should be replaced with "Hence"

and the tooltip becomes

Jim

If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.

• ###### 2. Re: min and max CountD(field)'s date

omg this is super... Thank you so much for your help!

1 qns tho, i noticed that the creationdate is fixed... how do i amend it so that it is based on my filter?

• ###### 3. Re: min and max CountD(field)'s date

you would include the dimension in the formula before the colon (:)

like           {[fixed],[channel],[direction] :......

what tableau will do is create permutations of all the combinations of the dimensions that precede the colon and aggregate them by what follows the colon - but be aware the LOD's are NOT aggregated in themselves and will need to be aggregated as you use them in any other calculation or bring them to the viz - you may need to decide the appropriate aggregation (e.g. sum(), MIn(), max() etc)

Jim