6 Replies Latest reply on Nov 28, 2018 2:48 AM by Christian Go

    metric rank by country by global

    Christian Go

      I have below sample data:

       

         

      CountrySiteCostVolume
      USUS_19372
      USUS_229112
      USUS_3148192
      UKUK_11656
      UKUK_217869
      UKUK_3120184
      UKUK_47788

       

       

      My target output is below:

       

       

      It would have a single select filter for Site:

       

       

      selected Site = US_2

         

      MetricRank CountryRank Global
      Cost36
      Volume23

       

       

      Tooltips should be something like

       

      2 out of 3 sites in the country

      3 out of 7 sites globally

       

       

       

       

      Any ideas?

      Thanks!