2 Replies Latest reply: Nov 7, 2017 12:12 PM by Michael Däubler RSS

    Get entry for max date per user

    Michael Däubler

      Hi community,

       

      I have a data base with a table of users (idvisit) and a table with users' actions (event_action) and a time stamp (server_time).

       

      My approach seems to retrieve the latest data base entry, but I'd like to get the latest entry per user (idvisit).

      How can I retrieve the latest action per user in a bar chart?

       

      dimension:

      event_action

       

      measure:

      count({$<server_time={"$(=max(server_time))"}>}idvisit)

       

       

      Thanks!