**************************************************************************** Location : Tableau Server Host : http://bnbrepository9/#/ Path : Tableau Samples/Opportunity Overview **************************************************************************** Workbook Information Author: Unknown Embedded Datasources Datasource: Opportunities (Salesforce) Connection Data Sources Data Source: Opportunities (Salesforce) Attributes REDIRECT_URI: https://login.salesforce.com/services/oauth2/success SCOPE: api id refresh_token authentication: auth-oauth class: salesforce compressed-responses: yes compressed-responses-bulk: yes compressed-responses-rest: yes compressed-responses-soap: yes kind: standard maxfieldlength: 4096 pagesize: 200 prefer-ind-semantics: true salesforce-api-version: 30.0 server: login.salesforce.com sf-total-requestor-buffer-size-in-mb: 32 standard: Opportunities userLanguage: en_US workgroup-auth-mode: as-is Data Source: UnknownNotSet Attributes class: federated prefer-ind-semantics: true Tables Table: Opportunities Database Object: [Opportunity] Connection: Opportunities (Salesforce) Table: Account Database Object: [Account] Connection: Opportunities (Salesforce) Table: Owned By Database Object: [User] Connection: Opportunities (Salesforce) Table: OpportunityLineItem Database Object: [OpportunityLineItem] Connection: Opportunities (Salesforce) Table: PricebookEntry Database Object: [PricebookEntry] Connection: Opportunities (Salesforce) Table: Product2 Database Object: [Product2] Connection: Opportunities (Salesforce) Table: Manager Database Object: [User] Connection: Opportunities (Salesforce) Dimension Account Dimension: Account Fax Role: Discrete Dimension Remote Column: [Account].[Fax] Data Type: string Dimension: Account Name Role: Discrete Dimension Remote Column: [Account].[Name] Data Type: string Dimension: Account Number Role: Discrete Dimension Remote Column: [Account].[AccountNumber] Data Type: string Dimension: Account Phone Role: Discrete Dimension Remote Column: [Account].[Phone] Data Type: string Dimension: Account Rating Role: Discrete Dimension Remote Column: [Account].[Rating] Data Type: string Dimension: Account Site Role: Discrete Dimension Remote Column: [Account].[Site] Data Type: string Dimension: Account Source Role: Discrete Dimension Remote Column: [Account].[AccountSource] Data Type: string Dimension: Account Type Role: Discrete Dimension Remote Column: [Account].[Type] Data Type: string Dimension: Active__c (Account) Role: Discrete Dimension Remote Column: [Account].[Active__c] Data Type: string Dimension: Billing City Role: Discrete Dimension Remote Column: [Account].[BillingCity] Data Type: string Dimension: Billing Country Role: Discrete Dimension Remote Column: [Account].[BillingCountry] Data Type: string Dimension: Billing State/Province Role: Discrete Dimension Remote Column: [Account].[BillingState] Data Type: string Dimension: Billing Street Role: Discrete Dimension Remote Column: [Account].[BillingStreet] Data Type: string Dimension: Billing Zip/Postal Code Role: Discrete Dimension Remote Column: [Account].[BillingPostalCode] Data Type: string Dimension: Clean Status Role: Discrete Dimension Remote Column: [Account].[CleanStatus] Data Type: string Dimension: CreatedById (Account) Role: Discrete Dimension Remote Column: [Account].[CreatedById] Data Type: string Dimension: CreatedDate (Account) Role: Discrete Dimension Remote Column: [Account].[CreatedDate] Data Type: datetime Dimension: Customer Priority Role: Discrete Dimension Remote Column: [Account].[CustomerPriority__c] Data Type: string Dimension: D&B Company ID Role: Discrete Dimension Remote Column: [Account].[DandbCompanyId] Data Type: string Dimension: D-U-N-S Number Role: Discrete Dimension Remote Column: [Account].[DunsNumber] Data Type: string Dimension: Data.com Key Role: Discrete Dimension Remote Column: [Account].[Jigsaw] Data Type: string Dimension: Deleted Role: Discrete Dimension Remote Column: [Account].[IsDeleted] Data Type: boolean Dimension: Industry Role: Discrete Dimension Remote Column: [Account].[Industry] Data Type: string Dimension: Jigsaw Company ID Role: Discrete Dimension Remote Column: [Account].[JigsawCompanyId] Data Type: string Dimension: Last Activity Role: Discrete Dimension Remote Column: [Account].[LastActivityDate] Data Type: date Dimension: LastModifiedById (Account) Role: Discrete Dimension Remote Column: [Account].[LastModifiedById] Data Type: string Dimension: LastModifiedDate (Account) Role: Discrete Dimension Remote Column: [Account].[LastModifiedDate] Data Type: datetime Dimension: LastReferencedDate (Account) Role: Discrete Dimension Remote Column: [Account].[LastReferencedDate] Data Type: datetime Dimension: LastViewedDate (Account) Role: Discrete Dimension Remote Column: [Account].[LastViewedDate] Data Type: datetime Dimension: Master Record ID Role: Discrete Dimension Remote Column: [Account].[MasterRecordId] Data Type: string Dimension: NAICS Code Role: Discrete Dimension Remote Column: [Account].[NaicsCode] Data Type: string Dimension: NAICS Description Role: Discrete Dimension Remote Column: [Account].[NaicsDesc] Data Type: string Dimension: Owner ID Role: Discrete Dimension Remote Column: [Account].[OwnerId] Data Type: string Dimension: Ownership Role: Discrete Dimension Remote Column: [Account].[Ownership] Data Type: string Dimension: Parent Account ID Role: Discrete Dimension Remote Column: [Account].[ParentId] Data Type: string Dimension: Photo URL Role: Discrete Dimension Remote Column: [Account].[PhotoUrl] Data Type: string Dimension: SIC Code Role: Discrete Dimension Remote Column: [Account].[Sic] Data Type: string Dimension: SIC Description Role: Discrete Dimension Remote Column: [Account].[SicDesc] Data Type: string Dimension: SLA Expiration Date Role: Discrete Dimension Remote Column: [Account].[SLAExpirationDate__c] Data Type: date Dimension: SLA Serial Number Role: Discrete Dimension Remote Column: [Account].[SLASerialNumber__c] Data Type: string Dimension: SLA Role: Discrete Dimension Remote Column: [Account].[SLA__c] Data Type: string Dimension: Shipping City Role: Discrete Dimension Remote Column: [Account].[ShippingCity] Data Type: string Dimension: Shipping Country Role: Discrete Dimension Remote Column: [Account].[ShippingCountry] Data Type: string Dimension: Shipping State/Province Role: Discrete Dimension Remote Column: [Account].[ShippingState] Data Type: string Dimension: Shipping Street Role: Discrete Dimension Remote Column: [Account].[ShippingStreet] Data Type: string Dimension: Shipping Zip/Postal Code Role: Discrete Dimension Remote Column: [Account].[ShippingPostalCode] Data Type: string Dimension: SystemModstamp (Account) Role: Discrete Dimension Remote Column: [Account].[SystemModstamp] Data Type: datetime Dimension: Ticker Symbol Role: Discrete Dimension Remote Column: [Account].[TickerSymbol] Data Type: string Dimension: Tradestyle Role: Discrete Dimension Remote Column: [Account].[Tradestyle] Data Type: string Dimension: Upsell Opportunity Role: Discrete Dimension Remote Column: [Account].[UpsellOpportunity__c] Data Type: string Dimension: Website Role: Discrete Dimension Remote Column: [Account].[Website] Data Type: string Dimension: Year Started Role: Discrete Dimension Remote Column: [Account].[YearStarted] Data Type: string Manager Dimension: AboutMe (User) Role: Discrete Dimension Remote Column: [Manager].[AboutMe] Data Type: string Dimension: AccountId (User) Role: Discrete Dimension Remote Column: [Manager].[AccountId] Data Type: string Dimension: Alias (User) Role: Discrete Dimension Remote Column: [Manager].[Alias] Data Type: string Dimension: CallCenterId (User) Role: Discrete Dimension Remote Column: [Manager].[CallCenterId] Data Type: string Dimension: City (User) Role: Discrete Dimension Remote Column: [Manager].[City] Data Type: string Dimension: CommunityNickname (User) Role: Discrete Dimension Remote Column: [Manager].[CommunityNickname] Data Type: string Dimension: CompanyName (User) Role: Discrete Dimension Remote Column: [Manager].[CompanyName] Data Type: string Dimension: ContactId (User) Role: Discrete Dimension Remote Column: [Manager].[ContactId] Data Type: string Dimension: Country (User) Role: Discrete Dimension Remote Column: [Manager].[Country] Data Type: string Dimension: CreatedById (User) Role: Discrete Dimension Remote Column: [Manager].[CreatedById] Data Type: string Dimension: CreatedDate (User) Role: Discrete Dimension Remote Column: [Manager].[CreatedDate] Data Type: datetime Dimension: DefaultGroupNotificationFrequency (User) Role: Discrete Dimension Remote Column: [Manager].[DefaultGroupNotificationFrequency] Data Type: string Dimension: DelegatedApproverId (User) Role: Discrete Dimension Remote Column: [Manager].[DelegatedApproverId] Data Type: string Dimension: Department (User) Role: Discrete Dimension Remote Column: [Manager].[Department] Data Type: string Dimension: DigestFrequency (User) Role: Discrete Dimension Remote Column: [Manager].[DigestFrequency] Data Type: string Dimension: Division (User) Role: Discrete Dimension Remote Column: [Manager].[Division] Data Type: string Dimension: EmailEncodingKey (User) Role: Discrete Dimension Remote Column: [Manager].[EmailEncodingKey] Data Type: string Dimension: EmailPreferencesAutoBcc (User) Role: Discrete Dimension Remote Column: [Manager].[EmailPreferencesAutoBcc] Data Type: boolean Dimension: EmailPreferencesAutoBccStayInTouch (User) Role: Discrete Dimension Remote Column: [Manager].[EmailPreferencesAutoBccStayInTouch] Data Type: boolean Dimension: EmailPreferencesStayInTouchReminder (User) Role: Discrete Dimension Remote Column: [Manager].[EmailPreferencesStayInTouchReminder] Data Type: boolean Dimension: Email Role: Discrete Dimension Remote Column: [Manager].[Email] Data Type: string Dimension: EmployeeNumber (User) Role: Discrete Dimension Remote Column: [Manager].[EmployeeNumber] Data Type: string Dimension: Extension (User) Role: Discrete Dimension Remote Column: [Manager].[Extension] Data Type: string Dimension: Fax (User) Role: Discrete Dimension Remote Column: [Manager].[Fax] Data Type: string Dimension: FederationIdentifier (User) Role: Discrete Dimension Remote Column: [Manager].[FederationIdentifier] Data Type: string Dimension: FirstName (User) Role: Discrete Dimension Remote Column: [Manager].[FirstName] Data Type: string Dimension: ForecastEnabled (User) Role: Discrete Dimension Remote Column: [Manager].[ForecastEnabled] Data Type: boolean Dimension: FullPhotoUrl (User) Role: Discrete Dimension Remote Column: [Manager].[FullPhotoUrl] Data Type: string Dimension: IsActive (User) Role: Discrete Dimension Remote Column: [Manager].[IsActive] Data Type: boolean Dimension: IsBadged (User) Role: Discrete Dimension Remote Column: [Manager].[IsBadged] Data Type: boolean Dimension: LanguageLocaleKey (User) Role: Discrete Dimension Remote Column: [Manager].[LanguageLocaleKey] Data Type: string Dimension: LastLoginDate (User) Role: Discrete Dimension Remote Column: [Manager].[LastLoginDate] Data Type: datetime Dimension: LastModifiedById (User) Role: Discrete Dimension Remote Column: [Manager].[LastModifiedById] Data Type: string Dimension: LastModifiedDate (User) Role: Discrete Dimension Remote Column: [Manager].[LastModifiedDate] Data Type: datetime Dimension: LastName (User) Role: Discrete Dimension Remote Column: [Manager].[LastName] Data Type: string Dimension: LastPasswordChangeDate (User) Role: Discrete Dimension Remote Column: [Manager].[LastPasswordChangeDate] Data Type: datetime Dimension: LastReferencedDate (User) Role: Discrete Dimension Remote Column: [Manager].[LastReferencedDate] Data Type: datetime Dimension: LastViewedDate (User) Role: Discrete Dimension Remote Column: [Manager].[LastViewedDate] Data Type: datetime Dimension: LocaleSidKey (User) Role: Discrete Dimension Remote Column: [Manager].[LocaleSidKey] Data Type: string Dimension: ManagerId (User) Role: Discrete Dimension Remote Column: [Manager].[ManagerId] Data Type: string Dimension: MobilePhone (User) Role: Discrete Dimension Remote Column: [Manager].[MobilePhone] Data Type: string Dimension: OfflinePdaTrialExpirationDate (User) Role: Discrete Dimension Remote Column: [Manager].[OfflinePdaTrialExpirationDate] Data Type: datetime Dimension: OfflineTrialExpirationDate (User) Role: Discrete Dimension Remote Column: [Manager].[OfflineTrialExpirationDate] Data Type: datetime Dimension: Phone (User) Role: Discrete Dimension Remote Column: [Manager].[Phone] Data Type: string Dimension: Photo Role: Discrete Dimension Remote Column: [Manager].[SmallPhotoUrl] Data Type: string Dimension: PostalCode (User) Role: Discrete Dimension Remote Column: [Manager].[PostalCode] Data Type: string Dimension: ProfileId (User) Role: Discrete Dimension Remote Column: [Manager].[ProfileId] Data Type: string Dimension: ReceivesAdminInfoEmails (User) Role: Discrete Dimension Remote Column: [Manager].[ReceivesAdminInfoEmails] Data Type: boolean Dimension: ReceivesInfoEmails (User) Role: Discrete Dimension Remote Column: [Manager].[ReceivesInfoEmails] Data Type: boolean Dimension: SenderEmail (User) Role: Discrete Dimension Remote Column: [Manager].[SenderEmail] Data Type: string Dimension: SenderName (User) Role: Discrete Dimension Remote Column: [Manager].[SenderName] Data Type: string Dimension: Signature (User) Role: Discrete Dimension Remote Column: [Manager].[Signature] Data Type: string Dimension: State (User) Role: Discrete Dimension Remote Column: [Manager].[State] Data Type: string Dimension: StayInTouchNote (User) Role: Discrete Dimension Remote Column: [Manager].[StayInTouchNote] Data Type: string Dimension: StayInTouchSignature (User) Role: Discrete Dimension Remote Column: [Manager].[StayInTouchSignature] Data Type: string Dimension: StayInTouchSubject (User) Role: Discrete Dimension Remote Column: [Manager].[StayInTouchSubject] Data Type: string Dimension: Street (User) Role: Discrete Dimension Remote Column: [Manager].[Street] Data Type: string Dimension: SystemModstamp (User) Role: Discrete Dimension Remote Column: [Manager].[SystemModstamp] Data Type: datetime Dimension: TimeZoneSidKey (User) Role: Discrete Dimension Remote Column: [Manager].[TimeZoneSidKey] Data Type: string Dimension: Title (User) Role: Discrete Dimension Remote Column: [Manager].[Title] Data Type: string Dimension: UserPermissionsCallCenterAutoLogin (User) Role: Discrete Dimension Remote Column: [Manager].[UserPermissionsCallCenterAutoLogin] Data Type: boolean Dimension: UserPermissionsInteractionUser (User) Role: Discrete Dimension Remote Column: [Manager].[UserPermissionsInteractionUser] Data Type: boolean Dimension: UserPermissionsJigsawProspectingUser (User) Role: Discrete Dimension Remote Column: [Manager].[UserPermissionsJigsawProspectingUser] Data Type: boolean Dimension: UserPermissionsKnowledgeUser (User) Role: Discrete Dimension Remote Column: [Manager].[UserPermissionsKnowledgeUser] Data Type: boolean Dimension: UserPermissionsMarketingUser (User) Role: Discrete Dimension Remote Column: [Manager].[UserPermissionsMarketingUser] Data Type: boolean Dimension: UserPermissionsMobileUser (User) Role: Discrete Dimension Remote Column: [Manager].[UserPermissionsMobileUser] Data Type: boolean Dimension: UserPermissionsOfflineUser (User) Role: Discrete Dimension Remote Column: [Manager].[UserPermissionsOfflineUser] Data Type: boolean Dimension: UserPermissionsSFContentUser (User) Role: Discrete Dimension Remote Column: [Manager].[UserPermissionsSFContentUser] Data Type: boolean Dimension: UserPermissionsSiteforceContributorUser (User) Role: Discrete Dimension Remote Column: [Manager].[UserPermissionsSiteforceContributorUser] Data Type: boolean Dimension: UserPermissionsSiteforcePublisherUser (User) Role: Discrete Dimension Remote Column: [Manager].[UserPermissionsSiteforcePublisherUser] Data Type: boolean Dimension: UserPermissionsSupportUser (User) Role: Discrete Dimension Remote Column: [Manager].[UserPermissionsSupportUser] Data Type: boolean Dimension: UserPermissionsWorkDotComUserFeature (User) Role: Discrete Dimension Remote Column: [Manager].[UserPermissionsWorkDotComUserFeature] Data Type: boolean Dimension: UserPreferencesActivityRemindersPopup (User) Role: Discrete Dimension Remote Column: [Manager].[UserPreferencesActivityRemindersPopup] Data Type: boolean Dimension: UserPreferencesApexPagesDeveloperMode (User) Role: Discrete Dimension Remote Column: [Manager].[UserPreferencesApexPagesDeveloperMode] Data Type: boolean Dimension: UserPreferencesContentEmailAsAndWhen (User) Role: Discrete Dimension Remote Column: [Manager].[UserPreferencesContentEmailAsAndWhen] Data Type: boolean Dimension: UserPreferencesContentNoEmail (User) Role: Discrete Dimension Remote Column: [Manager].[UserPreferencesContentNoEmail] Data Type: boolean Dimension: UserPreferencesDisCommentAfterLikeEmail (User) Role: Discrete Dimension Remote Column: [Manager].[UserPreferencesDisCommentAfterLikeEmail] Data Type: boolean Dimension: UserPreferencesDisMentionsCommentEmail (User) Role: Discrete Dimension Remote Column: [Manager].[UserPreferencesDisMentionsCommentEmail] Data Type: boolean Dimension: UserPreferencesDisProfPostCommentEmail (User) Role: Discrete Dimension Remote Column: [Manager].[UserPreferencesDisProfPostCommentEmail] Data Type: boolean Dimension: UserPreferencesDisableAllFeedsEmail (User) Role: Discrete Dimension Remote Column: [Manager].[UserPreferencesDisableAllFeedsEmail] Data Type: boolean Dimension: UserPreferencesDisableBookmarkEmail (User) Role: Discrete Dimension Remote Column: [Manager].[UserPreferencesDisableBookmarkEmail] Data Type: boolean Dimension: UserPreferencesDisableChangeCommentEmail (User) Role: Discrete Dimension Remote Column: [Manager].[UserPreferencesDisableChangeCommentEmail] Data Type: boolean Dimension: UserPreferencesDisableEndorsementEmail (User) Role: Discrete Dimension Remote Column: [Manager].[UserPreferencesDisableEndorsementEmail] Data Type: boolean Dimension: UserPreferencesDisableFeedbackEmail (User) Role: Discrete Dimension Remote Column: [Manager].[UserPreferencesDisableFeedbackEmail] Data Type: boolean Dimension: UserPreferencesDisableFileShareNotificationsForApi (User) Role: Discrete Dimension Remote Column: [Manager].[UserPreferencesDisableFileShareNotificationsForApi] Data Type: boolean Dimension: UserPreferencesDisableFollowersEmail (User) Role: Discrete Dimension Remote Column: [Manager].[UserPreferencesDisableFollowersEmail] Data Type: boolean Dimension: UserPreferencesDisableLaterCommentEmail (User) Role: Discrete Dimension Remote Column: [Manager].[UserPreferencesDisableLaterCommentEmail] Data Type: boolean Dimension: UserPreferencesDisableLikeEmail (User) Role: Discrete Dimension Remote Column: [Manager].[UserPreferencesDisableLikeEmail] Data Type: boolean Dimension: UserPreferencesDisableMentionsPostEmail (User) Role: Discrete Dimension Remote Column: [Manager].[UserPreferencesDisableMentionsPostEmail] Data Type: boolean Dimension: UserPreferencesDisableMessageEmail (User) Role: Discrete Dimension Remote Column: [Manager].[UserPreferencesDisableMessageEmail] Data Type: boolean Dimension: UserPreferencesDisableProfilePostEmail (User) Role: Discrete Dimension Remote Column: [Manager].[UserPreferencesDisableProfilePostEmail] Data Type: boolean Dimension: UserPreferencesDisableSharePostEmail (User) Role: Discrete Dimension Remote Column: [Manager].[UserPreferencesDisableSharePostEmail] Data Type: boolean Dimension: UserPreferencesDisableWorkEmail (User) Role: Discrete Dimension Remote Column: [Manager].[UserPreferencesDisableWorkEmail] Data Type: boolean Dimension: UserPreferencesEnableAutoSubForFeeds (User) Role: Discrete Dimension Remote Column: [Manager].[UserPreferencesEnableAutoSubForFeeds] Data Type: boolean Dimension: UserPreferencesEventRemindersCheckboxDefault (User) Role: Discrete Dimension Remote Column: [Manager].[UserPreferencesEventRemindersCheckboxDefault] Data Type: boolean Dimension: UserPreferencesHideCSNDesktopTask (User) Role: Discrete Dimension Remote Column: [Manager].[UserPreferencesHideCSNDesktopTask] Data Type: boolean Dimension: UserPreferencesHideCSNGetChatterMobileTask (User) Role: Discrete Dimension Remote Column: [Manager].[UserPreferencesHideCSNGetChatterMobileTask] Data Type: boolean Dimension: UserPreferencesHideChatterOnboardingSplash (User) Role: Discrete Dimension Remote Column: [Manager].[UserPreferencesHideChatterOnboardingSplash] Data Type: boolean Dimension: UserPreferencesHideS1BrowserUI (User) Role: Discrete Dimension Remote Column: [Manager].[UserPreferencesHideS1BrowserUI] Data Type: boolean Dimension: UserPreferencesHideSecondChatterOnboardingSplash (User) Role: Discrete Dimension Remote Column: [Manager].[UserPreferencesHideSecondChatterOnboardingSplash] Data Type: boolean Dimension: UserPreferencesJigsawListUser (User) Role: Discrete Dimension Remote Column: [Manager].[UserPreferencesJigsawListUser] Data Type: boolean Dimension: UserPreferencesLightningExperiencePreferred (User) Role: Discrete Dimension Remote Column: [Manager].[UserPreferencesLightningExperiencePreferred] Data Type: boolean Dimension: UserPreferencesReminderSoundOff (User) Role: Discrete Dimension Remote Column: [Manager].[UserPreferencesReminderSoundOff] Data Type: boolean Dimension: UserPreferencesShowCityToExternalUsers (User) Role: Discrete Dimension Remote Column: [Manager].[UserPreferencesShowCityToExternalUsers] Data Type: boolean Dimension: UserPreferencesShowCityToGuestUsers (User) Role: Discrete Dimension Remote Column: [Manager].[UserPreferencesShowCityToGuestUsers] Data Type: boolean Dimension: UserPreferencesShowCountryToExternalUsers (User) Role: Discrete Dimension Remote Column: [Manager].[UserPreferencesShowCountryToExternalUsers] Data Type: boolean Dimension: UserPreferencesShowCountryToGuestUsers (User) Role: Discrete Dimension Remote Column: [Manager].[UserPreferencesShowCountryToGuestUsers] Data Type: boolean Dimension: UserPreferencesShowEmailToExternalUsers (User) Role: Discrete Dimension Remote Column: [Manager].[UserPreferencesShowEmailToExternalUsers] Data Type: boolean Dimension: UserPreferencesShowFaxToExternalUsers (User) Role: Discrete Dimension Remote Column: [Manager].[UserPreferencesShowFaxToExternalUsers] Data Type: boolean Dimension: UserPreferencesShowManagerToExternalUsers (User) Role: Discrete Dimension Remote Column: [Manager].[UserPreferencesShowManagerToExternalUsers] Data Type: boolean Dimension: UserPreferencesShowMobilePhoneToExternalUsers (User) Role: Discrete Dimension Remote Column: [Manager].[UserPreferencesShowMobilePhoneToExternalUsers] Data Type: boolean Dimension: UserPreferencesShowPostalCodeToExternalUsers (User) Role: Discrete Dimension Remote Column: [Manager].[UserPreferencesShowPostalCodeToExternalUsers] Data Type: boolean Dimension: UserPreferencesShowPostalCodeToGuestUsers (User) Role: Discrete Dimension Remote Column: [Manager].[UserPreferencesShowPostalCodeToGuestUsers] Data Type: boolean Dimension: UserPreferencesShowProfilePicToGuestUsers (User) Role: Discrete Dimension Remote Column: [Manager].[UserPreferencesShowProfilePicToGuestUsers] Data Type: boolean Dimension: UserPreferencesShowStateToExternalUsers (User) Role: Discrete Dimension Remote Column: [Manager].[UserPreferencesShowStateToExternalUsers] Data Type: boolean Dimension: UserPreferencesShowStateToGuestUsers (User) Role: Discrete Dimension Remote Column: [Manager].[UserPreferencesShowStateToGuestUsers] Data Type: boolean Dimension: UserPreferencesShowStreetAddressToExternalUsers (User) Role: Discrete Dimension Remote Column: [Manager].[UserPreferencesShowStreetAddressToExternalUsers] Data Type: boolean Dimension: UserPreferencesShowTitleToExternalUsers (User) Role: Discrete Dimension Remote Column: [Manager].[UserPreferencesShowTitleToExternalUsers] Data Type: boolean Dimension: UserPreferencesShowTitleToGuestUsers (User) Role: Discrete Dimension Remote Column: [Manager].[UserPreferencesShowTitleToGuestUsers] Data Type: boolean Dimension: UserPreferencesShowWorkPhoneToExternalUsers (User) Role: Discrete Dimension Remote Column: [Manager].[UserPreferencesShowWorkPhoneToExternalUsers] Data Type: boolean Dimension: UserPreferencesSortFeedByComment (User) Role: Discrete Dimension Remote Column: [Manager].[UserPreferencesSortFeedByComment] Data Type: boolean Dimension: UserPreferencesTaskRemindersCheckboxDefault (User) Role: Discrete Dimension Remote Column: [Manager].[UserPreferencesTaskRemindersCheckboxDefault] Data Type: boolean Dimension: UserRoleId (User) Role: Discrete Dimension Remote Column: [Manager].[UserRoleId] Data Type: string Dimension: UserType (User) Role: Discrete Dimension Remote Column: [Manager].[UserType] Data Type: string Dimension: Username (User) Role: Discrete Dimension Remote Column: [Manager].[Username] Data Type: string Opportunities Dimension: AccountId (Opportunities) Role: Discrete Dimension Remote Column: [Opportunities].[AccountId] Data Type: string Dimension: Campaign ID Role: Discrete Dimension Remote Column: [Opportunities].[CampaignId] Data Type: string Dimension: Close Date Role: Discrete Dimension Remote Column: [Opportunities].[CloseDate] Data Type: date Dimension: CreatedById (Opportunities) Role: Discrete Dimension Remote Column: [Opportunities].[CreatedById] Data Type: string Dimension: CreatedDate (Opportunities) Role: Discrete Dimension Remote Column: [Opportunities].[CreatedDate] Data Type: datetime Dimension: Current Generator(s) Role: Discrete Dimension Remote Column: [Opportunities].[CurrentGenerators__c] Data Type: string Dimension: Delivery/Installation Status Role: Discrete Dimension Remote Column: [Opportunities].[DeliveryInstallationStatus__c] Data Type: string Dimension: Fiscal Period Role: Discrete Dimension Remote Column: [Opportunities].[Fiscal] Data Type: string Dimension: Fiscal Quarter Role: Continous Dimension Remote Column: [Opportunities].[FiscalQuarter] Data Type: integer Dimension: Fiscal Year Role: Continous Dimension Remote Column: [Opportunities].[FiscalYear] Data Type: integer Dimension: Forecast Category1 Role: Discrete Dimension Remote Column: [Opportunities].[ForecastCategoryName] Data Type: string Dimension: Forecast Category Role: Discrete Dimension Remote Column: [Opportunities].[ForecastCategory] Data Type: string Dimension: Has Line Item Role: Discrete Dimension Remote Column: [Opportunities].[HasOpportunityLineItem] Data Type: boolean Dimension: IsDeleted (Opportunities) Role: Discrete Dimension Remote Column: [Opportunities].[IsDeleted] Data Type: boolean Dimension: Last Referenced Date Role: Discrete Dimension Remote Column: [Opportunities].[LastReferencedDate] Data Type: datetime Dimension: Last Viewed Date Role: Discrete Dimension Remote Column: [Opportunities].[LastViewedDate] Data Type: datetime Dimension: LastActivityDate (Opportunities) Role: Discrete Dimension Remote Column: [Opportunities].[LastActivityDate] Data Type: date Dimension: LastModifiedById (Opportunities) Role: Discrete Dimension Remote Column: [Opportunities].[LastModifiedById] Data Type: string Dimension: LastModifiedDate (Opportunities) Role: Discrete Dimension Remote Column: [Opportunities].[LastModifiedDate] Data Type: datetime Dimension: Lead Source Role: Discrete Dimension Remote Column: [Opportunities].[LeadSource] Data Type: string Dimension: Main Competitor(s) Role: Discrete Dimension Remote Column: [Opportunities].[MainCompetitors__c] Data Type: string Dimension: Name (Opportunities) Role: Discrete Dimension Remote Column: [Opportunities].[Name] Data Type: string Dimension: Next Step Role: Discrete Dimension Remote Column: [Opportunities].[NextStep] Data Type: string Dimension: Opportunity Type Role: Discrete Dimension Remote Column: [Opportunities].[Type] Data Type: string Dimension: Order Number Role: Discrete Dimension Remote Column: [Opportunities].[OrderNumber__c] Data Type: string Dimension: OwnerId (Opportunities) Role: Discrete Dimension Remote Column: [Opportunities].[OwnerId] Data Type: string Dimension: Price Book ID Role: Discrete Dimension Remote Column: [Opportunities].[Pricebook2Id] Data Type: string Dimension: Private Role: Discrete Dimension Remote Column: [Opportunities].[IsPrivate] Data Type: boolean Dimension: Stage Role: Discrete Dimension Remote Column: [Opportunities].[StageName] Data Type: string Dimension: SystemModstamp (Opportunities) Role: Discrete Dimension Remote Column: [Opportunities].[SystemModstamp] Data Type: datetime Dimension: Tracking Number Role: Discrete Dimension Remote Column: [Opportunities].[TrackingNumber__c] Data Type: string OpportunityLineItem Dimension: CreatedById (Opportunity Product) Role: Discrete Dimension Remote Column: [OpportunityLineItem].[CreatedById] Data Type: string Dimension: CreatedDate (Opportunity Product) Role: Discrete Dimension Remote Column: [OpportunityLineItem].[CreatedDate] Data Type: datetime Dimension: Date Role: Discrete Dimension Remote Column: [OpportunityLineItem].[ServiceDate] Data Type: date Dimension: IsDeleted (Opportunity Product) Role: Discrete Dimension Remote Column: [OpportunityLineItem].[IsDeleted] Data Type: boolean Dimension: LastModifiedById (Opportunity Product) Role: Discrete Dimension Remote Column: [OpportunityLineItem].[LastModifiedById] Data Type: string Dimension: LastModifiedDate (Opportunity Product) Role: Discrete Dimension Remote Column: [OpportunityLineItem].[LastModifiedDate] Data Type: datetime Dimension: Line Description Role: Discrete Dimension Remote Column: [OpportunityLineItem].[Description] Data Type: string Dimension: Opportunity Product Name Role: Discrete Dimension Remote Column: [OpportunityLineItem].[Name] Data Type: string Dimension: OpportunityId (Opportunity Product) Role: Discrete Dimension Remote Column: [OpportunityLineItem].[OpportunityId] Data Type: string Dimension: Price Book Entry ID Role: Discrete Dimension Remote Column: [OpportunityLineItem].[PricebookEntryId] Data Type: string Dimension: Product Code Role: Discrete Dimension Remote Column: [OpportunityLineItem].[ProductCode] Data Type: string Dimension: Product ID Role: Discrete Dimension Remote Column: [OpportunityLineItem].[Product2Id] Data Type: string Dimension: SystemModstamp (Opportunity Product) Role: Discrete Dimension Remote Column: [OpportunityLineItem].[SystemModstamp] Data Type: datetime Owned By Dimension: About Me Role: Discrete Dimension Remote Column: [Owned By].[AboutMe] Data Type: string Dimension: Account ID Role: Discrete Dimension Remote Column: [Owned By].[AccountId] Data Type: string Dimension: Active Role: Discrete Dimension Remote Column: [Owned By].[IsActive] Data Type: boolean Dimension: Activity Reminders Popup Role: Discrete Dimension Remote Column: [Owned By].[UserPreferencesActivityRemindersPopup] Data Type: boolean Dimension: Admin Info Emails Role: Discrete Dimension Remote Column: [Owned By].[ReceivesAdminInfoEmails] Data Type: boolean Dimension: Alias Role: Discrete Dimension Remote Column: [Owned By].[Alias] Data Type: string Dimension: Allow Forecasting Role: Discrete Dimension Remote Column: [Owned By].[ForecastEnabled] Data Type: boolean Dimension: Apex Mobile User Role: Discrete Dimension Remote Column: [Owned By].[UserPermissionsMobileUser] Data Type: boolean Dimension: Apex Pages Developer Mode Role: Discrete Dimension Remote Column: [Owned By].[UserPreferencesApexPagesDeveloperMode] Data Type: boolean Dimension: Auto-login To Call Center Role: Discrete Dimension Remote Column: [Owned By].[UserPermissionsCallCenterAutoLogin] Data Type: boolean Dimension: AutoBccStayInTouch Role: Discrete Dimension Remote Column: [Owned By].[EmailPreferencesAutoBccStayInTouch] Data Type: boolean Dimension: AutoBcc Role: Discrete Dimension Remote Column: [Owned By].[EmailPreferencesAutoBcc] Data Type: boolean Dimension: Call Center ID Role: Discrete Dimension Remote Column: [Owned By].[CallCenterId] Data Type: string Dimension: Cell Role: Discrete Dimension Remote Column: [Owned By].[MobilePhone] Data Type: string Dimension: Chatter Email Highlights Frequency Role: Discrete Dimension Remote Column: [Owned By].[DigestFrequency] Data Type: string Dimension: City Role: Discrete Dimension Remote Column: [Owned By].[City] Data Type: string Dimension: Company Name Role: Discrete Dimension Remote Column: [Owned By].[CompanyName] Data Type: string Dimension: Contact ID Role: Discrete Dimension Remote Column: [Owned By].[ContactId] Data Type: string Dimension: Content Email As And When Role: Discrete Dimension Remote Column: [Owned By].[UserPreferencesContentEmailAsAndWhen] Data Type: boolean Dimension: Content No Email Role: Discrete Dimension Remote Column: [Owned By].[UserPreferencesContentNoEmail] Data Type: boolean Dimension: Country Role: Discrete Dimension Remote Column: [Owned By].[Country] Data Type: string Dimension: Created By ID Role: Discrete Dimension Remote Column: [Owned By].[CreatedById] Data Type: string Dimension: Created Date Role: Discrete Dimension Remote Column: [Owned By].[CreatedDate] Data Type: datetime Dimension: Data.com User Role: Discrete Dimension Remote Column: [Owned By].[UserPermissionsJigsawProspectingUser] Data Type: boolean Dimension: Default Notification Frequency when Joining Groups Role: Discrete Dimension Remote Column: [Owned By].[DefaultGroupNotificationFrequency] Data Type: string Dimension: Delegated Approver ID Role: Discrete Dimension Remote Column: [Owned By].[DelegatedApproverId] Data Type: string Dimension: Department Role: Discrete Dimension Remote Column: [Owned By].[Department] Data Type: string Dimension: Dis Comment After Like Email Role: Discrete Dimension Remote Column: [Owned By].[UserPreferencesDisCommentAfterLikeEmail] Data Type: boolean Dimension: Dis Mentions Comment Email Role: Discrete Dimension Remote Column: [Owned By].[UserPreferencesDisMentionsCommentEmail] Data Type: boolean Dimension: Dis Prof Post Comment Email Role: Discrete Dimension Remote Column: [Owned By].[UserPreferencesDisProfPostCommentEmail] Data Type: boolean Dimension: Disable All Feeds Email Role: Discrete Dimension Remote Column: [Owned By].[UserPreferencesDisableAllFeedsEmail] Data Type: boolean Dimension: Disable Bookmark Email Role: Discrete Dimension Remote Column: [Owned By].[UserPreferencesDisableBookmarkEmail] Data Type: boolean Dimension: Disable Change Comment Email Role: Discrete Dimension Remote Column: [Owned By].[UserPreferencesDisableChangeCommentEmail] Data Type: boolean Dimension: DisableEndorsementEmail Role: Discrete Dimension Remote Column: [Owned By].[UserPreferencesDisableEndorsementEmail] Data Type: boolean Dimension: DisableFeedbackEmail Role: Discrete Dimension Remote Column: [Owned By].[UserPreferencesDisableFeedbackEmail] Data Type: boolean Dimension: Disable File Share Notifications For Api Role: Discrete Dimension Remote Column: [Owned By].[UserPreferencesDisableFileShareNotificationsForApi] Data Type: boolean Dimension: Disable Followers Email Role: Discrete Dimension Remote Column: [Owned By].[UserPreferencesDisableFollowersEmail] Data Type: boolean Dimension: Disable Later Comment Email Role: Discrete Dimension Remote Column: [Owned By].[UserPreferencesDisableLaterCommentEmail] Data Type: boolean Dimension: Disable Like Email Role: Discrete Dimension Remote Column: [Owned By].[UserPreferencesDisableLikeEmail] Data Type: boolean Dimension: Disable Mentions Post Email Role: Discrete Dimension Remote Column: [Owned By].[UserPreferencesDisableMentionsPostEmail] Data Type: boolean Dimension: Disable Message Email Role: Discrete Dimension Remote Column: [Owned By].[UserPreferencesDisableMessageEmail] Data Type: boolean Dimension: Disable Profile Post Email Role: Discrete Dimension Remote Column: [Owned By].[UserPreferencesDisableProfilePostEmail] Data Type: boolean Dimension: Disable Share Post Email Role: Discrete Dimension Remote Column: [Owned By].[UserPreferencesDisableSharePostEmail] Data Type: boolean Dimension: DisableWorkEmail Role: Discrete Dimension Remote Column: [Owned By].[UserPreferencesDisableWorkEmail] Data Type: boolean Dimension: Division Role: Discrete Dimension Remote Column: [Owned By].[Division] Data Type: string Dimension: E-mail Role: Discrete Dimension Remote Column: [Owned By].[Email] Data Type: string Dimension: Email Encoding Role: Discrete Dimension Remote Column: [Owned By].[EmailEncodingKey] Data Type: string Dimension: Email Sender Address Role: Discrete Dimension Remote Column: [Owned By].[SenderEmail] Data Type: string Dimension: Email Sender Name Role: Discrete Dimension Remote Column: [Owned By].[SenderName] Data Type: string Dimension: Email Signature Role: Discrete Dimension Remote Column: [Owned By].[Signature] Data Type: string Dimension: Employee Number Role: Discrete Dimension Remote Column: [Owned By].[EmployeeNumber] Data Type: string Dimension: Enable Auto Sub For Feeds Role: Discrete Dimension Remote Column: [Owned By].[UserPreferencesEnableAutoSubForFeeds] Data Type: boolean Dimension: Event Reminders Checkbox Default Role: Discrete Dimension Remote Column: [Owned By].[UserPreferencesEventRemindersCheckboxDefault] Data Type: boolean Dimension: Extension Role: Discrete Dimension Remote Column: [Owned By].[Extension] Data Type: string Dimension: Fax Role: Discrete Dimension Remote Column: [Owned By].[Fax] Data Type: string Dimension: First Name Role: Discrete Dimension Remote Column: [Owned By].[FirstName] Data Type: string Dimension: Force.com Flow User Role: Discrete Dimension Remote Column: [Owned By].[UserPermissionsInteractionUser] Data Type: boolean Dimension: Hide CSN Desktop Task Role: Discrete Dimension Remote Column: [Owned By].[UserPreferencesHideCSNDesktopTask] Data Type: boolean Dimension: Hide CSN Get Chatter Mobile Task Role: Discrete Dimension Remote Column: [Owned By].[UserPreferencesHideCSNGetChatterMobileTask] Data Type: boolean Dimension: HideChatterOnboardingSplash Role: Discrete Dimension Remote Column: [Owned By].[UserPreferencesHideChatterOnboardingSplash] Data Type: boolean Dimension: HideS1BrowserUI Role: Discrete Dimension Remote Column: [Owned By].[UserPreferencesHideS1BrowserUI] Data Type: boolean Dimension: HideSecondChatterOnboardingSplash Role: Discrete Dimension Remote Column: [Owned By].[UserPreferencesHideSecondChatterOnboardingSplash] Data Type: boolean Dimension: Info Emails Role: Discrete Dimension Remote Column: [Owned By].[ReceivesInfoEmails] Data Type: boolean Dimension: JigsawListUser Role: Discrete Dimension Remote Column: [Owned By].[UserPreferencesJigsawListUser] Data Type: boolean Dimension: Knowledge User Role: Discrete Dimension Remote Column: [Owned By].[UserPermissionsKnowledgeUser] Data Type: boolean Dimension: Language Role: Discrete Dimension Remote Column: [Owned By].[LanguageLocaleKey] Data Type: string Dimension: Last Login Role: Discrete Dimension Remote Column: [Owned By].[LastLoginDate] Data Type: datetime Dimension: Last Modified By ID Role: Discrete Dimension Remote Column: [Owned By].[LastModifiedById] Data Type: string Dimension: Last Modified Date Role: Discrete Dimension Remote Column: [Owned By].[LastModifiedDate] Data Type: datetime Dimension: Last Name Role: Discrete Dimension Remote Column: [Owned By].[LastName] Data Type: string Dimension: Last Password Change or Reset Role: Discrete Dimension Remote Column: [Owned By].[LastPasswordChangeDate] Data Type: datetime Dimension: LastReferencedDate (Owned By) Role: Discrete Dimension Remote Column: [Owned By].[LastReferencedDate] Data Type: datetime Dimension: LastViewedDate (Owned By) Role: Discrete Dimension Remote Column: [Owned By].[LastViewedDate] Data Type: datetime Dimension: LightningExperiencePreferred Role: Discrete Dimension Remote Column: [Owned By].[UserPreferencesLightningExperiencePreferred] Data Type: boolean Dimension: Locale Role: Discrete Dimension Remote Column: [Owned By].[LocaleSidKey] Data Type: string Dimension: Manager ID Role: Discrete Dimension Remote Column: [Owned By].[ManagerId] Data Type: string Dimension: Marketing User Role: Discrete Dimension Remote Column: [Owned By].[UserPermissionsMarketingUser] Data Type: boolean Dimension: Nickname Role: Discrete Dimension Remote Column: [Owned By].[CommunityNickname] Data Type: string Dimension: Offline Edition Trial Expiration Date Role: Discrete Dimension Remote Column: [Owned By].[OfflineTrialExpirationDate] Data Type: datetime Dimension: Offline User Role: Discrete Dimension Remote Column: [Owned By].[UserPermissionsOfflineUser] Data Type: boolean Dimension: Phone Role: Discrete Dimension Remote Column: [Owned By].[Phone] Data Type: string Dimension: Profile ID Role: Discrete Dimension Remote Column: [Owned By].[ProfileId] Data Type: string Dimension: Reminder Sound Off Role: Discrete Dimension Remote Column: [Owned By].[UserPreferencesReminderSoundOff] Data Type: boolean Dimension: Role ID Role: Discrete Dimension Remote Column: [Owned By].[UserRoleId] Data Type: string Dimension: SAML Federation ID Role: Discrete Dimension Remote Column: [Owned By].[FederationIdentifier] Data Type: string Dimension: Sales Anywhere Trial Expiration Date Role: Discrete Dimension Remote Column: [Owned By].[OfflinePdaTrialExpirationDate] Data Type: datetime Dimension: Salesforce CRM Content User Role: Discrete Dimension Remote Column: [Owned By].[UserPermissionsSFContentUser] Data Type: boolean Dimension: Service Cloud User Role: Discrete Dimension Remote Column: [Owned By].[UserPermissionsSupportUser] Data Type: boolean Dimension: ShowCityToExternalUsers Role: Discrete Dimension Remote Column: [Owned By].[UserPreferencesShowCityToExternalUsers] Data Type: boolean Dimension: ShowCityToGuestUsers Role: Discrete Dimension Remote Column: [Owned By].[UserPreferencesShowCityToGuestUsers] Data Type: boolean Dimension: ShowCountryToExternalUsers Role: Discrete Dimension Remote Column: [Owned By].[UserPreferencesShowCountryToExternalUsers] Data Type: boolean Dimension: ShowCountryToGuestUsers Role: Discrete Dimension Remote Column: [Owned By].[UserPreferencesShowCountryToGuestUsers] Data Type: boolean Dimension: ShowEmailToExternalUsers Role: Discrete Dimension Remote Column: [Owned By].[UserPreferencesShowEmailToExternalUsers] Data Type: boolean Dimension: ShowFaxToExternalUsers Role: Discrete Dimension Remote Column: [Owned By].[UserPreferencesShowFaxToExternalUsers] Data Type: boolean Dimension: ShowManagerToExternalUsers Role: Discrete Dimension Remote Column: [Owned By].[UserPreferencesShowManagerToExternalUsers] Data Type: boolean Dimension: ShowMobilePhoneToExternalUsers Role: Discrete Dimension Remote Column: [Owned By].[UserPreferencesShowMobilePhoneToExternalUsers] Data Type: boolean Dimension: ShowPostalCodeToExternalUsers Role: Discrete Dimension Remote Column: [Owned By].[UserPreferencesShowPostalCodeToExternalUsers] Data Type: boolean Dimension: ShowPostalCodeToGuestUsers Role: Discrete Dimension Remote Column: [Owned By].[UserPreferencesShowPostalCodeToGuestUsers] Data Type: boolean Dimension: ShowProfilePicToGuestUsers Role: Discrete Dimension Remote Column: [Owned By].[UserPreferencesShowProfilePicToGuestUsers] Data Type: boolean Dimension: ShowStateToExternalUsers Role: Discrete Dimension Remote Column: [Owned By].[UserPreferencesShowStateToExternalUsers] Data Type: boolean Dimension: ShowStateToGuestUsers Role: Discrete Dimension Remote Column: [Owned By].[UserPreferencesShowStateToGuestUsers] Data Type: boolean Dimension: ShowStreetAddressToExternalUsers Role: Discrete Dimension Remote Column: [Owned By].[UserPreferencesShowStreetAddressToExternalUsers] Data Type: boolean Dimension: ShowTitleToExternalUsers Role: Discrete Dimension Remote Column: [Owned By].[UserPreferencesShowTitleToExternalUsers] Data Type: boolean Dimension: ShowTitleToGuestUsers Role: Discrete Dimension Remote Column: [Owned By].[UserPreferencesShowTitleToGuestUsers] Data Type: boolean Dimension: ShowWorkPhoneToExternalUsers Role: Discrete Dimension Remote Column: [Owned By].[UserPreferencesShowWorkPhoneToExternalUsers] Data Type: boolean Dimension: Site.com Contributor User Role: Discrete Dimension Remote Column: [Owned By].[UserPermissionsSiteforceContributorUser] Data Type: boolean Dimension: Site.com Publisher User Role: Discrete Dimension Remote Column: [Owned By].[UserPermissionsSiteforcePublisherUser] Data Type: boolean Dimension: SortFeedByComment Role: Discrete Dimension Remote Column: [Owned By].[UserPreferencesSortFeedByComment] Data Type: boolean Dimension: State/Province Role: Discrete Dimension Remote Column: [Owned By].[State] Data Type: string Dimension: Stay-in-Touch Email Note Role: Discrete Dimension Remote Column: [Owned By].[StayInTouchNote] Data Type: string Dimension: Stay-in-Touch Email Signature Role: Discrete Dimension Remote Column: [Owned By].[StayInTouchSignature] Data Type: string Dimension: Stay-in-Touch Email Subject Role: Discrete Dimension Remote Column: [Owned By].[StayInTouchSubject] Data Type: string Dimension: StayInTouchReminder Role: Discrete Dimension Remote Column: [Owned By].[EmailPreferencesStayInTouchReminder] Data Type: boolean Dimension: Street Role: Discrete Dimension Remote Column: [Owned By].[Street] Data Type: string Dimension: System Modstamp Role: Discrete Dimension Remote Column: [Owned By].[SystemModstamp] Data Type: datetime Dimension: Task Reminders Checkbox Default Role: Discrete Dimension Remote Column: [Owned By].[UserPreferencesTaskRemindersCheckboxDefault] Data Type: boolean Dimension: Time Zone Role: Discrete Dimension Remote Column: [Owned By].[TimeZoneSidKey] Data Type: string Dimension: Title Role: Discrete Dimension Remote Column: [Owned By].[Title] Data Type: string Dimension: Url for Thumbnail sized Photo Role: Discrete Dimension Remote Column: [Owned By].[SmallPhotoUrl] Data Type: string Dimension: Url for full-sized Photo Role: Discrete Dimension Remote Column: [Owned By].[FullPhotoUrl] Data Type: string Dimension: User Photo has a badge overlay Role: Discrete Dimension Remote Column: [Owned By].[IsBadged] Data Type: boolean Dimension: User Type Role: Discrete Dimension Remote Column: [Owned By].[UserType] Data Type: string Dimension: Username Role: Discrete Dimension Remote Column: [Owned By].[Username] Data Type: string Dimension: Work.com User Role: Discrete Dimension Remote Column: [Owned By].[UserPermissionsWorkDotComUserFeature] Data Type: boolean Dimension: Zip/Postal Code Role: Discrete Dimension Remote Column: [Owned By].[PostalCode] Data Type: string PricebookEntry Dimension: CreatedById (Price Book Entry) Role: Discrete Dimension Remote Column: [PricebookEntry].[CreatedById] Data Type: string Dimension: CreatedDate (Price Book Entry) Role: Discrete Dimension Remote Column: [PricebookEntry].[CreatedDate] Data Type: datetime Dimension: IsActive (Price Book Entry) Role: Discrete Dimension Remote Column: [PricebookEntry].[IsActive] Data Type: boolean Dimension: IsDeleted (Price Book Entry) Role: Discrete Dimension Remote Column: [PricebookEntry].[IsDeleted] Data Type: boolean Dimension: LastModifiedById (Price Book Entry) Role: Discrete Dimension Remote Column: [PricebookEntry].[LastModifiedById] Data Type: string Dimension: LastModifiedDate (Price Book Entry) Role: Discrete Dimension Remote Column: [PricebookEntry].[LastModifiedDate] Data Type: datetime Dimension: Pricebook2Id (Price Book Entry) Role: Discrete Dimension Remote Column: [PricebookEntry].[Pricebook2Id] Data Type: string Dimension: Product Name Role: Discrete Dimension Remote Column: [PricebookEntry].[Name] Data Type: string Dimension: Product2Id (Price Book Entry) Role: Discrete Dimension Remote Column: [PricebookEntry].[Product2Id] Data Type: string Dimension: ProductCode (Price Book Entry) Role: Discrete Dimension Remote Column: [PricebookEntry].[ProductCode] Data Type: string Dimension: SystemModstamp (Price Book Entry) Role: Discrete Dimension Remote Column: [PricebookEntry].[SystemModstamp] Data Type: datetime Dimension: Use Standard Price Role: Discrete Dimension Remote Column: [PricebookEntry].[UseStandardPrice] Data Type: boolean Product2 Dimension: CreatedById (Product) Role: Discrete Dimension Remote Column: [Product2].[CreatedById] Data Type: string Dimension: CreatedDate (Product) Role: Discrete Dimension Remote Column: [Product2].[CreatedDate] Data Type: datetime Dimension: IsActive (Product) Role: Discrete Dimension Remote Column: [Product2].[IsActive] Data Type: boolean Dimension: IsDeleted (Product) Role: Discrete Dimension Remote Column: [Product2].[IsDeleted] Data Type: boolean Dimension: LastModifiedById (Product) Role: Discrete Dimension Remote Column: [Product2].[LastModifiedById] Data Type: string Dimension: LastModifiedDate (Product) Role: Discrete Dimension Remote Column: [Product2].[LastModifiedDate] Data Type: datetime Dimension: LastReferencedDate (Product) Role: Discrete Dimension Remote Column: [Product2].[LastReferencedDate] Data Type: datetime Dimension: LastViewedDate (Product) Role: Discrete Dimension Remote Column: [Product2].[LastViewedDate] Data Type: datetime Dimension: Product Description Role: Discrete Dimension Remote Column: [Product2].[Description] Data Type: string Dimension: Product Family Role: Discrete Dimension Remote Column: [Product2].[Family] Data Type: string Dimension: ProductCode (Product) Role: Discrete Dimension Remote Column: [Product2].[ProductCode] Data Type: string Dimension: SystemModstamp (Product) Role: Discrete Dimension Remote Column: [Product2].[SystemModstamp] Data Type: datetime Calculated/Other Dimension: Measure Names Role: Discrete Dimension Data Type: string Dimension: Status Role: Discrete Dimension Data Type: string Formula: if [Closed]=False then "Open" else "Closed" end Dimension: Group Opportunities Role: Discrete Dimension Data Type: string Formula: //It is an If Statement //It groups the opportunities into win, loss and active IF [Closed]=TRUE AND [Won]=TRUE THEN "Win" ELSEIF [Closed]=TRUE AND [Won]=FALSE THEN "Loss" ELSE "Active" END Dimension: NCS_TestData__Populated__c (Account) Role: Discrete Dimension Data Type: boolean Dimension: Populate Account Role: Discrete Dimension Data Type: string Dimension: Populate Name Role: Discrete Dimension Data Type: string Dimension: Populated Role: Discrete Dimension Data Type: boolean Measure Account Measure: Annual Revenue Role: Continous Measure Remote Column: [Account].[AnnualRevenue] Data Type: real Measure: Billing Latitude Role: Continous Measure Remote Column: [Account].[BillingLatitude] Data Type: real Aggregation: Avg Measure: Billing Longitude Role: Continous Measure Remote Column: [Account].[BillingLongitude] Data Type: real Aggregation: Avg Measure: Employees Role: Continous Measure Remote Column: [Account].[NumberOfEmployees] Data Type: integer Measure: Number of Locations Role: Continous Measure Remote Column: [Account].[NumberofLocations__c] Data Type: real Measure: Shipping Latitude Role: Continous Measure Remote Column: [Account].[ShippingLatitude] Data Type: real Aggregation: Avg Measure: Shipping Longitude Role: Continous Measure Remote Column: [Account].[ShippingLongitude] Data Type: real Aggregation: Avg Measure: Id (Account) Role: Continous Measure Remote Column: [Account].[Id] Data Type: string Aggregation: Count Manager Measure: JigsawImportLimitOverride (User) Role: Continous Measure Remote Column: [Manager].[JigsawImportLimitOverride] Data Type: integer Measure: Latitude (User) Role: Continous Measure Remote Column: [Manager].[Latitude] Data Type: real Aggregation: Avg Measure: Longitude (User) Role: Continous Measure Remote Column: [Manager].[Longitude] Data Type: real Aggregation: Avg Measure: Id (User) Role: Continous Measure Remote Column: [Manager].[Id] Data Type: string Aggregation: Count Measure: Name (User) Role: Continous Measure Remote Column: [Manager].[Name] Data Type: string Aggregation: Count Opportunities Measure: Amount Role: Continous Measure Remote Column: [Opportunities].[Amount] Data Type: real Measure: Expected Amount Role: Continous Measure Remote Column: [Opportunities].[ExpectedRevenue] Data Type: real Measure: Probability (%) Role: Continous Measure Remote Column: [Opportunities].[Probability] Data Type: real Measure: Quantity Role: Continous Measure Remote Column: [Opportunities].[TotalOpportunityQuantity] Data Type: real Measure: Opportunity ID Role: Continous Measure Remote Column: [Opportunities].[Id] Data Type: string Aggregation: Count Measure: Closed Role: Continous Measure Remote Column: [Opportunities].[IsClosed] Data Type: boolean Aggregation: Count Measure: Won Role: Continous Measure Remote Column: [Opportunities].[IsWon] Data Type: boolean Aggregation: Count OpportunityLineItem Measure: List Price Role: Continous Measure Remote Column: [OpportunityLineItem].[ListPrice] Data Type: real Measure: Quantity (Opportunity Product) Role: Continous Measure Remote Column: [OpportunityLineItem].[Quantity] Data Type: real Measure: Sales Price Role: Continous Measure Remote Column: [OpportunityLineItem].[UnitPrice] Data Type: real Measure: Sort Order Role: Continous Measure Remote Column: [OpportunityLineItem].[SortOrder] Data Type: integer Measure: Total Price Role: Continous Measure Remote Column: [OpportunityLineItem].[TotalPrice] Data Type: real Measure: Line Item ID Role: Continous Measure Remote Column: [OpportunityLineItem].[Id] Data Type: string Aggregation: Count Owned By Measure: Data.com Monthly Addition Limit Role: Continous Measure Remote Column: [Owned By].[JigsawImportLimitOverride] Data Type: integer Measure: Latitude Role: Continous Measure Remote Column: [Owned By].[Latitude] Data Type: real Aggregation: Avg Measure: Longitude Role: Continous Measure Remote Column: [Owned By].[Longitude] Data Type: real Aggregation: Avg Measure: User ID Role: Continous Measure Remote Column: [Owned By].[Id] Data Type: string Aggregation: Count Measure: Full Name Role: Continous Measure Remote Column: [Owned By].[Name] Data Type: string Aggregation: Count PricebookEntry Measure: UnitPrice (Price Book Entry) Role: Continous Measure Remote Column: [PricebookEntry].[UnitPrice] Data Type: real Measure: Id (Price Book Entry) Role: Continous Measure Remote Column: [PricebookEntry].[Id] Data Type: string Aggregation: Count Product2 Measure: Id (Product) Role: Continous Measure Remote Column: [Product2].[Id] Data Type: string Aggregation: Count Measure: Name (Product) Role: Continous Measure Remote Column: [Product2].[Name] Data Type: string Aggregation: Count Calculated/Other Measure: Active Opportunities Role: Continous Measure Data Type: integer Formula: // This is an If Statement //It shows "1" for each one of the active opportunities IF [Closed]=False then 1 else 0 end Measure: Win rate Role: Continous Measure Data Type: real Formula: // This is a calculation // It counts each one of the distinct close/won opportunities and divide them by the total number of opportunities closed ZN([# of Wins] / ZN(COUNTD(IF [Closed]=TRUE THEN [Opportunity ID] END))) Measure: # of Losses Role: Continous Measure Data Type: integer Formula: // This is a calculation combining an If Statement and a Count Distinct function // It shows true and count if an opportunity is closed and lost ZN(COUNTD(IF[Closed]=TRUE AND [Won]=FALSE THEN [Opportunity ID] END)) Measure: AVG Size of Deal Role: Continous Measure Data Type: real Formula: // This is a calculation // It shows the average expected amount for each one of the opportunities SUM([Expected Amount])/COUNTD([Opportunity ID]) Measure: # of Wins Role: Continous Measure Data Type: integer Formula: // This is a calculation combining an If Statement and a Count Distinct function // It shows true and count if an opportunity is won ZN(COUNTD(IF[Closed]=TRUE AND [Won]=TRUE THEN [Opportunity ID] END)) Measure: Show Salesperson Name Role: Discrete Measure Data Type: string Formula: //It is an If Statement // It shows the salesperson name if a salesperson is selected IIF (COUNTD([Name (User)])=1, ATTR([Name (User)])+"'s Team", "All Teams") Measure: Sales Role: Continous Measure Data Type: real Formula: // It is an If Statement // It calculates the sales total // Sales happen when the opportunity is won and closed IIF([Closed]=TRUE AND [Won]=TRUE, [Amount], 0) Measure: Measure Values Role: Continous Measure Data Type: real Measure: Number of Records Role: Continous Measure Data Type: integer Formula: 1 Measure: Loss rate Role: Continous Measure Data Type: real Formula: //Calculate all opportunities close/lost against all opportunities closed [# of Wins (copy)]/ ZN(COUNTD(IF [Closed]=TRUE THEN [Opportunity ID] END)) Semantic Values [Country].[Name]: "United States" Dashboards Dashboard: Opportunity Overview Worksheets Worksheet: Show Manager Datasources: Opportunities (Salesforce) Used Dimensions & Measures: [Account Name] [Billing Country] [Close Date] [Forecast Category] [Full Name] [Industry] [Name (Product)] [Name (User)] [Show Salesperson Name] [Stage] Used Remote Columns: [Account].[BillingCountry] [Account].[Industry] [Account].[Name] [Manager].[Name] [Opportunities].[CloseDate] [Opportunities].[ForecastCategory] [Opportunities].[StageName] [Owned By].[Name] [Product2].[Name] Worksheet: Total Opportunities Datasources: Opportunities (Salesforce) Used Dimensions & Measures: [# of Wins] [Active Opportunities] [Amount] [Billing City] [Billing Country] [Close Date] [Closed] [Expected Amount] [Forecast Category] [Full Name] [Industry] [Name (Product)] [Name (User)] [Opportunity ID] [Sales] [Stage] [Win rate] [Won] Used Remote Columns: [Account].[BillingCity] [Account].[BillingCountry] [Account].[Industry] [Manager].[Name] [Opportunities].[Amount] [Opportunities].[CloseDate] [Opportunities].[ExpectedRevenue] [Opportunities].[ForecastCategory] [Opportunities].[Id] [Opportunities].[IsClosed] [Opportunities].[IsWon] [Opportunities].[StageName] [Owned By].[Name] [Product2].[Name] Worksheet: # of Losses Datasources: Opportunities (Salesforce) Used Dimensions & Measures: [# of Losses] [Billing City] [Billing Country] [Close Date] [Closed] [Forecast Category] [Full Name] [Industry] [Loss rate] [Name (Product)] [Name (User)] [Opportunity ID] [Stage] [Won] Used Remote Columns: [Account].[BillingCity] [Account].[BillingCountry] [Account].[Industry] [Manager].[Name] [Opportunities].[CloseDate] [Opportunities].[ForecastCategory] [Opportunities].[Id] [Opportunities].[IsClosed] [Opportunities].[IsWon] [Opportunities].[StageName] [Owned By].[Name] [Product2].[Name] Worksheet: # of Wins Datasources: Opportunities (Salesforce) Used Dimensions & Measures: [# of Wins] [Billing City] [Billing Country] [Close Date] [Closed] [Forecast Category] [Full Name] [Industry] [Name (Product)] [Name (User)] [Opportunity ID] [Stage] [Win rate] [Won] Used Remote Columns: [Account].[BillingCity] [Account].[BillingCountry] [Account].[Industry] [Manager].[Name] [Opportunities].[CloseDate] [Opportunities].[ForecastCategory] [Opportunities].[Id] [Opportunities].[IsClosed] [Opportunities].[IsWon] [Opportunities].[StageName] [Owned By].[Name] [Product2].[Name] Worksheet: Expected Revenue Datasources: Opportunities (Salesforce) Used Dimensions & Measures: [AVG Size of Deal] [Billing City] [Billing Country] [Close Date] [Closed] [Expected Amount] [Forecast Category] [Full Name] [Group Opportunities] [Industry] [Name (Product)] [Name (User)] [Opportunity ID] [Stage] [Won] Used Remote Columns: [Account].[BillingCity] [Account].[BillingCountry] [Account].[Industry] [Manager].[Name] [Opportunities].[CloseDate] [Opportunities].[ExpectedRevenue] [Opportunities].[ForecastCategory] [Opportunities].[Id] [Opportunities].[IsClosed] [Opportunities].[IsWon] [Opportunities].[StageName] [Owned By].[Name] [Product2].[Name] Worksheet: Geographic Distribution Datasources: Opportunities (Salesforce) Used Dimensions & Measures: [Billing City] [Billing Country] [Close Date] [Expected Amount] [Forecast Category] [Full Name] [Industry] [Name (Product)] [Name (User)] [Stage] Used Remote Columns: [Account].[BillingCity] [Account].[BillingCountry] [Account].[Industry] [Manager].[Name] [Opportunities].[CloseDate] [Opportunities].[ExpectedRevenue] [Opportunities].[ForecastCategory] [Opportunities].[StageName] [Owned By].[Name] [Product2].[Name] Worksheet: Industry Size Datasources: Opportunities (Salesforce) Used Dimensions & Measures: [# of Wins] [Billing City] [Billing Country] [Close Date] [Closed] [Forecast Category] [Full Name] [Industry] [Name (Product)] [Name (User)] [Opportunity ID] [Stage] [Win rate] [Won] Used Remote Columns: [Account].[BillingCity] [Account].[BillingCountry] [Account].[Industry] [Manager].[Name] [Opportunities].[CloseDate] [Opportunities].[ForecastCategory] [Opportunities].[Id] [Opportunities].[IsClosed] [Opportunities].[IsWon] [Opportunities].[StageName] [Owned By].[Name] [Product2].[Name] Dashboard Objects: Filter: [Opportunities (Salesforce)].[Close Date] Filter: [Opportunities (Salesforce)].[Full Name] Filter: [Opportunities (Salesforce)].[Billing Country] Filter: [Opportunities (Salesforce)].[Name (Product)] Filter: [Opportunities (Salesforce)].[Industry] Filter: [Opportunities (Salesforce)].[Name (User)] Filter: [Opportunities (Salesforce)].[Stage] Text: Text: Use Options Below to Filter Text: Æ Text: ★ Worksheets Worksheet: # of Losses Visible: No Used Datasources Datasource: Opportunities (Salesforce) Discrete Dimension: Billing City Remote Column: [Account].[BillingCity] Discrete Dimension: Billing Country Remote Column: [Account].[BillingCountry] Discrete Dimension: Close Date Remote Column: [Opportunities].[CloseDate] Discrete Dimension: Closed Remote Column: [Opportunities].[IsClosed] Discrete Dimension: Forecast Category Remote Column: [Opportunities].[ForecastCategory] Discrete Dimension: Full Name Remote Column: [Owned By].[Name] Discrete Dimension: Industry Remote Column: [Account].[Industry] Discrete Dimension: Name (Product) Remote Column: [Product2].[Name] Discrete Dimension: Name (User) Remote Column: [Manager].[Name] Discrete Dimension: Opportunity ID Remote Column: [Opportunities].[Id] Discrete Dimension: Stage Remote Column: [Opportunities].[StageName] Discrete Dimension: Won Remote Column: [Opportunities].[IsWon] Continous Measure: # of Losses Continous Measure: Loss rate Marks Mark: All Type: Text Label: <[Opportunities (Salesforce)].[# of Wins (copy)]> Loss Rate: <[Opportunities (Salesforce)].[Win rate (copy)]> View Filters: [Opportunities (Salesforce)].[Action (Billing City,Billing Country)] [Opportunities (Salesforce)].[Action (Industry)] [Opportunities (Salesforce)].[Action (MY(Close Date),DAY(Close Date),Forecast Category)] [Opportunities (Salesforce)].[Billing Country] [Opportunities (Salesforce)].[Close Date] [Opportunities (Salesforce)].[Full Name] [Opportunities (Salesforce)].[Industry] [Opportunities (Salesforce)].[Name (Product)] [Opportunities (Salesforce)].[Name (User)] [Opportunities (Salesforce)].[Stage] Slices: [Opportunities (Salesforce)].[Close Date] [Opportunities (Salesforce)].[Full Name] [Opportunities (Salesforce)].[Billing Country] [Opportunities (Salesforce)].[Name (Product)] [Opportunities (Salesforce)].[Industry] [Opportunities (Salesforce)].[Name (User)] [Opportunities (Salesforce)].[Stage] [Opportunities (Salesforce)].[Action (Billing City,Billing Country)] [Opportunities (Salesforce)].[Action (Industry)] [Opportunities (Salesforce)].[Action (MY(Close Date),DAY(Close Date),Forecast Category)] Styles Style: table Other background-color: #00000000 Style: table-div rows line-visibility: off cols line-visibility: off Style: title Other background-color: #b81840 Style: quick-filter [Opportunities (Salesforce)].[Full Name] title: Salesperson [Opportunities (Salesforce)].[Name (Product)] title: Product Other font-family: Tableau Book Style: quick-filter-title Other font-family: Tableau Regular font-weight: normal font-size: 8 Worksheet: # of Wins Visible: No Used Datasources Datasource: Opportunities (Salesforce) Discrete Dimension: Billing City Remote Column: [Account].[BillingCity] Discrete Dimension: Billing Country Remote Column: [Account].[BillingCountry] Discrete Dimension: Close Date Remote Column: [Opportunities].[CloseDate] Discrete Dimension: Closed Remote Column: [Opportunities].[IsClosed] Discrete Dimension: Forecast Category Remote Column: [Opportunities].[ForecastCategory] Discrete Dimension: Full Name Remote Column: [Owned By].[Name] Discrete Dimension: Industry Remote Column: [Account].[Industry] Discrete Dimension: Name (Product) Remote Column: [Product2].[Name] Discrete Dimension: Name (User) Remote Column: [Manager].[Name] Discrete Dimension: Opportunity ID Remote Column: [Opportunities].[Id] Discrete Dimension: Stage Remote Column: [Opportunities].[StageName] Discrete Dimension: Won Remote Column: [Opportunities].[IsWon] Continous Measure: Win rate Continous Measure: # of Wins Marks Mark: All Type: Text Label: <[Opportunities (Salesforce)].[# of Wins]> Win Rate: <[Opportunities (Salesforce)].[# of Wins (copy 2)]> View Filters: [Opportunities (Salesforce)].[Action (Billing City,Billing Country)] [Opportunities (Salesforce)].[Action (Industry)] [Opportunities (Salesforce)].[Action (MY(Close Date),DAY(Close Date),Forecast Category)] [Opportunities (Salesforce)].[Billing Country] [Opportunities (Salesforce)].[Close Date] [Opportunities (Salesforce)].[Full Name] [Opportunities (Salesforce)].[Industry] [Opportunities (Salesforce)].[Name (Product)] [Opportunities (Salesforce)].[Name (User)] [Opportunities (Salesforce)].[Stage] Slices: [Opportunities (Salesforce)].[Close Date] [Opportunities (Salesforce)].[Full Name] [Opportunities (Salesforce)].[Billing Country] [Opportunities (Salesforce)].[Name (Product)] [Opportunities (Salesforce)].[Industry] [Opportunities (Salesforce)].[Name (User)] [Opportunities (Salesforce)].[Stage] [Opportunities (Salesforce)].[Action (Industry)] [Opportunities (Salesforce)].[Action (Billing City,Billing Country)] [Opportunities (Salesforce)].[Action (MY(Close Date),DAY(Close Date),Forecast Category)] Styles Style: cell Other border-width: 5 border-style: none Style: pane Other border-width: 5 border-style: none Style: table Other background-color: #00000000 Style: table-div rows line-visibility: off cols line-visibility: off Style: title Other background-color: #33608c Worksheet: Expected Revenue Visible: No Used Datasources Datasource: Opportunities (Salesforce) Discrete Dimension: Billing City Remote Column: [Account].[BillingCity] Discrete Dimension: Billing Country Remote Column: [Account].[BillingCountry] Discrete Dimension: Group Opportunities Discrete Dimension: Close Date Remote Column: [Opportunities].[CloseDate] Discrete Dimension: Closed Remote Column: [Opportunities].[IsClosed] Discrete Dimension: Forecast Category Remote Column: [Opportunities].[ForecastCategory] Discrete Dimension: Full Name Remote Column: [Owned By].[Name] Discrete Dimension: Industry Remote Column: [Account].[Industry] Discrete Dimension: Name (Product) Remote Column: [Product2].[Name] Discrete Dimension: Name (User) Remote Column: [Manager].[Name] Discrete Dimension: Opportunity ID Remote Column: [Opportunities].[Id] Discrete Dimension: Stage Remote Column: [Opportunities].[StageName] Discrete Dimension: Won Remote Column: [Opportunities].[IsWon] Continous Measure: AVG Size of Deal Continous Measure: Expected Amount Remote Column: [Opportunities].[ExpectedRevenue] Marks Mark: All Type: Bar Tooltip: Week Starting at <[Opportunities (Salesforce)].[DAY(Close Date)]> Opportunities: <[Opportunities (Salesforce)].[Opportunity ID]> Opportunities Details: Mark: [Opportunities (Salesforce)].[SUM(Expected Amount)] Type: Bar Tooltip: Week Starting at <[Opportunities (Salesforce)].[DAY(Close Date)]> Opportunities: <[Opportunities (Salesforce)].[Opportunity ID]> Opportunities Details: Mark: [Opportunities (Salesforce)].[Opportunity ID] Type: Bar Tooltip: Week Starting at <[Opportunities (Salesforce)].[DAY(Close Date)]> Opportunities: <[Opportunities (Salesforce)].[Opportunity ID]> Opportunities Details: View Rows: [Opportunities (Salesforce)].[SUM(Expected Amount)] [Opportunities (Salesforce)].[Opportunity ID] Columns: [Opportunities (Salesforce)].[MY(Close Date)] [Opportunities (Salesforce)].[DAY(Close Date)] Filters: [Opportunities (Salesforce)].[Action (Billing City,Billing Country)] [Opportunities (Salesforce)].[Action (Industry)] [Opportunities (Salesforce)].[Billing Country] [Opportunities (Salesforce)].[Group Opportunities] [Opportunities (Salesforce)].[Close Date] [Opportunities (Salesforce)].[Full Name] [Opportunities (Salesforce)].[Industry] [Opportunities (Salesforce)].[Name (Product)] [Opportunities (Salesforce)].[Name (User)] [Opportunities (Salesforce)].[Stage] [Opportunities (Salesforce)].[DAY(Close Date)] Manual Sorting: [Opportunities (Salesforce)].[Forecast Category] ASC Slices: [Opportunities (Salesforce)].[Close Date] [Opportunities (Salesforce)].[Full Name] [Opportunities (Salesforce)].[DAY(Close Date)] [Opportunities (Salesforce)].[Group Opportunities] [Opportunities (Salesforce)].[Billing Country] [Opportunities (Salesforce)].[Name (Product)] [Opportunities (Salesforce)].[Industry] [Opportunities (Salesforce)].[Name (User)] [Opportunities (Salesforce)].[Stage] [Opportunities (Salesforce)].[Action (Industry)] [Opportunities (Salesforce)].[Action (Billing City,Billing Country)] Styles Style: axis [Opportunities (Salesforce)].[SUM(Expected Amount)] title: Expected Amount auto-subtitle: true width: 107 [Opportunities (Salesforce)].[Opportunity ID] title: Number of Opportunities auto-subtitle: true width: 107 [Opportunities (Salesforce)].[DAY(Close Date)] auto-subtitle: true Other line-pattern-only: solid tick-color: #00000000 stroke-size: 3 stroke-color: #333333 line-visibility: off Style: header [Opportunities (Salesforce)].[MY(Close Date)] height: 19 background-color: #f2f2f3 cols band-color: #00000000 [Opportunities (Salesforce)].[SUM(Expected Amount)] background-color: #ffffff [Opportunities (Salesforce)].[Opportunity ID] background-color: #ffffff Style: label [Opportunities (Salesforce)].[WEEK(Close Date)] display: false text-format: iw text-orientation: 0 wrap: auto [Opportunities (Salesforce)].[SUM(Expected Amount)] text-format: c"$"#,##0;("$"#,##0) [Opportunities (Salesforce)].[MY(Close Date)] font-size: 8 Style: pane cols band-color: #00000000 Style: table cols band-level: 1 band-size: 1 Style: worksheet cols display-field-labels: false Other font-family: Tableau Book Style: refline refline0 fill-above: #00000000 fill-below: #00000000 line-visibility: on line-pattern-only: dashed stroke-size: 1 stroke-color: #89898967 font-size: 6 background-color: #ffffff00 refline1 line-visibility: on line-pattern-only: dashed stroke-size: 1 stroke-color: #89898967 fill-above: #00000000 fill-below: #00000000 font-size: 6 background-color: #ffffff00 Style: gridline Other line-visibility: on line-pattern-only: solid Style: zeroline Other line-pattern-only: solid stroke-color: #333333 stroke-size: 5 line-visibility: off Style: table-div rows line-visibility: on line-pattern-only: solid stroke-size: 2 stroke-color: #f5f5f5 cols line-pattern-only: solid stroke-size: 1 stroke-color: #e6e6e6 line-visibility: off Style: header-div cols stroke-color: #ffffff line-visibility: on line-pattern-only: solid stroke-size: 5 rows stroke-color: #f5f5f5 stroke-size: 4 Style: title Other background-color: #f2f2f3 Style: axis-title [Opportunities (Salesforce)].[SUM(Expected Amount)] font-family: Tableau Regular [Opportunities (Salesforce)].[Opportunity ID] font-family: Tableau Regular Style: quick-filter [Opportunities (Salesforce)].[Name (User)] title: Manager Style: quick-filter-title Other font-family: Tableau Regular font-size: 8 font-weight: normal Style: tooltip Other font-family: Tableau Book Worksheet: Geographic Distribution Visible: No Used Datasources Datasource: Opportunities (Salesforce) Discrete Dimension: Billing City Remote Column: [Account].[BillingCity] Discrete Dimension: Billing Country Remote Column: [Account].[BillingCountry] Discrete Dimension: Close Date Remote Column: [Opportunities].[CloseDate] Discrete Dimension: Forecast Category Remote Column: [Opportunities].[ForecastCategory] Discrete Dimension: Full Name Remote Column: [Owned By].[Name] Discrete Dimension: Industry Remote Column: [Account].[Industry] Discrete Dimension: Name (Product) Remote Column: [Product2].[Name] Discrete Dimension: Name (User) Remote Column: [Manager].[Name] Discrete Dimension: Stage Remote Column: [Opportunities].[StageName] Continous Measure: Expected Amount Remote Column: [Opportunities].[ExpectedRevenue] Marks Mark: All Type: Automatic Tooltip: <[Opportunities (Salesforce)].[Billing City]> | <[Opportunities (Salesforce)].[Billing Country]> Expected Amount: <[Opportunities (Salesforce)].[SUM(Expected Amount)]> Opportunities Details: View Rows: [Opportunities (Salesforce)].[Latitude (generated)] Columns: [Opportunities (Salesforce)].[Longitude (generated)] Filters: [Opportunities (Salesforce)].[Action (Industry)] [Opportunities (Salesforce)].[Action (MY(Close Date),DAY(Close Date),Forecast Category)] [Opportunities (Salesforce)].[Billing Country] [Opportunities (Salesforce)].[Close Date] [Opportunities (Salesforce)].[Full Name] [Opportunities (Salesforce)].[Industry] [Opportunities (Salesforce)].[Name (Product)] [Opportunities (Salesforce)].[Name (User)] [Opportunities (Salesforce)].[Stage] Slices: [Opportunities (Salesforce)].[Close Date] [Opportunities (Salesforce)].[Full Name] [Opportunities (Salesforce)].[Billing Country] [Opportunities (Salesforce)].[Name (Product)] [Opportunities (Salesforce)].[Industry] [Opportunities (Salesforce)].[Name (User)] [Opportunities (Salesforce)].[Stage] [Opportunities (Salesforce)].[Action (Industry)] [Opportunities (Salesforce)].[Action (MY(Close Date),DAY(Close Date),Forecast Category)] Styles Style: pane Other border-style: none Style: table Other show-null-value-warning: false Style: table-div rows line-visibility: off cols line-visibility: off Style: title Other background-color: #f2f2f3 Style: map-layer tab_base enabled: true um_lcover enabled: true tab_coastline enabled: true pp2_line enabled: false light_adm0_bnd enabled: true light_adm0_lbl enabled: false um_adm0_bnd enabled: false um_adm0_lbl enabled: false light_pp2_statebounds enabled: false light_pp2_statelabels enabled: false pp2_adminlabels enabled: false pp2_statebounds enabled: false pp2_statelabels enabled: true countybounds enabled: false countylabels enabled: false zipbounds enabled: false ziplabels enabled: false tab_areabounds enabled: false tab_arealabels enabled: false tab_msabounds enabled: false tab_msalabels enabled: false Style: map Other washout: 0.40000000596046448 Worksheet: Industry Size Visible: No Used Datasources Datasource: Opportunities (Salesforce) Discrete Dimension: Billing City Remote Column: [Account].[BillingCity] Discrete Dimension: Billing Country Remote Column: [Account].[BillingCountry] Discrete Dimension: Close Date Remote Column: [Opportunities].[CloseDate] Discrete Dimension: Closed Remote Column: [Opportunities].[IsClosed] Discrete Dimension: Forecast Category Remote Column: [Opportunities].[ForecastCategory] Discrete Dimension: Full Name Remote Column: [Owned By].[Name] Discrete Dimension: Industry Remote Column: [Account].[Industry] Discrete Dimension: Name (Product) Remote Column: [Product2].[Name] Discrete Dimension: Name (User) Remote Column: [Manager].[Name] Discrete Dimension: Opportunity ID Remote Column: [Opportunities].[Id] Discrete Dimension: Stage Remote Column: [Opportunities].[StageName] Discrete Dimension: Won Remote Column: [Opportunities].[IsWon] Continous Measure: Win rate Continous Measure: # of Wins Marks Mark: All Type: Square Label: <[Opportunities (Salesforce)].[Industry]> <[Opportunities (Salesforce)].[# of Wins (copy 2)]> win Tooltip: <[Opportunities (Salesforce)].[Industry]> Opportunities Total: <[Opportunities (Salesforce)].[Opportunity ID]> Win rate: <[Opportunities (Salesforce)].[# of Wins (copy 2)]> # of Wins: <[Opportunities (Salesforce)].[# of Wins]> View Filters: [Opportunities (Salesforce)].[Action (Billing City,Billing Country)] [Opportunities (Salesforce)].[Action (MY(Close Date),DAY(Close Date),Forecast Category)] [Opportunities (Salesforce)].[Billing Country] [Opportunities (Salesforce)].[Close Date] [Opportunities (Salesforce)].[Full Name] [Opportunities (Salesforce)].[Industry] [Opportunities (Salesforce)].[Name (Product)] [Opportunities (Salesforce)].[Name (User)] [Opportunities (Salesforce)].[Stage] Slices: [Opportunities (Salesforce)].[Close Date] [Opportunities (Salesforce)].[Full Name] [Opportunities (Salesforce)].[Billing Country] [Opportunities (Salesforce)].[Name (Product)] [Opportunities (Salesforce)].[Industry] [Opportunities (Salesforce)].[Name (User)] [Opportunities (Salesforce)].[Stage] [Opportunities (Salesforce)].[Action (Billing City,Billing Country)] [Opportunities (Salesforce)].[Action (MY(Close Date),DAY(Close Date),Forecast Category)] Styles Style: pane Other border-style: none Style: worksheet Other font-family: Tableau Book Style: table-div rows line-visibility: off cols line-visibility: off Style: legend Other font-family: Tableau Book font-size: 7 Style: legend-title-text [Opportunities (Salesforce)].[# of Wins (copy 2)] color: Win rate: Worksheet: Sheet 1 Visible: No Marks Mark: All Type: Automatic View Worksheet: Show Manager Visible: No Used Datasources Datasource: Opportunities (Salesforce) Discrete Dimension: Account Name Remote Column: [Account].[Name] Discrete Dimension: Billing Country Remote Column: [Account].[BillingCountry] Discrete Dimension: Close Date Remote Column: [Opportunities].[CloseDate] Discrete Dimension: Forecast Category Remote Column: [Opportunities].[ForecastCategory] Discrete Dimension: Full Name Remote Column: [Owned By].[Name] Discrete Dimension: Industry Remote Column: [Account].[Industry] Discrete Dimension: Name (Product) Remote Column: [Product2].[Name] Discrete Dimension: Name (User) Remote Column: [Manager].[Name] Discrete Dimension: Stage Remote Column: [Opportunities].[StageName] Discrete Measure: Show Salesperson Name Marks Mark: All Type: Automatic Label: <[Opportunities (Salesforce)].[Show Salesperson Name]> View Filters: [Opportunities (Salesforce)].[Action (Account Name)] [Opportunities (Salesforce)].[Action (MY(Close Date),DAY(Close Date),Forecast Category)] [Opportunities (Salesforce)].[Billing Country] [Opportunities (Salesforce)].[Close Date] [Opportunities (Salesforce)].[Full Name] [Opportunities (Salesforce)].[Industry] [Opportunities (Salesforce)].[Name (Product)] [Opportunities (Salesforce)].[Name (User)] [Opportunities (Salesforce)].[Stage] Slices: [Opportunities (Salesforce)].[Close Date] [Opportunities (Salesforce)].[Full Name] [Opportunities (Salesforce)].[Action (Account Name)] [Opportunities (Salesforce)].[Billing Country] [Opportunities (Salesforce)].[Name (Product)] [Opportunities (Salesforce)].[Industry] [Opportunities (Salesforce)].[Name (User)] [Opportunities (Salesforce)].[Stage] [Opportunities (Salesforce)].[Action (MY(Close Date),DAY(Close Date),Forecast Category)] Styles Style: table Other background-color: #f2f2f3 Style: table-div cols line-visibility: off rows line-visibility: off Style: title Other background-color: #f2f2f3 Worksheet: Tooltip - Opportunities Visible: No Used Datasources Datasource: Opportunities (Salesforce) Discrete Dimension: Account Name Remote Column: [Account].[Name] Discrete Dimension: Billing City Remote Column: [Account].[BillingCity] Discrete Dimension: Billing Country Remote Column: [Account].[BillingCountry] Discrete Dimension: Close Date Remote Column: [Opportunities].[CloseDate] Discrete Dimension: Closed Remote Column: [Opportunities].[IsClosed] Discrete Dimension: Forecast Category Remote Column: [Opportunities].[ForecastCategory] Discrete Dimension: Opportunity ID Remote Column: [Opportunities].[Id] Continous Measure: Active Opportunities Continous Measure: Expected Amount Remote Column: [Opportunities].[ExpectedRevenue] Marks Mark: All Type: Automatic Tooltip: Account Name: <[Opportunities (Salesforce)].[Account Name]> Forecast Category: <[Opportunities (Salesforce)].[Forecast Category]> Opportunity ID: <[Opportunities (Salesforce)].[Opportunity ID]> Expected Amount: <[Opportunities (Salesforce)].[SUM(Expected Amount)]> View Rows: [Opportunities (Salesforce)].[Opportunity ID] [Opportunities (Salesforce)].[Account Name] Columns: [Opportunities (Salesforce)].[SUM(Expected Amount)] Filters: [Opportunities (Salesforce)].[Measure Names()] [Opportunities (Salesforce)].[Tooltip (Billing City,Billing Country)] [Opportunities (Salesforce)].[Tooltip (MY(Close Date),DAY(Close Date),Forecast Category)] [Opportunities (Salesforce)].[Forecast Category] Manual Sorting: [Opportunities (Salesforce)].[Opportunity ID] ASC Slices: [Opportunities (Salesforce)].[Measure Names()] [Opportunities (Salesforce)].[Tooltip (MY(Close Date),DAY(Close Date),Forecast Category)] [Opportunities (Salesforce)].[Tooltip (Billing City,Billing Country)] Styles Style: axis [Opportunities (Salesforce)].[SUM(Expected Amount)] display: false Style: cell [Opportunities (Salesforce)].[Account Name] height: 23 Style: header [Opportunities (Salesforce)].[Account Name] width: 204 Style: field-labels Other font-size: 8 font-family: Tableau Regular Style: label [Opportunities (Salesforce)].[Opportunity ID] display: false [Opportunities (Salesforce)].[Account Name] font-family: Tableau Book font-size: 8 Style: pane Other border-style: none Style: zeroline Other line-visibility: on line-pattern-only: solid stroke-size: 3 stroke-color: #f5f5f5 Style: table-div rows stroke-color: #f5f5f5 cols line-visibility: off Worksheet: Total Opportunities Visible: No Used Datasources Datasource: Opportunities (Salesforce) Discrete Dimension: Billing City Remote Column: [Account].[BillingCity] Discrete Dimension: Billing Country Remote Column: [Account].[BillingCountry] Discrete Dimension: Close Date Remote Column: [Opportunities].[CloseDate] Discrete Dimension: Closed Remote Column: [Opportunities].[IsClosed] Discrete Dimension: Forecast Category Remote Column: [Opportunities].[ForecastCategory] Discrete Dimension: Full Name Remote Column: [Owned By].[Name] Discrete Dimension: Industry Remote Column: [Account].[Industry] Discrete Dimension: Name (Product) Remote Column: [Product2].[Name] Discrete Dimension: Name (User) Remote Column: [Manager].[Name] Discrete Dimension: Opportunity ID Remote Column: [Opportunities].[Id] Discrete Dimension: Stage Remote Column: [Opportunities].[StageName] Discrete Dimension: Won Remote Column: [Opportunities].[IsWon] Continous Measure: Active Opportunities Continous Measure: Win rate Continous Measure: Amount Remote Column: [Opportunities].[Amount] Continous Measure: # of Wins Continous Measure: Sales Continous Measure: Expected Amount Remote Column: [Opportunities].[ExpectedRevenue] Marks Mark: All Type: Text Label: <[Opportunities (Salesforce)].[Multiple Values]> Tooltip: Account Name: Number of Opportunities: View Columns: [Opportunities (Salesforce)].[Measure Names()] Filters: [Opportunities (Salesforce)].[Measure Names()] [Opportunities (Salesforce)].[Action (Billing City,Billing Country)] [Opportunities (Salesforce)].[Action (Industry)] [Opportunities (Salesforce)].[Action (MY(Close Date),DAY(Close Date),Forecast Category)] [Opportunities (Salesforce)].[Billing Country] [Opportunities (Salesforce)].[Close Date] [Opportunities (Salesforce)].[Full Name] [Opportunities (Salesforce)].[Industry] [Opportunities (Salesforce)].[Name (Product)] [Opportunities (Salesforce)].[Name (User)] [Opportunities (Salesforce)].[Stage] Manual Sorting: [Opportunities (Salesforce)].[Measure Names()] ASC Slices: [Opportunities (Salesforce)].[Close Date] [Opportunities (Salesforce)].[Full Name] [Opportunities (Salesforce)].[Measure Names()] [Opportunities (Salesforce)].[Billing Country] [Opportunities (Salesforce)].[Name (Product)] [Opportunities (Salesforce)].[Industry] [Opportunities (Salesforce)].[Name (User)] [Opportunities (Salesforce)].[Stage] [Opportunities (Salesforce)].[Action (Industry)] [Opportunities (Salesforce)].[Action (Billing City,Billing Country)] [Opportunities (Salesforce)].[Action (MY(Close Date),DAY(Close Date),Forecast Category)] Styles Style: cell Other text-align: center color: #f47942 [Opportunities (Salesforce)].[SUM(Sales)] text-format: c"$"#,##0,K;("$"#,##0,K) [Opportunities (Salesforce)].[SUM(Expected Amount)] text-format: c"$"#,##0,K;("$"#,##0,K) Style: header [Opportunities (Salesforce)].[Measure Names()] height: 30 background-color: #f2f2f3 Style: label [Opportunities (Salesforce)].[Measure Names()] text-align: center font-family: Tableau Regular color: #333333 vertical-align: center font-size: 9 font-weight: normal Style: table Other background-color: #00000000 Style: worksheet Other font-size: 14 font-weight: bold Style: table-div rows line-visibility: off cols stroke-size: 5 line-visibility: on line-pattern-only: solid div-level: 1 stroke-color: #e6e6e6 Style: title Other font-size: 14 font-weight: bold background-color: #f2f2f3 Style: legend Other background-color: #ffffff Style: quick-filter Other font-size: 8 font-weight: normal Style: quick-filter-title Other font-size: 14 font-weight: bold Style: parameter-ctrl Other font-size: 8 font-weight: normal Style: parameter-ctrl-title Other font-size: 9 font-weight: bold