Tableau - Introduction to the FIXED level of detail (LOD) function
ฝัง
- เผยแพร่เมื่อ 25 ส.ค. 2024
- Walk step-by-step as I use the FIXED function to compare current year performance to performance over multiple years.
Side by side comparison of data with and without the FIXED function. See what happens when the FIXED field is missing.
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.
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