Calculated Field -Dataset

qs cf

I want a calculated field to consider just 1 record for count for each item per day. Right now the value for count is duplicated due to channel.
Maybe something like considering only minimum channel for each item per day will work. I tried doing maxOver minOver ifelse but doesn’t seem to work.

Note: A item may not consist all channel so that’s why I am more inclined towards considering one of the channel for each item per day.

can you do a distinct_count instead and group by day.


1 Like

@Max I want to do sum(count) in pivot table, but I only want to consider 1 occurrence of count for item A and created = ‘2023-05-01’.
This is just an example of how the dataset is, but there will be multiple items and those items will have multiple channel for each created date. That’s why I want some calculated field.