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.
distinct_count({item},[{created}])
@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.
Hi @patilmeet7
We have not heard back from you regarding your question. We would still like to help. If we do not hear back in the next 3 days, we will archive the question.