Hello, I'm writing a LOD calculation, "{ FIXED: MAX({FIXED [Region],DATETRUNC("year",[Order Date]):sum([Sales])})}", it should return the Max regional yearly sales for each year but I'm getting an static value. I've attached the screen
Table Calculation Functions - Tableau
Showing Min & Max and Start & End in Tableau - 2 Methods - USEReady
Filter to max date - FIXED not working?
Showing range of min, avg, and max values
Date, cannot mix aggregate and non-aggregate arguments with this function.
Max and Min of averages over a time period selected by users
Idea: Multiple Mark Labels - (show Min/Max AND Highlighted AND Selected)
Getting the measure value corresponding to the max date in the month, quarter, and year
Advance with Assist: Finding Max Date and More - InterWorks
Min Max Seperate Text Label
Max Function in Tableau: What it is and How to use it - YouTube
How to Highlight the Min & Max Across Months with a Nested LOD - YouTube
How to create a calculation that finds the highest value among category averages
Tableau: Quick Tip: Latest Date and Value in a Calculated Field. - Julian Doublesin - Medium
how to display max, min, median, and average from tableau
How to display Max month in the year.
How to Show Only MAX Values from a Running Total?
How to Default to the Most Recent Dynamic Max Date in Tableau | Playfair+
Finding max value during 15 minute period and displaying peak period per hour
The Data School - Max and Min Functions on a String in Tableau: How does it work?
Max Date Value in Calculated Field
Two values linked by reference line (min-max lollipop? 2-value whisker?)
Need help determining max(date) with multiple dimensions and filters
how to create a parameter with max date.
How to Highlight the Highest and Lowest Points in Tableau | Playfair+
