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
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.
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.
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.
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.
Prof Weston you have a wonderful voice and explain the LOD fixed function with date example very clearly, thank you from India.
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
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.
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
Glad it helped. Thanks for watching.
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.
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.
nice one