Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
Hi,
Try to add expression in yout chart with :
max(TOTAL {<Date={"=$(=max(Date))"}>} Appointments)
Try like:
max({<Date={'$(=Date(max(Date)))'}>} Appointments)
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