Hi Team,
I'm preparing a report for the daily water drink reminder app. I've to work with 'daily' granularity with the last (latest) session value of the events to get the daily goal completion data of the users.
Event water_sip fires each time when a user logs the 'water drink' to the app to mark the goal progress. The whole drink water goal (regime) starts at 00:00 AM and ends at 11:59. Parameters like sip_count, and goal_completion (percentage of the goal completed) are affected with each water_sip event click. I've defined goal_completion as a custom matrix in GA4.
I am preparing a report for goal_completion by the user of certain day granularity, for that I need the MAX (last/latest) value of the goal_completion parameter.
While defining the calculated field - MAX(CASE WHEN event_name = 'water_sip' THEN goal_completion ELSE NULL END) the error occurs "custom matrix (aggregated value) can't mix with dimension (non-aggregated value)". I know the calculated field can not except the matrix and dimension in the equation, but what is the solution here?
Is there any way to define or derive the max value of goal_completion?
LinkedIn
Twitter
