Analytical query vs grouped query -> calculate field

What do you mean by “this field”. What are you counting within the visual?
Can you create and share a table visiual with the columns

coupons,
simulates,
effective,
customers,
date,
category,
product