For anybody that's interested in dynamically counting UVs by any dimension in Tableau without importing millions/billions of rows of data (and getting the data to match Workspace), setting the data source connection to "Live" instead of creating an extract works for this use case. You do have to wai...

Has anyone found a way to dynamically aggregate & count unique visitors using raw data (data feeds) + data viz tool, the way that Workspace does? One solution is importing every distinct ID, but that's too heavy of a dataset for me to use.  The obvious issue is that aggregating at different date gra...

I'm doing a journey analysis using raw data from Adobe data feeds in my GCP table. I want to filter rows to only page view events. Is there a way to do that?

@KumarRishii Thanks for the input. You mean redefine the value that Unique Visitors is set to count?

Yes, that makes sense. It's just hard to believe 90% of my traffic using this segment is considered new. Do you happen to know what other averages are that you've seen?

@Jennifer_Dungan Thanks for this detailed explanation. Are you saying that you'd be counted as 4 UVs in the analysis workspace I pictured above? I thought because the timeframe is set to one (fiscal quarter) you'd only be counted once if you had your first visit within that timeframe.

My logic for the segment is: 

Apologies for a repeated topic. We get roughly 10M UV per quarter. My new visitor logic is (Visitor Container | Visit Number = 1). With this logic, 90% of my UV are "New Visitors." Do I need to adjust my logic for new visitors? This doesn't seem accurate at all.   

Description - When working in a Workspace Table, rows are sometimes custom segments or specific values from another dimension. They stay in order as long as you don't edit any of the metrics. However, when you start adding/removing metrics, the order of your table is lost and you have to rebuild it....

Sorry for all of the replies. I found a solution by not using visit_page_num and instead replacing the logic with visit_start_pagename. This gave me a 0.3% difference: select count(distinct( case when post_pagename like '%account.box%' and visit_start_pagename not like '%account.box%' then concat(p...