Very new to Amplitude … I am trying to do something along these lines: TOTALS(B)/PROPCOUNT(A)
where A is Event A Group By product_id AND UserID and B is Event A; but PropCount only considers the first item in a Group By. In PostGres, I could write the same thing as select (count(*)*1.0/count(distinct concat(product_id, UserID)))::decimal as metric from event_a;
, but I have been tasked with writing this in Amplitude. Is there any way to do this in Amplitude? I am looking for the average number of times users visit each product page.
Thanks in advance.
Best answer by belinda.chiu
View original