Max(date) group by customer | Community
Skip to main content
Corona1968
Corona1968
March 8, 2018
Solved

Max(date) group by customer

  • March 8, 2018
  • 2 replies
  • 3666 views

Hello!!

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

Thank you very much in advance

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Best answer by Amit_Kumar

    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.

    2 replies

    Amit_Kumar
    Amit_KumarAccepted solution
    Level 10
    March 9, 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.
      Corona1968
      Corona1968Author
      April 11, 2018

      Thanks!!

      Terms & ConditionsAccessibility statement

      Loading footer...