Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Max(date) group by customer

Avatar

Avatar
Validate 1
Level 1
Corona1968
Level 1

Likes

3 likes

Total Posts

2 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
View profile

Avatar
Validate 1
Level 1
Corona1968
Level 1

Likes

3 likes

Total Posts

2 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
View profile
Corona1968
Level 1

08-03-2018

Hello!!

I'm trying to capture the highest date for the same client and I do not know how to do it.

1436775_pastedImage_1.png

Thank you very much in advance

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Validate 10
MVP
Amit_Kumar
MVP

Likes

329 likes

Total Posts

649 posts

Correct Reply

231 solutions
Top badges earned
Validate 10
Validate 1
Establish
Give Back 50
Give Back 5
View profile

Avatar
Validate 10
MVP
Amit_Kumar
MVP

Likes

329 likes

Total Posts

649 posts

Correct Reply

231 solutions
Top badges earned
Validate 10
Validate 1
Establish
Give Back 50
Give Back 5
View profile
Amit_Kumar
MVP

09-03-2018

Hi

have you seen this?

Using aggregates

  1. Create a query. Here, the goal is to calculate the last known creation date out of all of the recipients in the database. The query therefore does not contain a filter.
  2. Select Add data.
  3. In the windows that open, select Data linked to the filtering dimension then Filtering dimension data.
  4. In the Data to add window, add a column that calculates the maximum value for the Creation date field in the table of recipients. You can use the expression editor or enter max(@created) directly into a field in the Expression column. Then click the Finish button.datamanagement_usecase_2.png
  5. Click Edit additional data then Advanced parameters.... Check the Disable automatic adding of the primary keys of the targeting dimension option.This option ensures that all the recipients are not displayed as a result and that data added explicitly is not kept. In this case, it refers to the last date a recipient was created.Leave the Remove duplicate rows (DISTINCT) option checked.

Answers (1)

Answers (1)

Avatar

Avatar
Validate 1
Level 1
Corona1968
Level 1

Likes

3 likes

Total Posts

2 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
View profile

Avatar
Validate 1
Level 1
Corona1968
Level 1

Likes

3 likes

Total Posts

2 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
View profile
Corona1968
Level 1

11-04-2018

Thanks!!