Hello,
I was helped in what I think was a similar question in Finding the max of a table calc , but I decided to create another post. I think my problem lies in my limited knowledge of window functions and how they combine with Table Calculations.
I've created a dummy workbook in which I'm trying to return the date (in long text format) to highlight when the largest number of orders occurred based on the dimensions of time I have filtered on (needs to be flexible). I tried: if COUNTD([Order ID]) = WINDOW_MAX(COUNTD([Order ID])) THEN ATTR([Order Date]) END but the calculation is returning a * or is repeating the sentence depending on which specific dimensions I set the calculation to.
I'm using Tableau 10.2 - been stumped on this one for a while so any help is greatly appreciated.
Hi Chris,
Instead of creating in another sheet show the date in the same sheet title
Create a calculation like below
Place it in the detail Section
Edit the Title and add the field created
Hope this helps
Plz mark this answer as Correct or helpful to close the thread
BR,
NB
