Conditional min for each group

Refer to the attachment(dummy data)

For each group, I need to create a conditional min of column (log date)when
the (cum users count) for each group is more than 50.

For example: for customer1, on 8/5/21 we see that “cum users count” have exceeded 50, so I need a column (“Live date”) as 8/5/21.

i tried creating a column with minOver and minIf function, but there is an issue of aggregated and non aggregated field. Is it posiible to get the column “Live date” from calculations in Quicksight?

Should be doable with minOver() and an if statement to only consider dates that meet the criteria, as follows:

minOver(ifelse({cum users count} > 50, logDate, NULL), [{Group}], PRE_AGG)

Thanks Darcoli, for your response. but I have tried this and there is an error with this formula.
“cum users count” is aggregated field while log date is not.

Can you please show me your existing definition for cum users count?

Ok I suppose cum users count is some runningCount calculation.

In that case, you can calculate Live date as follows

minOver(
  ifelse({cumulative users count} > 50 , min({log date}), null)
  , [Group]
)
1 Like