Expand my Community achievements bar.

Join us for the next Community Q&A Coffee Break on Tuesday April 23, 2024 with Eric Matisoff, Principal Evangelist, Analytics & Data Science, who will join us to discuss all the big news and announcements from Summit 2024!

Monthly visitors with a criteria based on distinct count function ?

Avatar

Level 1

Hello!
I wanted to assess number of visitors that came every month in 2019.
Easily, I used distinct count function with a date range=2019.

 

Alexis-N_0-1597222619666.png

Now, if I add a criteria = "have seen the homepage each month", I can't get a match between total & rows.
It's hard to get to level (visit & visitor) in the same segment.

One way to do so is to create a time-consumming segment with

[month=Jan & page=welcome]

&

[month=Feb & page=welcome]

&

...

&

[month=Dec & page=welcome]

 

Is there no way to keep it simple with the distinct count feature ?

 

Thx!

Alexis

0 Replies