3 Replies Latest reply on Jan 25, 2019 1:27 PM by Deepak Rai

Returning the Minimum Time of a Filtered Date using an LOD Expression

Shreyas Talamakki Jan 25, 2019 12:10 PM

How would you set up the LOD expression if I want the minimum date-time of a particular day that's in the viz?

I have set up my LOD currently right now like this { FIXED [Names] : MIN([Offset Action Date]) }

but this is finding the all-time earliest date of the individual and if I change the FIXED to an INCLUDE, the minimum of each HOUR is getting returned, not for each day. How do I make sure that the minimum date of a filter that's applied to the viz is returned?

Action	Action Date	First Transaction
Ship	1/24/2019 18:15	1/14/2019 6:38
Ship	1/24/2019 18:24	1/14/2019 6:38
Ship	1/24/2019 19:39	1/14/2019 6:38
Ship	1/24/2019 22:33	1/14/2019 6:38
Ship	1/24/2019 17:13	1/14/2019 6:38

1. Re: Returning the Minimum Time of a Filtered Date using an LOD Expression

Deepak Rai Jan 25, 2019 12:17 PM (in response to Shreyas Talamakki)

{FIXED Action Date: MIN(Action Date)}
as you can use field both as Dimension and Measure in the LOD

If you want for entire data and not Individual Dates then:

{MIN(Action Date)}

Thanks
Deepak
If it Helps, Pl Mark it Helpful and CORRECT to Close Thread
Like Show 0 Likes(0)

Actions
2. Re: Returning the Minimum Time of a Filtered Date using an LOD Expression

Shreyas Talamakki Jan 25, 2019 1:25 PM (in response to Deepak Rai)

So when I add this calculated field onto the tooltip section, it's returning it in the form of a ATTR(First Transaction) expression, which is causing most of the cells tooltip result to have the asterisk * since there were rows for the date. How can I fix this?
Like Show 0 Likes(0)

Actions
3. Re: Returning the Minimum Time of a Filtered Date using an LOD Expression

Deepak Rai Jan 25, 2019 1:27 PM (in response to Shreyas Talamakki)

No, you will get only one value. * is for multiple values. Please attach some example workbook to check what you are doing .
Like Show 0 Likes(0)

Actions

Go to original post

Tableau Community Forums

Returning the Minimum Time of a Filtered Date using an LOD Expression

1. Re: Returning the Minimum Time of a Filtered Date using an LOD Expression

2. Re: Returning the Minimum Time of a Filtered Date using an LOD Expression

3. Re: Returning the Minimum Time of a Filtered Date using an LOD Expression

Sign In or
Create your Account

Actions

More Like This

Sign In or Create your Account

Sign In or
Create your Account