**************************************************************************** Location : Tableau Server Host : http://bnbrepository9/#/ Path : Tableau Samples/Toip 20 Accounts **************************************************************************** Workbook Information Author: Unknown Embedded Datasources Datasource: Parameters Connection Measure Calculated/Other Measure: Sort by N Role: Continous Measure Data Type: integer Formula: 20 Default Value: 20 Parameter Type: range Measure: Pick a Measure Role: Discrete Measure Data Type: string Formula: "1" Default Value: "1" Parameter Type: list 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: 25.0 server: login.salesforce.com sf-total-requestor-buffer-size-in-mb: 32 standard: Opportunities userLanguage: en_US username: tableautemplates@gmail.com 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: Owned By Database Object: [User] Connection: Opportunities (Salesforce) Table: Account Database Object: [Account] Connection: Opportunities (Salesforce) Table: UserRole Database Object: [UserRole] Connection: Opportunities (Salesforce) Table: OpportunityLineItem Database Object: [OpportunityLineItem] Connection: Opportunities (Salesforce) Table: Pricebook2 Database Object: [Pricebook2] 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: Id (Account) Role: Discrete Dimension Remote Column: [Account].[Id] Data Type: string 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: 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: 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: 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: 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: 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: State (User) Role: Discrete Dimension Remote Column: [Manager].[State] 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: 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: 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: 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: UserPreferencesLightningExperiencePreferred (User) Role: Discrete Dimension Remote Column: [Manager].[UserPreferencesLightningExperiencePreferred] Data Type: boolean Dimension: UserPreferencesOptOutOfTouch (User) Role: Discrete Dimension Remote Column: [Manager].[UserPreferencesOptOutOfTouch] Data Type: boolean Dimension: UserPreferencesReminderSoundOff (User) Role: Discrete Dimension Remote Column: [Manager].[UserPreferencesReminderSoundOff] 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: 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: 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 ID Role: Discrete Dimension Remote Column: [Opportunities].[Id] 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: Probability (%) Role: Discrete Dimension Remote Column: [Opportunities].[Probability] Data Type: real Aggregation: Sum 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: Price Book Entry ID Role: Discrete Dimension Remote Column: [OpportunityLineItem].[PricebookEntryId] 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: 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: 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: 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: 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: Info Emails Role: Discrete Dimension Remote Column: [Owned By].[ReceivesInfoEmails] 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: 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: Opt Out Of Touch Role: Discrete Dimension Remote Column: [Owned By].[UserPreferencesOptOutOfTouch] 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: 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: 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 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: Zip/Postal Code Role: Discrete Dimension Remote Column: [Owned By].[PostalCode] Data Type: string Pricebook2 Dimension: CreatedById (Price Book) Role: Discrete Dimension Remote Column: [Pricebook2].[CreatedById] Data Type: string Dimension: CreatedDate (Price Book) Role: Discrete Dimension Remote Column: [Pricebook2].[CreatedDate] Data Type: datetime Dimension: Description (Price Book) Role: Discrete Dimension Remote Column: [Pricebook2].[Description] Data Type: string Dimension: Is Standard Price Book Role: Discrete Dimension Remote Column: [Pricebook2].[IsStandard] Data Type: boolean Dimension: IsActive (Price Book) Role: Discrete Dimension Remote Column: [Pricebook2].[IsActive] Data Type: boolean Dimension: IsDeleted (Price Book) Role: Discrete Dimension Remote Column: [Pricebook2].[IsDeleted] Data Type: boolean Dimension: LastModifiedById (Price Book) Role: Discrete Dimension Remote Column: [Pricebook2].[LastModifiedById] Data Type: string Dimension: LastModifiedDate (Price Book) Role: Discrete Dimension Remote Column: [Pricebook2].[LastModifiedDate] Data Type: datetime Dimension: Price Book Name Role: Discrete Dimension Remote Column: [Pricebook2].[Name] Data Type: string Dimension: SystemModstamp (Price Book) Role: Discrete Dimension Remote Column: [Pricebook2].[SystemModstamp] Data Type: datetime UserRole Dimension: Case Access Level for Account Owner Role: Discrete Dimension Remote Column: [UserRole].[CaseAccessForAccountOwner] Data Type: string Dimension: Contact Access Level for Account Owner Role: Discrete Dimension Remote Column: [UserRole].[ContactAccessForAccountOwner] Data Type: string Dimension: Developer Name Role: Discrete Dimension Remote Column: [UserRole].[DeveloperName] Data Type: string Dimension: ForecastUserId (Role) Role: Discrete Dimension Remote Column: [UserRole].[ForecastUserId] Data Type: string Dimension: LastModifiedById (Role) Role: Discrete Dimension Remote Column: [UserRole].[LastModifiedById] Data Type: string Dimension: LastModifiedDate (Role) Role: Discrete Dimension Remote Column: [UserRole].[LastModifiedDate] Data Type: datetime Dimension: May Forecast Manager Share Role: Discrete Dimension Remote Column: [UserRole].[MayForecastManagerShare] Data Type: boolean Dimension: Name Role: Discrete Dimension Remote Column: [UserRole].[Name] Data Type: string Dimension: Opportunity Access Level for Account Owner Role: Discrete Dimension Remote Column: [UserRole].[OpportunityAccessForAccountOwner] Data Type: string Dimension: Parent Role ID Role: Discrete Dimension Remote Column: [UserRole].[ParentRoleId] Data Type: string Dimension: Portal Type Role: Discrete Dimension Remote Column: [UserRole].[PortalType] Data Type: string Dimension: PortalAccountId (Role) Role: Discrete Dimension Remote Column: [UserRole].[PortalAccountId] Data Type: string Dimension: SystemModstamp (Role) Role: Discrete Dimension Remote Column: [UserRole].[SystemModstamp] Data Type: datetime Dimension: User ID1 Role: Discrete Dimension Remote Column: [UserRole].[PortalAccountOwnerId] Data Type: string Calculated/Other Dimension: Measure Names Role: Discrete Dimension Data Type: string Dimension: Sort By Role: Discrete Dimension Data Type: integer Formula: //This is a calculation // It grabs the parameter value [Parameters].[Id (Account) Parameter] Aggregation: Sum Dimension: Groups Role: Discrete Dimension Data Type: string Formula: //This is an If Statement // It groups opportunities into big groups won/lost/open IF [Closed]=TRUE AND [Won]=TRUE THEN "Closed Won" ELSEIF [Closed]=TRUE AND [Won]=FALSE THEN "Closed Lost" ELSE "Open" 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: 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 Manager 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: Quantity Role: Continous Measure Remote Column: [Opportunities].[TotalOpportunityQuantity] Data Type: real 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 Measure: Forecast Category Role: Continous Measure Remote Column: [Opportunities].[ForecastCategory] Data Type: string 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 Measure: OpportunityId (Opportunity Product) Role: Continous Measure Remote Column: [OpportunityLineItem].[OpportunityId] Data Type: string Aggregation: Count Owned By 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 Pricebook2 Measure: Id (Price Book) Role: Continous Measure Remote Column: [Pricebook2].[Id] Data Type: string Aggregation: Count UserRole Measure: Id (Role) Role: Continous Measure Remote Column: [UserRole].[Id] Data Type: string Aggregation: Count Measure: Description Role: Continous Measure Remote Column: [UserRole].[RollupDescription] Data Type: string Aggregation: Count Calculated/Other Measure: % of Total Expected Value Role: Continous Measure Data Type: real Formula: //This is a calculation // It calculates the expected value of accounts selected by user against total [Expected Value]/ {sum([Expected Value])} Measure: % of Total Sales Role: Continous Measure Data Type: real Formula: //This is a calculation // It calculates the sales of the accounts selected by the user against total [Sales]/ {sum([Sales])} Measure: % of Total Wins Role: Continous Measure Data Type: real Formula: //This is a calculation // It shows the wins of accounts selected by user against total [# of Wins]/ {sum([# of Wins])} Measure: % of Total Open Opp Role: Continous Measure Data Type: real Formula: //This is a calculation // It shows oppen opportunities of accounts selected by user against total [# Open Opp.]/ {sum([# Open Opp.])} Measure: Show Manager Role: Discrete Measure Data Type: string Formula: //This is an If Statement // It shows the managers name if a manager is selected IIF (COUNTD([Name (User)])=1, ATTR([Name (User)])+"'s team", "All teams") Measure: MIN Close Date Role: Discrete Measure Data Type: date Formula: //This is a minimum function // It shows the minimum value for Close Date MIN([Close Date]) Measure: Expected Value Role: Continous Measure Data Type: real Formula: //This is a Level of Detail Calculation (LOD) // It shows the expected value { FIXED [Id (Account)], [Opportunity ID], [Groups]: SUM([Expected Amount])} Measure: Pick a Measure Control Role: Continous Measure Data Type: real Formula: //This is a Case Statement // It is used to control the parameter; CASE [Parameters].[Parameter 1] WHEN "1" THEN [Expected Amount] WHEN "2" THEN [Amount (Excl Closed)] END Measure: Sales + Pipeline Role: Continous Measure Data Type: real Formula: //This is a calculation combining a Level of Detail calculation and an If Statement // It shows total amount for selected accounts ZN(IF [Forecast Category]="Pipeline" OR [Forecast Category]="Closed" THEN { FIXED [Id (Account)], [Opportunity ID]: SUM([Amount])} END) Measure: Amount (Excl Closed) Role: Continous Measure Data Type: real Formula: //This is a calculation combining a Level of Detail calculation (LOD) and an If Statement // It shows open pipeline amount for selected accounts ZN(IF [Closed]=TRUE AND [Won]=TRUE OR [Closed]=FALSE THEN [Amount] END) Measure: Win Rate Role: Continous Measure Data Type: real Formula: //This is a calculated field //It calculates all opportunities close/won against all opportunities closed //Calculate total of wins SUM([# of Wins]) // Divide by number of closed opportunities / SUM({ FIXED [Id (Account)], [Opportunity ID]: ZN(COUNTD(IF [Closed]=TRUE THEN [Opportunity ID] END))}) Measure: # of Wins Role: Continous Measure Data Type: integer Formula: //This is a Level of Detail calculation (LOD) // It shows "1" for each won opportunity { FIXED [Id (Account)], [Opportunity ID]: ZN(COUNTD(IF[Closed]=TRUE AND [Won]=TRUE THEN [Opportunity ID] END)) } Measure: # of Accounts Role: Continous Measure Data Type: integer Formula: // This is a Count Distinct function // It is used to count the number of accounts; COUNTD([Id (Account)]) Measure: Sales Role: Continous Measure Data Type: real Formula: //This is a Level of Detail calculation (LOD)to show sales // Sales are all won/closed oportunities in the pipeline { FIXED [Id (Account)], [Opportunity ID]: SUM(IIF([Won]=TRUE AND [Closed]=TRUE, [Amount], 0))} Measure: # Open Opp. Role: Continous Measure Data Type: integer Formula: //This is a Level of Detail calculation (LOD)to show all open opportunities // Open Oportunities are all marked as "Pipeline" in Forecast Category { FIXED [Id (Account)], [Opportunity ID]: ZN(COUNTD(IF [Forecast Category]="Pipeline" THEN [Opportunity ID] END))} Measure: % of Total Amount Role: Continous Measure Data Type: real Formula: //This is a calculation // It shows the amount of selected accounts against total amount [Sales + Pipeline]/ {sum([Sales + Pipeline])} Measure: MAX Close Date Role: Discrete Measure Data Type: date Formula: MAX([Close Date]) Measure: Measure Values Role: Continous Measure Data Type: real Measure: Number of Records Role: Continous Measure Data Type: integer Formula: 1 Parameter Calculated/Other Measure: Sort by N Role: Continous Measure Data Type: integer Formula: 20 Default Value: 20 Parameter Type: range Measure: Pick a Measure Role: Discrete Measure Data Type: string Formula: "1" Default Value: "1" Parameter Type: list Semantic Values [Country].[Name]: "United States" Dashboards Dashboard: Top Accounts Worksheets Worksheet: Manager Name Datasources: Opportunities (Salesforce) Used Dimensions & Measures: [Billing City] [Billing Country] [Billing State/Province] [Industry] [Name (User)] [Show Manager] Used Remote Columns: [Account].[BillingCity] [Account].[BillingCountry] [Account].[BillingState] [Account].[Industry] [Manager].[Name] Worksheet: Summary of Accounts Datasources: Opportunities (Salesforce) Parameters Used Dimensions & Measures: [Billing City] [Billing Country] [Billing State/Province] [Close Date] [Closed] [Full Name] [Groups] [Industry] [MAX Close Date] [MIN Close Date] [Name (User)] [Sort by N] [Sort By] [Won] Used Remote Columns: [Account].[BillingCity] [Account].[BillingCountry] [Account].[BillingState] [Account].[Industry] [Manager].[Name] [Opportunities].[CloseDate] [Opportunities].[IsClosed] [Opportunities].[IsWon] [Owned By].[Name] Worksheet: Big Numbers 1 Datasources: Opportunities (Salesforce) Parameters Used Dimensions & Measures: [% of Total Amount] [Amount] [Billing City] [Billing Country] [Billing State/Province] [Close Date] [Closed] [Expected Amount] [Expected Value] [Forecast Category] [Full Name] [Groups] [Id (Account)] [Industry] [MAX Close Date] [MIN Close Date] [Name (User)] [Opportunity ID] [Sales + Pipeline] [Sort by N] [Sort By] [Won] Used Remote Columns: [Account].[BillingCity] [Account].[BillingCountry] [Account].[BillingState] [Account].[Id] [Account].[Industry] [Manager].[Name] [Opportunities].[Amount] [Opportunities].[CloseDate] [Opportunities].[ExpectedRevenue] [Opportunities].[ForecastCategory] [Opportunities].[Id] [Opportunities].[IsClosed] [Opportunities].[IsWon] [Owned By].[Name] Worksheet: Big Numbers 4 Datasources: Opportunities (Salesforce) Parameters Used Dimensions & Measures: [Amount] [Billing City] [Billing Country] [Billing State/Province] [Close Date] [Closed] [Expected Amount] [Full Name] [Groups] [Id (Account)] [Industry] [Name (User)] [Opportunity ID] [Sales] [Sort by N] [Sort By] [Won] Used Remote Columns: [Account].[BillingCity] [Account].[BillingCountry] [Account].[BillingState] [Account].[Id] [Account].[Industry] [Manager].[Name] [Opportunities].[Amount] [Opportunities].[CloseDate] [Opportunities].[ExpectedRevenue] [Opportunities].[Id] [Opportunities].[IsClosed] [Opportunities].[IsWon] [Owned By].[Name] Worksheet: Big Numbers 2 Datasources: Opportunities (Salesforce) Parameters Used Dimensions & Measures: [# of Wins] [# Open Opp.] [% of Total Open Opp] [Billing City] [Billing Country] [Billing State/Province] [Close Date] [Closed] [Expected Amount] [Forecast Category] [Full Name] [Groups] [Id (Account)] [Industry] [MAX Close Date] [MIN Close Date] [Name (User)] [Opportunity ID] [Sort by N] [Sort By] [Won] Used Remote Columns: [Account].[BillingCity] [Account].[BillingCountry] [Account].[BillingState] [Account].[Id] [Account].[Industry] [Manager].[Name] [Opportunities].[CloseDate] [Opportunities].[ExpectedRevenue] [Opportunities].[ForecastCategory] [Opportunities].[Id] [Opportunities].[IsClosed] [Opportunities].[IsWon] [Owned By].[Name] Worksheet: Big Numbers 3 Datasources: Opportunities (Salesforce) Parameters Used Dimensions & Measures: [# of Accounts] [# of Wins] [# Open Opp.] [Amount] [Billing City] [Billing Country] [Billing State/Province] [Close Date] [Closed] [Expected Amount] [Expected Value] [Forecast Category] [Full Name] [Groups] [Id (Account)] [Industry] [MAX Close Date] [MIN Close Date] [Name (User)] [Opportunity ID] [Sales] [Sort by N] [Sort By] [Win Rate] [Won] Used Remote Columns: [Account].[BillingCity] [Account].[BillingCountry] [Account].[BillingState] [Account].[Id] [Account].[Industry] [Manager].[Name] [Opportunities].[Amount] [Opportunities].[CloseDate] [Opportunities].[ExpectedRevenue] [Opportunities].[ForecastCategory] [Opportunities].[Id] [Opportunities].[IsClosed] [Opportunities].[IsWon] [Owned By].[Name] Worksheet: % Total 2 Datasources: Opportunities (Salesforce) Parameters Used Dimensions & Measures: [% of Total Sales] [Amount] [Billing City] [Billing Country] [Billing State/Province] [Close Date] [Closed] [Expected Amount] [Full Name] [Groups] [Id (Account)] [Industry] [Name (User)] [Opportunity ID] [Sales] [Sort by N] [Sort By] [Won] Used Remote Columns: [Account].[BillingCity] [Account].[BillingCountry] [Account].[BillingState] [Account].[Id] [Account].[Industry] [Manager].[Name] [Opportunities].[Amount] [Opportunities].[CloseDate] [Opportunities].[ExpectedRevenue] [Opportunities].[Id] [Opportunities].[IsClosed] [Opportunities].[IsWon] [Owned By].[Name] Worksheet: % Total 3 Datasources: Opportunities (Salesforce) Parameters Used Dimensions & Measures: [# of Wins] [# Open Opp.] [% of Total Open Opp] [% of Total Wins] [Billing City] [Billing Country] [Billing State/Province] [Close Date] [Closed] [Expected Amount] [Forecast Category] [Full Name] [Groups] [Id (Account)] [Industry] [MAX Close Date] [MIN Close Date] [Name (User)] [Opportunity ID] [Sort by N] [Sort By] [Won] Used Remote Columns: [Account].[BillingCity] [Account].[BillingCountry] [Account].[BillingState] [Account].[Id] [Account].[Industry] [Manager].[Name] [Opportunities].[CloseDate] [Opportunities].[ExpectedRevenue] [Opportunities].[ForecastCategory] [Opportunities].[Id] [Opportunities].[IsClosed] [Opportunities].[IsWon] [Owned By].[Name] Worksheet: % Total 1 Datasources: Opportunities (Salesforce) Parameters Used Dimensions & Measures: [% of Total Amount] [% of Total Expected Value] [Amount] [Billing City] [Billing Country] [Billing State/Province] [Close Date] [Closed] [Expected Amount] [Expected Value] [Forecast Category] [Full Name] [Groups] [Id (Account)] [Industry] [MAX Close Date] [MIN Close Date] [Name (User)] [Opportunity ID] [Sales + Pipeline] [Sort by N] [Sort By] [Won] Used Remote Columns: [Account].[BillingCity] [Account].[BillingCountry] [Account].[BillingState] [Account].[Id] [Account].[Industry] [Manager].[Name] [Opportunities].[Amount] [Opportunities].[CloseDate] [Opportunities].[ExpectedRevenue] [Opportunities].[ForecastCategory] [Opportunities].[Id] [Opportunities].[IsClosed] [Opportunities].[IsWon] [Owned By].[Name] Worksheet: City Datasources: Opportunities (Salesforce) Parameters Used Dimensions & Measures: [Account Name] [Amount (Excl Closed)] [Amount] [Billing City] [Billing Country] [Billing State/Province] [Close Date] [Closed] [Description] [Expected Amount] [Full Name] [Groups] [Id (Account)] [Industry] [Name (User)] [Opportunity ID] [Pick a Measure Control] [Pick a Measure] [Sort by N] [Sort By] [Won] Used Remote Columns: [Account].[BillingCity] [Account].[BillingCountry] [Account].[BillingState] [Account].[Id] [Account].[Industry] [Account].[Name] [Manager].[Name] [Opportunities].[Amount] [Opportunities].[CloseDate] [Opportunities].[ExpectedRevenue] [Opportunities].[Id] [Opportunities].[IsClosed] [Opportunities].[IsWon] [Owned By].[Name] [UserRole].[RollupDescription] Worksheet: Breakdown by Industry Datasources: Opportunities (Salesforce) Parameters Used Dimensions & Measures: [Account Name] [Amount (Excl Closed)] [Amount] [Billing City] [Billing Country] [Billing State/Province] [Close Date] [Closed] [Expected Amount] [Full Name] [Groups] [Id (Account)] [Industry] [Name (User)] [Opportunity ID] [Pick a Measure Control] [Pick a Measure] [Sort by N] [Sort By] [Won] Used Remote Columns: [Account].[BillingCity] [Account].[BillingCountry] [Account].[BillingState] [Account].[Id] [Account].[Industry] [Account].[Name] [Manager].[Name] [Opportunities].[Amount] [Opportunities].[CloseDate] [Opportunities].[ExpectedRevenue] [Opportunities].[Id] [Opportunities].[IsClosed] [Opportunities].[IsWon] [Owned By].[Name] Worksheet: Top Datasources: Opportunities (Salesforce) Parameters Used Dimensions & Measures: [Account Name] [Amount (Excl Closed)] [Amount] [Billing City] [Billing Country] [Billing State/Province] [Close Date] [Closed] [Expected Amount] [Full Name] [Groups] [Id (Account)] [Industry] [Name (User)] [Pick a Measure Control] [Pick a Measure] [Sort by N] [Sort By] [Won] Used Remote Columns: [Account].[BillingCity] [Account].[BillingCountry] [Account].[BillingState] [Account].[Id] [Account].[Industry] [Account].[Name] [Manager].[Name] [Opportunities].[Amount] [Opportunities].[CloseDate] [Opportunities].[ExpectedRevenue] [Opportunities].[IsClosed] [Opportunities].[IsWon] [Owned By].[Name] Dashboard Objects: Filter: [Opportunities (Salesforce)].[Groups] Filter: [Opportunities (Salesforce)].[Full Name] Filter: [Opportunities (Salesforce)].[Billing Country] Filter: [Opportunities (Salesforce)].[Close Date] Filter: [Opportunities (Salesforce)].[Name (User)] Text: Top <[Parameters].[Id (Account) Parameter]> Text: Use Options Below to Filter Text: Æ Worksheets Worksheet: % Total 1 Visible: No Used Datasources Datasource: Parameters Continous Measure: Sort by N Datasource: Opportunities (Salesforce) Discrete Dimension: Billing City Remote Column: [Account].[BillingCity] Discrete Dimension: Billing Country Remote Column: [Account].[BillingCountry] Discrete Dimension: Billing State/Province Remote Column: [Account].[BillingState] Discrete Dimension: Sort By Discrete Dimension: Groups 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: Id (Account) Remote Column: [Account].[Id] Discrete Dimension: Industry Remote Column: [Account].[Industry] Discrete Dimension: Name (User) Remote Column: [Manager].[Name] Discrete Dimension: Opportunity ID Remote Column: [Opportunities].[Id] Discrete Dimension: Won Remote Column: [Opportunities].[IsWon] Continous Measure: % of Total Expected Value Continous Measure: Amount Remote Column: [Opportunities].[Amount] Discrete Measure: MIN Close Date Continous Measure: Expected Value Continous Measure: Sales + Pipeline Continous Measure: % of Total Amount Continous Measure: Expected Amount Remote Column: [Opportunities].[ExpectedRevenue] Discrete Measure: MAX Close Date Marks Mark: All Type: Automatic Label: <[Opportunities (Salesforce)].[Multiple Values]> of Total View Columns: [Opportunities (Salesforce)].[Measure Names()] Filters: [Opportunities (Salesforce)].[Measure Names()] [Opportunities (Salesforce)].[Action (Billing City,Billing Country)] [Opportunities (Salesforce)].[Action (Billing City,Billing Country,Billing State/Province)] [Opportunities (Salesforce)].[Action (Industry)] [Opportunities (Salesforce)].[Billing Country] [Opportunities (Salesforce)].[Sort By] [Opportunities (Salesforce)].[Groups] [Opportunities (Salesforce)].[Close Date] [Opportunities (Salesforce)].[Full Name] [Opportunities (Salesforce)].[Id (Account)] [Opportunities (Salesforce)].[Name (User)] Manual Sorting: [Opportunities (Salesforce)].[Measure Names()] ASC Slices: [Opportunities (Salesforce)].[Action (Billing City,Billing Country)] [Opportunities (Salesforce)].[Action (Industry)] [Opportunities (Salesforce)].[Billing Country] [Opportunities (Salesforce)].[Groups] [Opportunities (Salesforce)].[Close Date] [Opportunities (Salesforce)].[Full Name] [Opportunities (Salesforce)].[Name (User)] [Opportunities (Salesforce)].[Id (Account)] [Opportunities (Salesforce)].[Measure Names()] [Opportunities (Salesforce)].[Sort By] [Opportunities (Salesforce)].[Action (Billing City,Billing Country,Billing State/Province)] Styles Style: header [Opportunities (Salesforce)].[Measure Names()] height: 22 background-color: #ffffff rows band-color: #00000000 Style: label [Opportunities (Salesforce)].[Measure Names()] display: false text-align: center vertical-align: center font-family: Tableau Book color: #2cb5c0 font-size: 8 Style: pane rows band-color: #00000000 Style: table rows band-size: 1 Other background-color: #00000000 Style: worksheet Other font-family: Tableau Regular color: #333333 Style: table-div cols line-pattern-only: solid div-level: 1 stroke-size: 3 stroke-color: #f5f5f5 line-visibility: off rows line-visibility: off Style: header-div cols line-visibility: off Style: title Other background-color: #eef1f3 Worksheet: % Total 2 Visible: No Used Datasources Datasource: Parameters Continous Measure: Sort by N Datasource: Opportunities (Salesforce) Discrete Dimension: Billing City Remote Column: [Account].[BillingCity] Discrete Dimension: Billing Country Remote Column: [Account].[BillingCountry] Discrete Dimension: Billing State/Province Remote Column: [Account].[BillingState] Discrete Dimension: Sort By Discrete Dimension: Groups Discrete Dimension: Close Date Remote Column: [Opportunities].[CloseDate] Discrete Dimension: Closed Remote Column: [Opportunities].[IsClosed] Discrete Dimension: Full Name Remote Column: [Owned By].[Name] Discrete Dimension: Id (Account) Remote Column: [Account].[Id] Discrete Dimension: Industry Remote Column: [Account].[Industry] Discrete Dimension: Name (User) Remote Column: [Manager].[Name] Discrete Dimension: Opportunity ID Remote Column: [Opportunities].[Id] Discrete Dimension: Won Remote Column: [Opportunities].[IsWon] Continous Measure: % of Total Sales Continous Measure: Amount Remote Column: [Opportunities].[Amount] Continous Measure: Sales Continous Measure: Expected Amount Remote Column: [Opportunities].[ExpectedRevenue] Marks Mark: All Type: Automatic Label: <[Opportunities (Salesforce)].[SUM(% of Total Expected Value (copy))]> of Total View Filters: [Opportunities (Salesforce)].[Action (Billing City,Billing Country)] [Opportunities (Salesforce)].[Action (Billing City,Billing Country,Billing State/Province)] [Opportunities (Salesforce)].[Action (Industry)] [Opportunities (Salesforce)].[Billing Country] [Opportunities (Salesforce)].[Sort By] [Opportunities (Salesforce)].[Groups] [Opportunities (Salesforce)].[Close Date] [Opportunities (Salesforce)].[Full Name] [Opportunities (Salesforce)].[Id (Account)] [Opportunities (Salesforce)].[Name (User)] Slices: [Opportunities (Salesforce)].[Billing Country] [Opportunities (Salesforce)].[Groups] [Opportunities (Salesforce)].[Close Date] [Opportunities (Salesforce)].[Full Name] [Opportunities (Salesforce)].[Name (User)] [Opportunities (Salesforce)].[Id (Account)] [Opportunities (Salesforce)].[Action (Billing City,Billing Country)] [Opportunities (Salesforce)].[Action (Industry)] [Opportunities (Salesforce)].[Sort By] [Opportunities (Salesforce)].[Action (Billing City,Billing Country,Billing State/Province)] Styles Style: header rows band-color: #00000000 Style: pane rows band-color: #00000000 Style: table rows band-size: 1 Other background-color: #00000000 Style: worksheet Other font-family: Tableau Regular font-size: 8 color: #333333 Style: table-div cols line-pattern-only: solid div-level: 1 stroke-size: 3 stroke-color: #ffffff line-visibility: off rows line-visibility: off Style: header-div cols line-visibility: off Style: title Other background-color: #eef1f3 Worksheet: % Total 3 Visible: No Used Datasources Datasource: Parameters Continous Measure: Sort by N Datasource: Opportunities (Salesforce) Discrete Dimension: Billing City Remote Column: [Account].[BillingCity] Discrete Dimension: Billing Country Remote Column: [Account].[BillingCountry] Discrete Dimension: Billing State/Province Remote Column: [Account].[BillingState] Discrete Dimension: Sort By Discrete Dimension: Groups 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: Id (Account) Remote Column: [Account].[Id] Discrete Dimension: Industry Remote Column: [Account].[Industry] Discrete Dimension: Name (User) Remote Column: [Manager].[Name] Discrete Dimension: Opportunity ID Remote Column: [Opportunities].[Id] Discrete Dimension: Won Remote Column: [Opportunities].[IsWon] Continous Measure: % of Total Wins Continous Measure: % of Total Open Opp Discrete Measure: MIN Close Date Continous Measure: # of Wins Continous Measure: # Open Opp. Continous Measure: Expected Amount Remote Column: [Opportunities].[ExpectedRevenue] Discrete Measure: MAX Close Date Marks Mark: All Type: Automatic Label: <[Opportunities (Salesforce)].[Multiple Values]> of Total View Columns: [Opportunities (Salesforce)].[Measure Names()] Filters: [Opportunities (Salesforce)].[Measure Names()] [Opportunities (Salesforce)].[Action (Billing City,Billing Country)] [Opportunities (Salesforce)].[Action (Billing City,Billing Country,Billing State/Province)] [Opportunities (Salesforce)].[Action (Industry)] [Opportunities (Salesforce)].[Billing Country] [Opportunities (Salesforce)].[Sort By] [Opportunities (Salesforce)].[Groups] [Opportunities (Salesforce)].[Close Date] [Opportunities (Salesforce)].[Full Name] [Opportunities (Salesforce)].[Id (Account)] [Opportunities (Salesforce)].[Name (User)] Manual Sorting: [Opportunities (Salesforce)].[Measure Names()] ASC Slices: [Opportunities (Salesforce)].[Billing Country] [Opportunities (Salesforce)].[Groups] [Opportunities (Salesforce)].[Close Date] [Opportunities (Salesforce)].[Full Name] [Opportunities (Salesforce)].[Name (User)] [Opportunities (Salesforce)].[Id (Account)] [Opportunities (Salesforce)].[Measure Names()] [Opportunities (Salesforce)].[Action (Billing City,Billing Country)] [Opportunities (Salesforce)].[Action (Industry)] [Opportunities (Salesforce)].[Sort By] [Opportunities (Salesforce)].[Action (Billing City,Billing Country,Billing State/Province)] Styles Style: header [Opportunities (Salesforce)].[Measure Names()] height: 22 background-color: #ffffff rows band-color: #00000000 Style: label [Opportunities (Salesforce)].[Measure Names()] display: false text-align: center vertical-align: center font-family: Tableau Book color: #2cb5c0 font-size: 8 Style: pane rows band-color: #00000000 Style: table rows band-size: 1 Other background-color: #00000000 Style: worksheet Other font-family: Tableau Regular font-size: 8 color: #333333 Style: table-div rows line-visibility: off cols div-level: 1 stroke-size: 3 line-pattern-only: solid stroke-color: #f5f5f5 line-visibility: off Style: header-div cols stroke-color: #f5f5f5 line-visibility: on line-pattern-only: solid Style: title Other background-color: #eef1f3 Worksheet: Big Numbers 1 Visible: No Used Datasources Datasource: Parameters Continous Measure: Sort by N Datasource: Opportunities (Salesforce) Discrete Dimension: Billing City Remote Column: [Account].[BillingCity] Discrete Dimension: Billing Country Remote Column: [Account].[BillingCountry] Discrete Dimension: Billing State/Province Remote Column: [Account].[BillingState] Discrete Dimension: Sort By Discrete Dimension: Groups 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: Id (Account) Remote Column: [Account].[Id] Discrete Dimension: Industry Remote Column: [Account].[Industry] Discrete Dimension: Name (User) Remote Column: [Manager].[Name] Discrete Dimension: Opportunity ID Remote Column: [Opportunities].[Id] Discrete Dimension: Won Remote Column: [Opportunities].[IsWon] Continous Measure: Amount Remote Column: [Opportunities].[Amount] Discrete Measure: MIN Close Date Continous Measure: Expected Value Continous Measure: Sales + Pipeline Continous Measure: % of Total Amount Continous Measure: Expected Amount Remote Column: [Opportunities].[ExpectedRevenue] Discrete Measure: MAX Close Date Marks Mark: All Type: Automatic Label: <[Opportunities (Salesforce)].[Multiple Values]> View Columns: [Opportunities (Salesforce)].[Measure Names()] Filters: [Opportunities (Salesforce)].[Measure Names()] [Opportunities (Salesforce)].[Action (Billing City,Billing Country)] [Opportunities (Salesforce)].[Action (Billing City,Billing Country,Billing State/Province)] [Opportunities (Salesforce)].[Action (Industry)] [Opportunities (Salesforce)].[Billing Country] [Opportunities (Salesforce)].[Sort By] [Opportunities (Salesforce)].[Groups] [Opportunities (Salesforce)].[Close Date] [Opportunities (Salesforce)].[Full Name] [Opportunities (Salesforce)].[Id (Account)] [Opportunities (Salesforce)].[Name (User)] Manual Sorting: [Opportunities (Salesforce)].[Measure Names()] ASC Slices: [Opportunities (Salesforce)].[Action (Billing City,Billing Country)] [Opportunities (Salesforce)].[Action (Industry)] [Opportunities (Salesforce)].[Billing Country] [Opportunities (Salesforce)].[Groups] [Opportunities (Salesforce)].[Close Date] [Opportunities (Salesforce)].[Full Name] [Opportunities (Salesforce)].[Name (User)] [Opportunities (Salesforce)].[Id (Account)] [Opportunities (Salesforce)].[Measure Names()] [Opportunities (Salesforce)].[Sort By] [Opportunities (Salesforce)].[Action (Billing City,Billing Country,Billing State/Province)] Styles Style: cell [Opportunities (Salesforce)].[SUM(Expected Value)] text-format: c"$"#,##0;("$"#,##0) Style: header [Opportunities (Salesforce)].[Measure Names()] height: 23 background-color: #f2f2f3 rows band-color: #00000000 Style: label [Opportunities (Salesforce)].[Measure Names()] text-align: center vertical-align: center font-size: 9 font-family: Tableau Regular font-weight: normal color: #333333 Style: pane rows band-color: #00000000 Style: table rows band-size: 1 Other background-color: #00000000 Style: table-div cols line-visibility: on line-pattern-only: solid div-level: 1 stroke-size: 3 stroke-color: #e6e6e6 rows line-visibility: off Style: header-div cols line-visibility: on line-pattern-only: solid stroke-color: #e6e6e6 Style: title Other background-color: #eef1f3 Worksheet: Big Numbers 2 Visible: No Used Datasources Datasource: Parameters Continous Measure: Sort by N Datasource: Opportunities (Salesforce) Discrete Dimension: Billing City Remote Column: [Account].[BillingCity] Discrete Dimension: Billing Country Remote Column: [Account].[BillingCountry] Discrete Dimension: Billing State/Province Remote Column: [Account].[BillingState] Discrete Dimension: Sort By Discrete Dimension: Groups 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: Id (Account) Remote Column: [Account].[Id] Discrete Dimension: Industry Remote Column: [Account].[Industry] Discrete Dimension: Name (User) Remote Column: [Manager].[Name] Discrete Dimension: Opportunity ID Remote Column: [Opportunities].[Id] Discrete Dimension: Won Remote Column: [Opportunities].[IsWon] Continous Measure: % of Total Open Opp Discrete Measure: MIN Close Date Continous Measure: # of Wins Continous Measure: # Open Opp. Continous Measure: Expected Amount Remote Column: [Opportunities].[ExpectedRevenue] Discrete Measure: MAX Close Date Marks Mark: All Type: Automatic Label: <[Opportunities (Salesforce)].[Multiple Values]> View Columns: [Opportunities (Salesforce)].[Measure Names()] Filters: [Opportunities (Salesforce)].[Measure Names()] [Opportunities (Salesforce)].[Action (Billing City,Billing Country)] [Opportunities (Salesforce)].[Action (Billing City,Billing Country,Billing State/Province)] [Opportunities (Salesforce)].[Action (Industry)] [Opportunities (Salesforce)].[Billing Country] [Opportunities (Salesforce)].[Sort By] [Opportunities (Salesforce)].[Groups] [Opportunities (Salesforce)].[Close Date] [Opportunities (Salesforce)].[Full Name] [Opportunities (Salesforce)].[Id (Account)] [Opportunities (Salesforce)].[Name (User)] Manual Sorting: [Opportunities (Salesforce)].[Measure Names()] ASC Slices: [Opportunities (Salesforce)].[Billing Country] [Opportunities (Salesforce)].[Groups] [Opportunities (Salesforce)].[Close Date] [Opportunities (Salesforce)].[Full Name] [Opportunities (Salesforce)].[Name (User)] [Opportunities (Salesforce)].[Id (Account)] [Opportunities (Salesforce)].[Measure Names()] [Opportunities (Salesforce)].[Action (Billing City,Billing Country)] [Opportunities (Salesforce)].[Action (Industry)] [Opportunities (Salesforce)].[Sort By] [Opportunities (Salesforce)].[Action (Billing City,Billing Country,Billing State/Province)] Styles Style: header [Opportunities (Salesforce)].[Measure Names()] height: 27 background-color: #f2f2f3 rows band-color: #00000000 Style: label [Opportunities (Salesforce)].[Measure Names()] text-align: center vertical-align: center font-size: 8 font-family: Tableau Regular color: #333333 font-weight: normal Style: pane rows band-color: #00000000 Style: table rows band-size: 1 Other background-color: #00000000 Style: gridline Other line-visibility: on line-pattern-only: solid stroke-size: 4 Style: table-div cols div-level: 1 line-visibility: on line-pattern-only: solid stroke-size: 3 stroke-color: #e6e6e6 rows line-visibility: off Style: header-div cols line-visibility: on line-pattern-only: solid stroke-color: #e6e6e6 Style: title Other background-color: #eef1f3 Worksheet: Big Numbers 3 Visible: No Used Datasources Datasource: Parameters Continous Measure: Sort by N Datasource: Opportunities (Salesforce) Discrete Dimension: Billing City Remote Column: [Account].[BillingCity] Discrete Dimension: Billing Country Remote Column: [Account].[BillingCountry] Discrete Dimension: Billing State/Province Remote Column: [Account].[BillingState] Discrete Dimension: Sort By Discrete Dimension: Groups 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: Id (Account) Remote Column: [Account].[Id] Discrete Dimension: Industry Remote Column: [Account].[Industry] Discrete Dimension: Name (User) Remote Column: [Manager].[Name] Discrete Dimension: Opportunity ID Remote Column: [Opportunities].[Id] Discrete Dimension: Won Remote Column: [Opportunities].[IsWon] Continous Measure: Amount Remote Column: [Opportunities].[Amount] Discrete Measure: MIN Close Date Continous Measure: Expected Value Continous Measure: Win Rate Continous Measure: # of Wins Continous Measure: # of Accounts Continous Measure: Sales Continous Measure: # Open Opp. Continous Measure: Expected Amount Remote Column: [Opportunities].[ExpectedRevenue] Discrete Measure: MAX Close Date Marks Mark: All Type: Automatic Label: <[Opportunities (Salesforce)].[Multiple Values]> View Columns: [Opportunities (Salesforce)].[Measure Names()] Filters: [Opportunities (Salesforce)].[Measure Names()] [Opportunities (Salesforce)].[Action (Billing City,Billing Country)] [Opportunities (Salesforce)].[Action (Billing City,Billing Country,Billing State/Province)] [Opportunities (Salesforce)].[Action (Industry)] [Opportunities (Salesforce)].[Billing Country] [Opportunities (Salesforce)].[Sort By] [Opportunities (Salesforce)].[Groups] [Opportunities (Salesforce)].[Close Date] [Opportunities (Salesforce)].[Full Name] [Opportunities (Salesforce)].[Id (Account)] [Opportunities (Salesforce)].[Name (User)] Manual Sorting: [Opportunities (Salesforce)].[Measure Names()] ASC Slices: [Opportunities (Salesforce)].[Billing Country] [Opportunities (Salesforce)].[Groups] [Opportunities (Salesforce)].[Close Date] [Opportunities (Salesforce)].[Full Name] [Opportunities (Salesforce)].[Name (User)] [Opportunities (Salesforce)].[Id (Account)] [Opportunities (Salesforce)].[Measure Names()] [Opportunities (Salesforce)].[Action (Billing City,Billing Country)] [Opportunities (Salesforce)].[Action (Industry)] [Opportunities (Salesforce)].[Sort By] [Opportunities (Salesforce)].[Action (Billing City,Billing Country,Billing State/Province)] Styles Style: cell [Opportunities (Salesforce)].[SUM(Sales)] text-format: c"$"#,##0;("$"#,##0) [Opportunities (Salesforce)].[SUM(Expected Value)] text-format: c"$"#,##0;("$"#,##0) Style: header [Opportunities (Salesforce)].[Measure Names()] height: 27 background-color: #f2f2f3 rows band-color: #00000000 Style: label [Opportunities (Salesforce)].[Measure Names()] text-align: center vertical-align: center font-size: 8 font-family: Tableau Regular color: #333333 font-weight: normal Style: pane rows band-color: #00000000 Style: table rows band-size: 1 Other background-color: #00000000 Style: gridline Other line-visibility: on line-pattern-only: solid stroke-size: 4 Style: table-div cols div-level: 1 line-visibility: on line-pattern-only: solid stroke-size: 3 stroke-color: #e6e6e6 rows line-visibility: off Style: header-div rows stroke-size: 3 line-pattern-only: solid stroke-color: #ffffff line-visibility: off cols line-visibility: on line-pattern-only: solid stroke-color: #e6e6e6 Style: title Other background-color: #eef1f3 Worksheet: Big Numbers 4 Visible: No Used Datasources Datasource: Parameters Continous Measure: Sort by N Datasource: Opportunities (Salesforce) Discrete Dimension: Billing City Remote Column: [Account].[BillingCity] Discrete Dimension: Billing Country Remote Column: [Account].[BillingCountry] Discrete Dimension: Billing State/Province Remote Column: [Account].[BillingState] Discrete Dimension: Sort By Discrete Dimension: Groups Discrete Dimension: Close Date Remote Column: [Opportunities].[CloseDate] Discrete Dimension: Closed Remote Column: [Opportunities].[IsClosed] Discrete Dimension: Full Name Remote Column: [Owned By].[Name] Discrete Dimension: Id (Account) Remote Column: [Account].[Id] Discrete Dimension: Industry Remote Column: [Account].[Industry] Discrete Dimension: Name (User) Remote Column: [Manager].[Name] Discrete Dimension: Opportunity ID Remote Column: [Opportunities].[Id] Discrete Dimension: Won Remote Column: [Opportunities].[IsWon] Continous Measure: Amount Remote Column: [Opportunities].[Amount] Continous Measure: Sales Continous Measure: Expected Amount Remote Column: [Opportunities].[ExpectedRevenue] Marks Mark: All Type: Automatic Label: <[Opportunities (Salesforce)].[SUM(Sales)]> View Filters: [Opportunities (Salesforce)].[Action (Billing City,Billing Country)] [Opportunities (Salesforce)].[Action (Billing City,Billing Country,Billing State/Province)] [Opportunities (Salesforce)].[Action (Industry)] [Opportunities (Salesforce)].[Billing Country] [Opportunities (Salesforce)].[Sort By] [Opportunities (Salesforce)].[Groups] [Opportunities (Salesforce)].[Close Date] [Opportunities (Salesforce)].[Full Name] [Opportunities (Salesforce)].[Id (Account)] [Opportunities (Salesforce)].[Name (User)] Slices: [Opportunities (Salesforce)].[Billing Country] [Opportunities (Salesforce)].[Groups] [Opportunities (Salesforce)].[Close Date] [Opportunities (Salesforce)].[Full Name] [Opportunities (Salesforce)].[Name (User)] [Opportunities (Salesforce)].[Id (Account)] [Opportunities (Salesforce)].[Action (Billing City,Billing Country)] [Opportunities (Salesforce)].[Action (Industry)] [Opportunities (Salesforce)].[Sort By] [Opportunities (Salesforce)].[Action (Billing City,Billing Country,Billing State/Province)] Styles Style: cell [Opportunities (Salesforce)].[SUM(Sales)] text-format: c"$"#,##0;("$"#,##0) Style: header rows band-color: #00000000 border-style: none Style: pane rows band-color: #00000000 border-style: none Style: table rows band-size: 1 Other background-color: #00000000 Style: table-div cols stroke-size: 5 line-pattern-only: solid stroke-color: #f5f5f5 div-level: 1 line-visibility: off rows line-visibility: off Style: header-div cols line-visibility: off Style: title Other background-color: #f2f2f3 Worksheet: Breakdown by Industry Visible: No Used Datasources Datasource: Parameters Continous Measure: Sort by N Discrete Measure: Pick a Measure 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: Billing State/Province Remote Column: [Account].[BillingState] Discrete Dimension: Sort By Discrete Dimension: Groups Discrete Dimension: Close Date Remote Column: [Opportunities].[CloseDate] Discrete Dimension: Closed Remote Column: [Opportunities].[IsClosed] Discrete Dimension: Full Name Remote Column: [Owned By].[Name] Discrete Dimension: Id (Account) Remote Column: [Account].[Id] Discrete Dimension: Industry Remote Column: [Account].[Industry] Discrete Dimension: Name (User) Remote Column: [Manager].[Name] Discrete Dimension: Opportunity ID Remote Column: [Opportunities].[Id] Discrete Dimension: Won Remote Column: [Opportunities].[IsWon] Continous Measure: Amount Remote Column: [Opportunities].[Amount] Continous Measure: Pick a Measure Control Continous Measure: Amount (Excl Closed) Continous Measure: Expected Amount Remote Column: [Opportunities].[ExpectedRevenue] Marks Mark: All Type: Automatic Tooltip: <[Opportunities (Salesforce)].[Industry]> <[Opportunities (Salesforce)].[Groups]>: <[Opportunities (Salesforce)].[SUM(Amount)]> Number of Opportunities: <[Opportunities (Salesforce)].[Opportunity ID]> Mark: [Opportunities (Salesforce)].[Opportunity ID] Type: Bar Tooltip: <[Opportunities (Salesforce)].[Industry]> <[Opportunities (Salesforce)].[Groups]>: <[Opportunities (Salesforce)].[SUM(Amount)]> Number of Opportunities: <[Opportunities (Salesforce)].[Opportunity ID]> Mark: [Opportunities (Salesforce)].[Opportunity ID] Type: Circle Tooltip: <[Opportunities (Salesforce)].[Industry]> <[Opportunities (Salesforce)].[Groups]>: <[Opportunities (Salesforce)].[SUM(Amount)]> Number of Opportunities: <[Opportunities (Salesforce)].[Opportunity ID]> View Rows: [Opportunities (Salesforce)].[Industry] Columns: [Opportunities (Salesforce)].[Groups] ([Opportunities (Salesforce)].[Opportunity ID] [Opportunities (Salesforce)].[Opportunity ID])) Filters: [Opportunities (Salesforce)].[Action (Billing City,Billing Country)] [Opportunities (Salesforce)].[Action (Billing City,Billing Country,Billing State/Province)] [Opportunities (Salesforce)].[Action (Billing Country)] [Opportunities (Salesforce)].[Account Name] [Opportunities (Salesforce)].[Billing Country] [Opportunities (Salesforce)].[Sort By] [Opportunities (Salesforce)].[Groups] [Opportunities (Salesforce)].[Close Date] [Opportunities (Salesforce)].[Full Name] [Opportunities (Salesforce)].[Id (Account)] [Opportunities (Salesforce)].[Industry] [Opportunities (Salesforce)].[Industry] [Opportunities (Salesforce)].[Name (User)] Slices: [Opportunities (Salesforce)].[Billing Country] [Opportunities (Salesforce)].[Groups] [Opportunities (Salesforce)].[Close Date] [Opportunities (Salesforce)].[Full Name] [Opportunities (Salesforce)].[Name (User)] [Opportunities (Salesforce)].[Sort By] [Opportunities (Salesforce)].[Industry] [Opportunities (Salesforce)].[Id (Account)] [Opportunities (Salesforce)].[Action (Billing Country)] [Opportunities (Salesforce)].[Account Name] [Opportunities (Salesforce)].[Action (Billing City,Billing Country)] [Opportunities (Salesforce)].[Action (Billing City,Billing Country,Billing State/Province)] Styles Style: axis [Opportunities (Salesforce)].[Opportunity ID] auto-subtitle: true display: false height: 28 Style: cell [Opportunities (Salesforce)].[Industry] height: 25 Style: header [Opportunities (Salesforce)].[Industry] width: 140 [Opportunities (Salesforce)].[Groups] height: 38 Style: label [Opportunities (Salesforce)].[Industry] font-family: Tableau Book font-weight: normal [Opportunities (Salesforce)].[Opportunity ID] font-family: Tableau Book [Opportunities (Salesforce)].[Groups] font-family: Tableau Regular font-weight: normal font-size: 9 Style: worksheet rows display-field-labels: false cols display-field-labels: false Style: refline refline0 line-visibility: on line-pattern-only: dotted stroke-color: #f28e2b67 fill-above: #00000000 fill-below: #00000000 font-size: 6 font-family: Tableau Bold refline1 line-visibility: on line-pattern-only: dotted stroke-color: #f28e2b67 fill-above: #00000000 fill-below: #00000000 font-size: 6 font-family: Tableau Bold line-visibility: on line-pattern-only: dotted stroke-color: #f28e2b67 fill-above: #00000000 fill-below: #00000000 font-size: 6 font-family: Tableau Bold Style: gridline Other stroke-size: 5 stroke-color: #f5f5f5 line-visibility: on line-pattern-only: solid rows line-visibility: off Style: zeroline Other line-visibility: on line-pattern-only: solid stroke-color: #e6e6e6 Style: table-div cols line-visibility: off rows stroke-color: #f5f5f5 div-level: 1 line-visibility: on line-pattern-only: solid stroke-size: 3 Style: header-div cols line-visibility: on line-pattern-only: solid stroke-color: #e6e6e6 stroke-size: 1 rows line-visibility: on line-pattern-only: solid Style: title Other background-color: #f2f2f3 Style: quick-filter [Opportunities (Salesforce)].[Full Name] title: Salesperson Other font-family: Tableau Book Style: quick-filter-title Other font-family: Tableau Regular font-size: 8 font-weight: normal Worksheet: City Visible: No Used Datasources Datasource: Parameters Continous Measure: Sort by N Discrete Measure: Pick a Measure 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: Billing State/Province Remote Column: [Account].[BillingState] Discrete Dimension: Sort By Discrete Dimension: Groups Discrete Dimension: Close Date Remote Column: [Opportunities].[CloseDate] Discrete Dimension: Closed Remote Column: [Opportunities].[IsClosed] Discrete Dimension: Description Remote Column: [UserRole].[RollupDescription] Discrete Dimension: Full Name Remote Column: [Owned By].[Name] Discrete Dimension: Id (Account) Remote Column: [Account].[Id] Discrete Dimension: Industry Remote Column: [Account].[Industry] Discrete Dimension: Name (User) Remote Column: [Manager].[Name] Discrete Dimension: Opportunity ID Remote Column: [Opportunities].[Id] Discrete Dimension: Won Remote Column: [Opportunities].[IsWon] Continous Measure: Amount Remote Column: [Opportunities].[Amount] Continous Measure: Pick a Measure Control Continous Measure: Amount (Excl Closed) Continous Measure: Expected Amount Remote Column: [Opportunities].[ExpectedRevenue] Marks Mark: All Type: Circle Tooltip: <[Opportunities (Salesforce)].[Billing City]> | <[Opportunities (Salesforce)].[Billing Country]> <[Parameters].[Parameter 1]>: <[Opportunities (Salesforce)].[SUM(Pick a Measure Control)]> Number of Opportunities: <[Opportunities (Salesforce)].[Opportunity ID]> View Rows: [Opportunities (Salesforce)].[Latitude (generated)] Columns: [Opportunities (Salesforce)].[Longitude (generated)] Filters: [Opportunities (Salesforce)].[Action (Industry)] [Opportunities (Salesforce)].[Account Name] [Opportunities (Salesforce)].[Billing Country] [Opportunities (Salesforce)].[Sort By] [Opportunities (Salesforce)].[Groups] [Opportunities (Salesforce)].[Close Date] [Opportunities (Salesforce)].[Description] [Opportunities (Salesforce)].[Full Name] [Opportunities (Salesforce)].[Id (Account)] [Opportunities (Salesforce)].[Industry] [Opportunities (Salesforce)].[Name (User)] Slices: [Opportunities (Salesforce)].[Billing Country] [Opportunities (Salesforce)].[Groups] [Opportunities (Salesforce)].[Close Date] [Opportunities (Salesforce)].[Full Name] [Opportunities (Salesforce)].[Name (User)] [Opportunities (Salesforce)].[Industry] [Opportunities (Salesforce)].[Id (Account)] [Opportunities (Salesforce)].[Account Name] [Opportunities (Salesforce)].[Description] [Opportunities (Salesforce)].[Action (Industry)] [Opportunities (Salesforce)].[Sort By] Styles Style: label [Opportunities (Salesforce)].[SUM(Pick a Measure Control)] text-format: C1033% Style: pane Other border-style: none Style: table Other show-null-value-warning: false Style: table-div cols line-visibility: off rows line-visibility: off Style: title Other background-color: #f2f2f3 Style: map-layer tab_base enabled: true um_lcover enabled: false tab_coastline enabled: false 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: true 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.0 map-style: tableau-light-gray Style: map-data-layer Other palette: tableau-map-blue-green-light Style: quick-filter [Opportunities (Salesforce)].[Billing Country] title: Country Other font-family: Tableau Light Style: quick-filter-title Other font-size: 8 font-weight: normal font-family: Tableau Regular Worksheet: Manager Name 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: Billing State/Province Remote Column: [Account].[BillingState] Discrete Dimension: Industry Remote Column: [Account].[Industry] Discrete Dimension: Name (User) Remote Column: [Manager].[Name] Discrete Measure: Show Manager Marks Mark: All Type: Automatic Label: <[Opportunities (Salesforce)].[Show Manager]> View Filters: [Opportunities (Salesforce)].[Action (Billing City,Billing Country)] [Opportunities (Salesforce)].[Action (Billing City,Billing Country,Billing State/Province)] [Opportunities (Salesforce)].[Action (Industry)] [Opportunities (Salesforce)].[Name (User)] Slices: [Opportunities (Salesforce)].[Name (User)] [Opportunities (Salesforce)].[Action (Billing City,Billing Country)] [Opportunities (Salesforce)].[Action (Industry)] [Opportunities (Salesforce)].[Action (Billing City,Billing Country,Billing State/Province)] 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: Sheet 1 Visible: No Marks Mark: All Type: Automatic View Worksheet: Sheet 15 Visible: No Marks Mark: All Type: Automatic View Worksheet: Summary of Accounts Visible: No Used Datasources Datasource: Parameters Continous Measure: Sort by N Datasource: Opportunities (Salesforce) Discrete Dimension: Billing City Remote Column: [Account].[BillingCity] Discrete Dimension: Billing Country Remote Column: [Account].[BillingCountry] Discrete Dimension: Billing State/Province Remote Column: [Account].[BillingState] Discrete Dimension: Sort By Discrete Dimension: Groups Discrete Dimension: Close Date Remote Column: [Opportunities].[CloseDate] Discrete Dimension: Closed Remote Column: [Opportunities].[IsClosed] Discrete Dimension: Full Name Remote Column: [Owned By].[Name] Discrete Dimension: Industry Remote Column: [Account].[Industry] Discrete Dimension: Name (User) Remote Column: [Manager].[Name] Discrete Dimension: Won Remote Column: [Opportunities].[IsWon] Discrete Measure: MIN Close Date Discrete Measure: MAX Close Date Marks Mark: All Type: Automatic Label: Summary of Accounts | <[Opportunities (Salesforce)].[MIN Close Date]> to <[Opportunities (Salesforce)].[MIN Close Date (copy)]> View Filters: [Opportunities (Salesforce)].[Action (Billing City,Billing Country)] [Opportunities (Salesforce)].[Action (Billing City,Billing Country,Billing State/Province)] [Opportunities (Salesforce)].[Action (Industry)] [Opportunities (Salesforce)].[Billing Country] [Opportunities (Salesforce)].[Sort By] [Opportunities (Salesforce)].[Groups] [Opportunities (Salesforce)].[Close Date] [Opportunities (Salesforce)].[Full Name] [Opportunities (Salesforce)].[Name (User)] Slices: [Opportunities (Salesforce)].[Billing Country] [Opportunities (Salesforce)].[Groups] [Opportunities (Salesforce)].[Close Date] [Opportunities (Salesforce)].[Full Name] [Opportunities (Salesforce)].[Name (User)] [Opportunities (Salesforce)].[Action (Billing City,Billing Country)] [Opportunities (Salesforce)].[Action (Industry)] [Opportunities (Salesforce)].[Sort By] [Opportunities (Salesforce)].[Action (Billing City,Billing Country,Billing State/Province)] Styles Style: header [Opportunities (Salesforce)].[Measure Names()] background-color: #ffffff rows band-color: #00000000 Style: label [Opportunities (Salesforce)].[Measure Names()] text-align: center vertical-align: center font-family: Tableau Book color: #2cb5c0 font-size: 8 Style: pane rows band-color: #00000000 Other border-style: none Style: table rows band-size: 1 Other background-color: #00000000 Style: table-div cols stroke-size: 5 line-pattern-only: solid div-level: 1 stroke-color: #f5f5f5 line-visibility: off rows line-visibility: off Style: title Other background-color: #f2f2f3 Worksheet: Tooltip - Breakdown by Opportunity Visible: No Used Datasources Datasource: Parameters Continous Measure: Sort by N Discrete Measure: Pick a Measure Datasource: Opportunities (Salesforce) Discrete Dimension: Account Name Remote Column: [Account].[Name] Discrete Dimension: AccountId (Opportunities) Remote Column: [Opportunities].[AccountId] Discrete Dimension: Sort By Discrete Dimension: Groups Discrete Dimension: Closed Remote Column: [Opportunities].[IsClosed] Discrete Dimension: Id (Account) Remote Column: [Account].[Id] Discrete Dimension: Name (Opportunities) Remote Column: [Opportunities].[Name] Discrete Dimension: Won Remote Column: [Opportunities].[IsWon] Continous Measure: Amount Remote Column: [Opportunities].[Amount] Continous Measure: Pick a Measure Control Continous Measure: Amount (Excl Closed) Continous Measure: Expected Amount Remote Column: [Opportunities].[ExpectedRevenue] Marks Mark: All Type: Automatic View Rows: [Opportunities (Salesforce)].[Name (Opportunities)] Columns: [Opportunities (Salesforce)].[SUM(Pick a Measure Control)] Filters: [Opportunities (Salesforce)].[Tooltip (Account Name,AccountId (Opportunities),Groups,Id (Account),Name (Opportunities))] [Opportunities (Salesforce)].[Tooltip (Account Name,Groups,Id (Account))] [Opportunities (Salesforce)].[Tooltip (Account Name,Groups,Id (Account),Name (Opportunities))] [Opportunities (Salesforce)].[Tooltip (Account Name,Sort By,Groups,Id (Account))] Slices: [Opportunities (Salesforce)].[Tooltip (Account Name,Groups,Id (Account))] [Opportunities (Salesforce)].[Tooltip (Account Name,Groups,Id (Account),Name (Opportunities))] [Opportunities (Salesforce)].[Tooltip (Account Name,AccountId (Opportunities),Groups,Id (Account),Name (Opportunities))] [Opportunities (Salesforce)].[Tooltip (Account Name,Sort By,Groups,Id (Account))] Styles Style: axis Other line-visibility: on line-pattern-only: solid stroke-size: 3 stroke-color: #e6e6e6 cols line-visibility: off [Opportunities (Salesforce)].[SUM(Pick a Measure Control)] auto-subtitle: true Style: header [Opportunities (Salesforce)].[Name (Opportunities)] width: 192 Style: label [Opportunities (Salesforce)].[Name (Opportunities)] font-weight: normal Style: pane Other border-style: none Style: worksheet rows display-field-labels: false Other font-family: Tableau Book Style: gridline Other stroke-size: 4 line-visibility: on line-pattern-only: solid cols line-visibility: on line-pattern-only: solid rows line-visibility: off Style: zeroline Other stroke-size: 4 line-visibility: off Style: table-div rows line-visibility: off cols line-visibility: off Worksheet: Tooltip - Opportunities by Value and Month Visible: No Used Datasources Datasource: Parameters Continous Measure: Sort by N Discrete Measure: Pick a Measure Datasource: Opportunities (Salesforce) Discrete Dimension: Account Name Remote Column: [Account].[Name] Discrete Dimension: AccountId (Opportunities) Remote Column: [Opportunities].[AccountId] Discrete Dimension: Sort By Discrete Dimension: Groups Discrete Dimension: Close Date Remote Column: [Opportunities].[CloseDate] Discrete Dimension: Closed Remote Column: [Opportunities].[IsClosed] Discrete Dimension: Id (Account) Remote Column: [Account].[Id] Discrete Dimension: Won Remote Column: [Opportunities].[IsWon] Continous Measure: Amount Remote Column: [Opportunities].[Amount] Continous Measure: 0 Continous Measure: Pick a Measure Control Continous Measure: Amount (Excl Closed) Continous Measure: Expected Amount Remote Column: [Opportunities].[ExpectedRevenue] Marks Mark: All Type: Circle View Rows: [Opportunities (Salesforce)].[YEAR(Close Date)] [Opportunities (Salesforce)].[SUM(0)] Columns: [Opportunities (Salesforce)].[MONTH(Close Date)] Filters: [Opportunities (Salesforce)].[Tooltip (Account Name,Sort By,Groups,Id (Account))] [Opportunities (Salesforce)].[Groups] Slices: [Opportunities (Salesforce)].[Tooltip (Account Name,Sort By,Groups,Id (Account))] [Opportunities (Salesforce)].[Groups] Styles Style: axis [Opportunities (Salesforce)].[SUM(0)] display: false Style: header [Opportunities (Salesforce)].[YEAR(Close Date)] background-color: #eef1f3 Style: label [Opportunities (Salesforce)].[YEAR(Close Date)] font-family: Tableau Bold text-align: center [Opportunities (Salesforce)].[MONTH(Close Date)] text-format: iLLL font-family: Tableau Book font-weight: normal Style: table Other show-null-value-warning: false Style: worksheet cols display-field-labels: false rows display-field-labels: false Style: gridline Other stroke-size: 4 line-visibility: on line-pattern-only: solid Style: zeroline Other stroke-size: 2 line-visibility: on line-pattern-only: dotted stroke-color: #666666 rows stroke-color: #b4b4b4 stroke-size: 2 Style: table-div rows stroke-size: 3 stroke-color: #e6e6e6 Style: header-div rows stroke-size: 5 stroke-color: #ffffff Worksheet: Top Visible: No Used Datasources Datasource: Parameters Continous Measure: Sort by N Discrete Measure: Pick a Measure 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: Billing State/Province Remote Column: [Account].[BillingState] Discrete Dimension: Sort By Discrete Dimension: Groups Discrete Dimension: Close Date Remote Column: [Opportunities].[CloseDate] Discrete Dimension: Closed Remote Column: [Opportunities].[IsClosed] Discrete Dimension: Full Name Remote Column: [Owned By].[Name] Discrete Dimension: Id (Account) Remote Column: [Account].[Id] Discrete Dimension: Industry Remote Column: [Account].[Industry] Discrete Dimension: Name (User) Remote Column: [Manager].[Name] Discrete Dimension: Won Remote Column: [Opportunities].[IsWon] Continous Measure: Amount Remote Column: [Opportunities].[Amount] Continous Measure: Pick a Measure Control Continous Measure: Amount (Excl Closed) Continous Measure: Expected Amount Remote Column: [Opportunities].[ExpectedRevenue] Marks Mark: All Type: Automatic Tooltip: <[Opportunities (Salesforce)].[Account Name]> <[Opportunities (Salesforce)].[Groups]>: <[Opportunities (Salesforce)].[SUM(Pick a Measure Control)]> Opportunities: Breakdown by Month/Year: View Rows: [Opportunities (Salesforce)].[Id (Account)] [Opportunities (Salesforce)].[Account Name] Columns: [Opportunities (Salesforce)].[SUM(Pick a Measure Control)] Filters: [Opportunities (Salesforce)].[Action (Billing City,Billing Country)] [Opportunities (Salesforce)].[Action (Billing City,Billing Country,Billing State/Province)] [Opportunities (Salesforce)].[Action (Industry)] [Opportunities (Salesforce)].[Billing Country] [Opportunities (Salesforce)].[Groups] [Opportunities (Salesforce)].[Close Date] [Opportunities (Salesforce)].[Full Name] [Opportunities (Salesforce)].[Id (Account)] [Opportunities (Salesforce)].[Id (Account)] [Opportunities (Salesforce)].[Name (User)] Manual Sorting: [Opportunities (Salesforce)].[Groups] ASC Slices: [Opportunities (Salesforce)].[Action (Billing City,Billing Country)] [Opportunities (Salesforce)].[Action (Industry)] [Opportunities (Salesforce)].[Billing Country] [Opportunities (Salesforce)].[Close Date] [Opportunities (Salesforce)].[Full Name] [Opportunities (Salesforce)].[Name (User)] [Opportunities (Salesforce)].[Id (Account)] [Opportunities (Salesforce)].[Action (Billing City,Billing Country,Billing State/Province)] Styles Style: axis [Opportunities (Salesforce)].[SUM(Pick a Measure Control)] auto-subtitle: true Other line-visibility: on line-pattern-only: solid stroke-size: 5 stroke-color: #f5f5f5 rows tick-color: #00000000 line-visibility: on line-pattern-only: solid cols line-visibility: off tick-color: #00000000 Style: cell [Opportunities (Salesforce)].[Account Name] height: 29 Style: header [Opportunities (Salesforce)].[Account Name] width: 208 Style: label [Opportunities (Salesforce)].[Id (Account)] display: false Style: worksheet rows display-field-labels: false Other font-family: Tableau Book Style: gridline Other stroke-size: 4 line-visibility: on line-pattern-only: solid stroke-color: #f5f5f5 rows line-visibility: off Style: table-div cols line-visibility: off rows div-level: 2 line-pattern-only: solid stroke-color: #f5f5f5 line-visibility: off Style: header-div rows line-visibility: on line-pattern-only: solid stroke-size: 1 Style: title Other background-color: #f2f2f3 Style: quick-filter [Opportunities (Salesforce)].[Name (User)] title: Manager Other font-weight: normal Style: quick-filter-title Other font-family: Tableau Regular font-weight: normal font-size: 8