Hello people
i'm building a dashboard in Tableau.
This dashboard will show a line graph of visits, a line graph of visitors, a stacked breakdown of visits split by traffic type, e.g, direct, email, etc. It will also show top pages and i need to be able to split by country. The country will be extracted from two letters of the url, e,g, en or de.
When i first designed this, i used DW to extract this information and i selected the following dimensions:
Referrer
Referring Domains
Referrer type
Pages
And the following metrics
Visits
Visitors
Other items will be on the dashboard but i have to extract them separately through SiteCatalyst - bounces/entries.
My problem as you probably have deduced is that if i were to look at my visits in SiteCatalyst, they wouldn't match what is in my DW extract and i'm thinking its because of the dimensions i'm pulling alongside?
Any advice?