Choose MAX value on MAX Date

[waqasshah]

Hi Guys,

I need you help. Below is my table and in my chart I would like to display the   maximum Appointment value on Maximum Date. Like I want to display  180 on 26/07/2020. how it can be achieved? Thanks 

Date	Unit	Specialty	Appointments
26/07/2020	NULL	Mechanics	56
26/07/2020	BU1	Mechanics	25
26/07/2020	BU2	Mechanics	180
25/07/2020	NULL	Mechanics	10
25/07/2020	BU1	Mechanics	158
25/07/2020	BU2	Mechanics	91

[sergio0592]

Hi,

Try to add expression in yout chart with :

max(TOTAL {<Date={"=$(=max(Date))"}>} Appointments)

[tresesco]

Try like:

max({<Date={'$(=Date(max(Date)))'}>} Appointments)

[Brett_Bleess]

You have two good responses, we would greatly appreciate if you would return to your thread and be sure to review those and if either or both answer your question, use the Accept as Solution button on the one(s) that did help.  If you did something different, you can post that and then use the button on that post afterward.  The marking of things gives the posters credit for the assistance and lets the other Members know what works, so please be sure to return to the thread and either mark something or leave an update post on what you still need.

Regards,
Brett