Finding the Recent date in Chart Object

[sudhir0538]

Hello Community,

I have a data where a medical team visiting different places for medical camps,there's a possibility that they can visit already visited place twice or thrice and so on.. and they are maintaining a visited date column.

My requirement is to display the last visited date against the location in a straight table. how can I achive this?

the data will be displayed like the above and the village NISHA visited twice on 26-09-2017 and 12-09-2017 so in the last visited date column it should display 12-09-2017 against 26th visited date and on 12th it should display the same date,because it's the first visit for that location.

[devarasu07 · Accepted solution]

Hi,

Try to create Cal. dimension like below,

=aggr(Date(max(Date),'DD-MM-YYYY'),Name)

[sudhir0538]

Hi Devarasu,Thank you!

I already tried this earlier, it's giving correct result for the non first visit and failed for first visit. Please look at the result for NISHA.

For 2nd record the 12-09-2017 needs to be appeared.

[jonathandienst]

Still not clear what you require. Please provide a full sample (not an image) with the visit date, village name and required value for last visit.

[sudhir0538]

Hello Jonathan and Devarasu,I am very sorry the solution which I did earlier and what you proposed are same and it's suffice for this requirement.

Due to the lack of clarity in FS doc I got confused and made you guys confused.

Thank you so much for the help!!