I just started using the software yesterday, still very new. I'm trying to get the users' first & latest date of their booking from our transactional data source. Can you guide me on how to do that?

[APrasad_Tri]

Hi @Woradech (Birdie) Kamlangmuang? ,

Please use the functions MAXDATE() for the latest date and MINDATE() for the first date.

There are 2 ways to get the max date and min date:

• Using the Aggregation

From the toolbar, access the Functions icons and select MAXDATE()

Fill out the date column, sort by and group by with user name or id

• Using Group by

from the toolbar, access the Group By icon

Fill out the data. Depending on your requirement, you can choose between Display type as a new table or a new column.

Hope this helps.

Best,

Apeksha.