1 Reply Latest reply on Aug 1, 2016 12:28 PM by Vasil Petkov

    One vs Many that share same dimension

    Jacob Kreider

      Hello,

       

      The attached example workbook has two tabs- one called 'One vs All' that uses a parameter and corresponding filter to compare error rate % of one game with that of all games.

       

      I am also trying to compare the game selected with the parameter/filter to only other games that share the same price (TicketPrice).  I tried this a few ways.

       

      First, I created a price select parameter and filter, but that forced me to have to change both the parameter to the game I wanted plus also change the price parameter to the corresponding price- an extra step I would like my end users to be able to avoid.

       

      Then, I tried creating a calculated field using LOD expressions instead of feeding a paramter into the Price Select calc field, but I have no idea what I'm doing with LOD expressions.

       

      All I can manage to get it to do is either compare one vs a single price that needs to be manually selected, or compare one to every other price individually, with all showing on the chart.

       

      How can I filter the comparison group to only those products with the same dimension as my target game?

       

      Thanks for any help.