Prof Weston you have a wonderful voice and explain the LOD fixed function with date example very clearly, thank you from India.

@analytics3662

6 ай бұрын

I am still finding a solution for First and Last date case statement for e.g. IF ISNULL([touchpoint_date]) THEN "Date Null" ELSEIF (MAX[touchpoint_date]) THEN 'Last Touch' ELSEIF (MIN[touchpoint_date]) THEN 'First Touch' ELSE 'Mult Touch' END

@TableauWeston

6 ай бұрын

Thank you for the kind words. I think you want to compare the [touchpoint_date] to the First Touch and the Last Touch. I recommend first creating two LOD calculated fields. {FIXED:MAX(touchpoint_date)} as the Last Touch, and {FiXED:MIN(touchpoint_Date)} as the first date. Then use those calculated fields in the IF-THEN calculation.

@TableauWeston

6 ай бұрын

You may need to add additional dimensions to the FIXED calculation. For example, if you only want the Last Touch date for a vendor, product, store location, etc. , then put them in the FIXED calculation like {FIXED vendor, product, storelocation:MAX(touchpoint_Date)}. I hope that helps. Check out my other LOD videos.

Very well explained! This reminds me of the Power BI 'All' function

@TableauWeston

2 жыл бұрын

Glad it helped. Thanks for watching.

this was very helpful. I want to look at individual values vs. an overall average, though. I'm not sure I'm going to be able to mix aggregate with in-aggregated data, though.

Wonderful video about Fixed function, Is it possible to explain a sales scenario with Fixed function? please use sample superstore data set provided by tableau.

nice one