HI all,
I'm wanting to create a calc field looking like this
{ FIXED MAX[Number] : MIN[DATE] }
Obviously Tableau does not like this as i am using an AGG in the first Part of my calc,
Does anyone know how i can achieve the same results this would provide but using a different calculation.
I will try top anonamyse my data to post and example.
I'm trying to get a MAX of a number and for it to show the first time that number appeared, but i also need to include the date in my data table. As soon as date is added to ROW it shows MAX for each and every Date/Time in the data
ANY HELP?
Good morning
A little unclear on the expectation but see the approach attached
it presents 2 option - one is the overall max number/date the other is the max by week/.network
Overall
max number
date/time you will need to place as a discrete exact data on the shelf)
it returns this in a detail chart
or this in summary
if you wanted by network and week
the max value is
and the date is
it will return this in detail
and this in summary
Jim
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
