2 Replies Latest reply on Nov 8, 2018 3:49 PM by Tina Crouse

    Multiple hyperlinks for a single dimension on each value of the dimension

    Tina Crouse

      I have created a table of contents dashboard and instead of creating a single sheet per my 15 hyperlinks and going through floating them to the right of each line of my table of contents so show here is the hyperlink for this view and here is the different hyperlink for this view, I want to have one data source as an Excel and put the URL in the Excel as a hyperlink. Connect to that with Tableau and have it show the hyperlink drag it to the label shelf so I end up with the attached example but can alias the hyperlink to the name of the dashboard and when using clicks it takes them to that dashboard. Is that possible? The dashboard would look similar to the below but I would alias anything in the link to views. Like the first would look like hyperlink but say Denials & Referrals. If not then I have to do 15 separate sheets I guess and floating the sheet under the link to views

       

       

       

       

       

      Dashboard
        Name
      Dashboard Summary DetailsLink to Views
      A. Denials
        & Referrals
      Total service lines;
        overall denied; authorizations sent to an MD; and authorizations denied by an
        MD for all lines of business
      https://tableauprod.anthem.com/#/site/EntTab/views/OPHCMExecutiveDashboard_0/DenialsReferrals=1
      B. Auth ChexValidation for
        authorization accuracy for GBD
      https://tableauprod.anthem.com/#/site/EntTab/views/OPHCMExecutiveDashboard_0/AuthChex?:iid=1
      C. MD ReviewsDaily average for MD
        authorizations for all lines of business
      https://tableauprod.anthem.com/#/site/EntTab/views/OPHCMExecutiveDashboard_0/MDReviews?:iid=1
      D. GBD Peer to
        Peer
      Daily average for MD
        peer to peer reviews for GBD
      https://tableauprod.anthem.com/#/site/EntTab/views/OPHCMExecutiveDashboard_0/GBDPeertoPeer?:iid=1
      E. TAT
        Compliance
      Turn around time for
        compliance for all lines of business
      https://tableauprod.anthem.com/#/site/EntTab/views/OPHCMExecutiveDashboard_0/TATCompliance?:iid=1
      F. Finance
        & Claims Metrics
      Cost per visit and
        PMPM year to date or rolling 12 months for all lines of business
      https://tableauprod.anthem.com/#/site/EntTab/views/OPHCMExecutiveDashboard_0/FinanceClaimsMetrics?:iid=1
      G.
        Transformation
      Cost saving
        initiatives across multiple cost categories for all lines of business
      https://tableauprod.anthem.com/#/site/EntTab/views/OPHCMExecutiveDashboard_0/Transformation?:iid=1
      H.
        Transformation SubWorkstream
      Cost saving
        initiatives drill down by market. Use in conjunction with the Transformation
        dashboard
      No link supplied.
        Transformation SubWorkstream works in conjunction with Transformation view
      I. MembershipMembership counts for
        all lines of business
      https://tableauprod.anthem.com/#/site/EntTab/views/OPHCMExecutiveDashboard_0/Membership?:iid=1
      J. AppealsPre-auth appeals for
        all lines of business
      https://tableauprod.anthem.com/#/site/EntTab/views/OPHCMExecutiveDashboard_0/Appeals?:iid=1
      K. Provider
        Dashboard
      NonPar visits;
        allowed amounts; and nonpar amounts for all lines of business
      https://tableauprod.anthem.com/#/site/EntTab/views/OPHCMExecutiveDashboard_0/ProviderDashboard?:iid=1
      L. Provider
        Top5 GBD NonPar
      Top5 GBD NonPar
        provider visits; allowed amounts; and nonpar amounts for GBD Medicare
      https://tableauprod.anthem.com/#/site/EntTab/views/OPHCMExecutiveDashboard_0/ProviderTop5GBDNONPAR?:iid=1
      M. Top5 GBD
        NonPar Providers
      Top5 GBD provider
        names and nonpar amounts for GBD Medicare
      https://tableauprod.anthem.com/#/site/EntTab/views/OPHCMExecutiveDashboard_0/Top5GBDNONPARProviders?:iid=1
      N. GlossarySource report links;
        refresh schedules; and definitions of key metrics
      https://tableauprod.anthem.com/#/site/EntTab/views/OPHCMExecutiveDashboard_0/Glossary?:iid=1
      O. Report
        Reference
      Inclusions;
        exclusions; and notes pertaining to each dashboard
      https://tableauprod.anthem.com/#/site/EntTab/views/OPHCMExecutiveDashboard_0/ReportReference?:iid=1