Find the Last Date per ID

[RichardLee]

I have to Tables 

A User and a Login History.

how do I display the last date per UserID in a table?

[maxgro]

If you have the User field (or UserID) in both tables

Users:
load * inline [
User
1
2
3
4
];

Login:
LOAD
ceil(rand()*4) as User,
Date(Floor(makedate(2020) + rand()*365*3)) as LoginDate
AutoGenerate 1000;

Make a chart with User as dimension and max(LoginDate) as measure

[RichardLee]

yes user field is in both tables this is how I link the two together.

But the login History has the date of every login the user has performed all I want to do is display the Latest Date on a Chart Table per User Row.  

[RichardLee · Accepted solution]

I've figured it out, Select the Date as a Measure and set it to Max(LoginDate).

[maxgro]

If I understand, if you want all the rows of the Login table

dimensions User and LoginDate

measure max(TOTAL <User> LoginDate)

if you want only the max date for user

dimensions User 

measure max(LoginDate)